On 03/23/11 4:32 PM, Nathan Davalos wrote:
...
SET CLIENT_ENCODING TO 'WIN1251';
copy tmpintermediate from 'thefile.txt';
Sample contents of thefile:
230002 Alto Desempeño, S.A. De C.V.
When using WIN1251 or WIN1252 I get nothing in the second field, it just
ignores the data. Same thing for LATIN-1.
When using UTF8 for client encoding I get this message:
ERROR: invalid byte sequence for encoding "UTF8": 0xf16f2c20
CONTEXT: COPY tmpintermediate , line 1
what is the byte (binary) encoding of the file? in hex,
ñ in win1251 == (no such character. win1251 is cyrillic)
ñ in win1252 == F1
ñ in UTF-8 == C3 B1
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs