Jump to content

Archived

This topic is now archived and is closed to further replies.

bullchina

accent characters and moving from access to mysql

Recommended Posts

i have a database that i am creating in access, and lots of entries have accent characters. every time i want to update the web version of the database, i export the access to mysql, with a script from mysql.com called access2mysql.txt or something like that.

anyways, the characters come up as question marks or something weird in phpMyAdmin, and i have no clue what to change to get it to work properly. i assume it's something to do with character encoding, but i haven't found anything concrete that fits this same situation. i'm kind of a newbie to all this database stuff, thanks for the help,

Share this post


Link to post
Share on other sites
I know nothing of access, or how it stores special characters, but this is a collation issue.  There is a lot of info in the refman.

Share this post


Link to post
Share on other sites
i went ahead and tried selecting "latin1" in the mysql import dialog, and the accent characters display fine. weird. i hope that's a real solution. thanks for your help.

Share this post


Link to post
Share on other sites
Indeed it is... latin1 covers the most frequently encountered special characters, so you should be fine. Glad you got it working.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.