>>>> 2014/01/06 12:18 +0000, 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.
<<<<<<<<
Well, there are too many aspects to this, but the first is the character set
that "mysql" expects for input. If, say, it is USASCII (note that between the
character set that "mysql" takes for input and the character set in the table
no association is needful), the "nbsp" is out of range. (It is, of course, not
nice if "mysqldump" yields an output that "mysql" cannot read.) Try entering it
with some escape-sequence (this one is based on the original SQL with features
from PL1, not from C, which MySQL supports if 'ANSI' is in "sql_mode"):
'some text ... ' || X'A0' || ' ... more text ...'
or (slightly less PL1)
CONCAT('some text ... ', X'A0', ' ... more text ...')
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql
