Re: loading 0x00A0 into mysql

2014-01-07 Thread Dobromir Velev
Hi, Can you try passing the dump file through hexdump or some binary editor to see if the data is there. Most text editors will treat 0x00 as end of string and this most likely this is causing the problem. Additionally you can try running the import with --default-character-set=utf8 in case t

Re: loading 0x00A0 into mysql

2014-01-06 Thread Dave Howorth
Thanks for the reply, and I apologize because I expect I've broken threading. The list isn't mailing the posts to me, so I've nothing to reply to. I've had to cut and paste from the web archive... 2014/01/06 12:18 +, Dave Howorth >> Everything appears to work except that text fields

Re: loading 0x00A0 into mysql

2014-01-06 Thread hsv
2014/01/06 12:18 +, Dave Howorth Everything appears to work except that text fields containing a Unicode non-breaking space (0x00A0) are truncated just before that character. I can see the field in the dump file and it looks OK, but it doesn't all make it into the new database. <

loading 0x00A0 into mysql

2014-01-06 Thread Dave Howorth
Hello, I'm trying to make a copy of a mysql database and having an issue loading fields containing a particular character. I've taken a dump using mysqldump and then try to load it into a new database using mysql --user=me test_database < dump_file Everything appears to work except that text f