bullchina Posted September 6, 2006 Share Posted September 6, 2006 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, Quote Link to comment https://forums.phpfreaks.com/topic/19877-accent-characters-and-moving-from-access-to-mysql/ Share on other sites More sharing options...
fenway Posted September 6, 2006 Share Posted September 6, 2006 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. Quote Link to comment https://forums.phpfreaks.com/topic/19877-accent-characters-and-moving-from-access-to-mysql/#findComment-87091 Share on other sites More sharing options...
bullchina Posted September 6, 2006 Author Share Posted September 6, 2006 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. Quote Link to comment https://forums.phpfreaks.com/topic/19877-accent-characters-and-moving-from-access-to-mysql/#findComment-87132 Share on other sites More sharing options...
fenway Posted September 6, 2006 Share Posted September 6, 2006 Indeed it is... latin1 covers the most frequently encountered special characters, so you should be fine. Glad you got it working. Quote Link to comment https://forums.phpfreaks.com/topic/19877-accent-characters-and-moving-from-access-to-mysql/#findComment-87179 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.