New answers tagged

0

I figured that I would answer this now that I found the solution. Because I am using Java to run the LOAD DATA INFILE via JDBC the JDBC driver seems to be checking the collation at the DB and not the actual table being loaded as it is parsing the file. So you can't have the DB set to UTF-8 and have a Latin collated table as you would be able to do with an ...


0

Is mysql_json_data.py input or output or code or a dump? 'MA\xd1ANA... has Ñ encoded in latin1 (and perhaps escaped for display?) 'Ma\xc3\xb1ana... has ñ encoded in utf8 (and perhaps escaped for display?) If you have one file with both in it, you have a mess. The former will probably be truncated as you attempt to put it into your MySQL table. The latter ...



Top 50 recent answers are included