client_encoding error
Whilst trying to migrate one of our tables to postgres we get the
following error:
invalid byte sequence for encoding "EUC_JP"
: 0x9c32
HINT: This error can also happen if the byte sequence does not match
the enccding expected by the server, which is cont
rolled by "client_encoding".
Does anyone have any idea why this might be? The data cing into the
table should be plain ASCII
Glyn Astill
___________________________________________________________
Want ideas for reducing your carbon footprint? Visit Yahoo! For Good http://uk.promotions.yahoo.com/forgood/environment.html
Glyn Astill wrote:
Whilst trying to migrate one of our tables to postgres we get the
following error:invalid byte sequence for encoding "EUC_JP" : 0x9c32
HINT: This error can also happen if the byte sequence does not match
the enccding expected by the server, which is controlled by "client_encoding".Does anyone have any idea why this might be? The data cing into the
table should be plain ASCII
It means that there is a string in your data which is incorrect
in your client encoding, which is EUC_JP.
You can only enter correctly encoded strings, everything else
will produce an error.
Your data is not plain ASCII, because the byte 0x9c is not
(0x9c > 0x7f).
Yours,
Laurenz Albe