Import to mySQL with foreign characters

Forum Moderators: open

Message Too Old, No Replies

Import to mySQL with foreign characters

txbakers

3:13 pm on Feb 26, 2007 (gmt 0)

Is there a special charset I need for the mySQL table to import things like accents, umlauts, etc. from the Excel file? I'd rather leave those in there than changing all those characters.

Thanks.

webdoctor

4:48 pm on Feb 27, 2007 (gmt 0)

What version of MySQL are you using?

How are you importing the data? (Via a client, or directly on the server?)

Have you read the MySQL charset documentation [dev.mysql.com] already?

encyclo

1:15 am on Feb 28, 2007 (gmt 0)

Also, what is the originating charset of the file to be imported? If you're using Windows, it will probably be encoded in windows-1252. However, that charset is not particularly web-friendly, ISO-8859-1 (which is very close to windows-1252) or UTF-8 would be a better choice.

txbakers

5:28 am on Feb 28, 2007 (gmt 0)

I'm using mySQL 5.1.

I'm also using mySQL-Front as the front end, and using the Import From Excel feature.

The current data is in Excel with the accents, umlauts, etc.

When I import, the error is "data too long" for that field. The accent causes it to fail. I remove the accent, all is fine.

I'd like to leave the accents and umlauts if possible.

Thanks.