[GLLUG] UTF-16 question

[Mark Szidik/mlc]

I have a MySQL dump file that same from a OSX machine, here is what file
has to say:

$ /usr/bin/file mla-drup.sql
mla-drup.sql: Big-endian UTF-16 Unicode English character data, with very
long lines


when I try to import the file I get this:
$ mysql -umlaweb3 -p mla < mla-drup.sql
Enter password:
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check
the manual that corresponds to your MySQL server version for the right
syntax to use near '' at line 1

I assume that mysql can't read the UTF16 encoding.

Finally we get to my question:  how do I convert UTF-16 to UTF-8 or
whatever we call ASCII these days?


Thanks,

---
Mark Szidik, CIO
Michigan Library Consortium
1407 Rensen Street, Suite 1,  Lansing, MI 48910-3657
Ph:800.530.9019 x117   Fax:517.492.3881
Ph:517.492.3817
MLC - Partnerships. Solutions. Excellence.