Margus Väli <[EMAIL PROTECTED]> writes:
> COPY command tries to create a buffer too large in size when the
> file copied is larger than about 500 bytes.
Can anyone else reproduce this? I did the following with a fairly
recent CVS snapshot:
1. Copied the supplied text data to a file, fixed up the extra
newlines so that COPY doesn't bail out
2. Created a new database with encoding = unicode
3. Create a table "marksona" in that DB with the supplied schema
4. I then got the following:
unicode_test=# copy marksona from '/home/nconway/copy_input.asc' with delimiter '|'
null as '';
ERROR: Unicode characters greater than or equal to 0x10000 are not supported
CONTEXT: COPY marksona, line 12, column sona: "Balti Sõjaväeringkonna Ülemjuh"
5. If I load the data into a SQL_ASCII encoded DB, the COPY
command succeeds.
However, I know absolutely nothing about Unicode, so perhaps I've
mucked something up.
-Neil
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
