Help with mysql and foreign characters
Posted: Sat Jan 09, 2010 7:44 am
Hi guys
I am making something that involves putting and getting korean characters into a mysql database and I came across a problem. When you insert some korean characters, they all change into some strange symbols like '����'. I thought it might be fine once I get and display it on a html page, but it turned into some other strange symbols and you can't read them whatsoever.
I changed the Collation in my tables to different character sets including utf-8_unicode_ci, euckr_bin and euckr_korean_ci, but that didn't help either. What do I have to do to make my database allow foreigh character sets to be transferred safely?
I am making something that involves putting and getting korean characters into a mysql database and I came across a problem. When you insert some korean characters, they all change into some strange symbols like '����'. I thought it might be fine once I get and display it on a html page, but it turned into some other strange symbols and you can't read them whatsoever.
I changed the Collation in my tables to different character sets including utf-8_unicode_ci, euckr_bin and euckr_korean_ci, but that didn't help either. What do I have to do to make my database allow foreigh character sets to be transferred safely?