Jump to content


Photo

accent characters and moving from access to mysql


  • Please log in to reply
3 replies to this topic

#1 bullchina

bullchina
  • Members
  • PipPip
  • Member
  • 19 posts
  • LocationHouston

Posted 06 September 2006 - 09:08 AM

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,

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 06 September 2006 - 01:37 PM

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.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#3 bullchina

bullchina
  • Members
  • PipPip
  • Member
  • 19 posts
  • LocationHouston

Posted 06 September 2006 - 02:37 PM

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.

#4 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 06 September 2006 - 03:35 PM

Indeed it is... latin1 covers the most frequently encountered special characters, so you should be fine. Glad you got it working.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users