On 7/4/2014 2:12 AM, sunpeng wrote:
> Thank you, friend, I use --hex-blob :
> mysqldump -v -nt --complete-insert=TRUE --compatible=postgresql
> --default-character-set=utf8 --skip-add-locks --compact
> --no-create-info --skip-quote-names --hex-blob -uroot -p test
> videorecresult >dbdata.sql
> to dump mysql data.
> And replace blob data "0x...." into "E'\\xx....'" to load data into
> postgresql.
regardless of all that, 0xFF is not a valid UTF8 character code. perhaps
you should store the data in a postgres BYTEA, or at least use character
encoding SQLASCII (which is to say, no encoding, bytes in == bytes out.)
--
john r pierce 37N 122W
somewhere on the middle of the left coast