MySQL Trouble....

KIA CYPRUS · #1 (**permalink**) 08-30-05, 05:03 AM

hello every1...i'm having a bit of difficulty while converting my MS Access DataBase to MySQL...the problem is that my Access Data is in ARABIC and when converting it to MySQL i get the results in ??????? format, i.e the collation is in the wrong settings....
hope som1 out there can help me...
one more thing...i'm currently building a WebSite for an association and i need to use a Search Engine to access my database...my coding is PHP,,if it can change anything..

take care guyz...
thnx...
peace

NeverMind · #2 (**permalink**) 08-30-05, 06:25 AM

how are you transfering the data?

wheezy360 · #3 (**permalink**) 08-30-05, 12:54 PM

Your mysql tables are probably not set up with the right character/collation set. That is, you're trying to transfer characters from an arabic character set to what is probably the "latin1" character set. You'll probably need the "cp1256" character set, which contains the Windows Arabic collation.

Have a look here to read about MySQL's character/collation set handling.