cola Posted February 25, 2009 Share Posted February 25, 2009 I need to get of content couple multilanguage and put them in database. But i can not fix problems with foreign characters (like chinise, greek, russian, french etc) For example in database for chinese characters i get this: Êס¡¡¡Ò³ ÐÂÎÅ ÆÀÂÛ ÊÓƵ ÎÄ» mysql set up to utf-8, my php script is set up for utf-8. I also try to convert my string to UTF8 with mb_convert_encoding ($page, "UTF-8") but i get also some wierd chars. Is there some other way to convert characters propriety. Google showing that pages ok and i need to get same. Can anybody explain how i can do this? Thank you Quote Link to comment Share on other sites More sharing options...
cola Posted February 25, 2009 Author Share Posted February 25, 2009 For example i need to store content of www.chinataiwan.org/ into mysql database. But i store some wired chars. This page using charset gb2312. I have more about 20 pages with different languages and charset. How i can convert content of those pages to get right characters in database smilar like they look in Google. i tray with utf-8 and mb but i do not get what i want I need help urgent if someone have some idea i please u to help me thnks Quote Link to comment Share on other sites More sharing options...
blintas Posted February 25, 2009 Share Posted February 25, 2009 Hmmm that's tough, I've had similar issues in the past. What I typically do is setup a database for each language, but understand that might not be an option for you.... Quote Link to comment Share on other sites More sharing options...
cola Posted February 25, 2009 Author Share Posted February 25, 2009 Thanks no is not i need to sotore all in one table if is possible, one some page have two languges. Quote Link to comment Share on other sites More sharing options...
cola Posted February 25, 2009 Author Share Posted February 25, 2009 anyone can tell me it is is possible and if not what is alternative? Quote Link to comment Share on other sites More sharing options...
Mark Baker Posted February 25, 2009 Share Posted February 25, 2009 You've set the database to UTF-8 encoding, but are the individual tables where you store the data set to UTF-8 as well? Quote Link to comment Share on other sites More sharing options...
cola Posted February 25, 2009 Author Share Posted February 25, 2009 yes my tables are utf-8 Quote Link to comment Share on other sites More sharing options...
cola Posted February 25, 2009 Author Share Posted February 25, 2009 anyone have some idea how to make this? I need this urgent thnks Quote Link to comment 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.