[UPHPU] LOAD DATA LOCAL INFILE, utf-16

Orson Jones orson.uphpu at afriskito.net
Thu Aug 21 22:56:07 MDT 2008


Wade Preston Shearer wrote:
> I have a script that leads a CSV into my MySQL database via LOAD DATA
> LOCAL INFILE. It does not work when the file is encoded UTF-16. Is this
> because LOAD DATA LOCAL INFILE can't handle a file encoded that way or
> due to some configuration on the database it's trying to insert to?

The mysql docs make it sound like it probably won't work unless your
mysql is version 5.1.17 or higher. Also, check what character sets are
available "SHOW CHARACTER SET"

Mine lists ucs2, but not utf-16

Orson



More information about the UPHPU mailing list