Re: [GENERAL] Trouble with UTF-8 data

2008-01-18 Thread Janine Sisk
On Jan 18, 2008, at 12:00 AM, Albe Laurenz wrote: 0xEDA7A1 (UTF-8) corresponds to UNICODE code point 0xD9E1, which, when interpreted as a high surrogare and followed by a low surrogate, would correspond to the UTF-16 encoding of a code point between 0x88400 and 0x887FF (depending on the value

[GENERAL] Trouble with UTF-8 data

2008-01-17 Thread Janine Sisk
Hi all, I'm moving a database from PG 7.2.4 to 8.2.6. I have already run iconv on the dump file like so: iconv -c -f UTF-8 -t UTF-8 -o out.dmp in.dmp But I'm still getting this error when loading the data into the new database: ERROR: invalid byte sequence for encoding UTF8: 0xeda7a1