gordon.c Posted January 8, 2011 Share Posted January 8, 2011 Hello, I am building a multi language application which I would like to count with any possible kinds of characters. How do I set my mysql database and php document to be able to read all (or majority) of characters properly. Characters I have in mind are Russian Cyrillic, Chinese, Japanese, Corean, Czech, Slovak, etc. Link to comment https://forums.phpfreaks.com/topic/223760-is-there-an-ultimate-chracter-set/ Share on other sites More sharing options...
GrooN Posted January 8, 2011 Share Posted January 8, 2011 As far as I know UTF-8, supports... well... a lot, of different characters - it should support the language packs you listed Look here for further information: http://www.unicode.org/ Link to comment https://forums.phpfreaks.com/topic/223760-is-there-an-ultimate-chracter-set/#findComment-1156630 Share on other sites More sharing options...
gordon.c Posted January 9, 2011 Author Share Posted January 9, 2011 As far as I know UTF-8, supports... well... a lot, of different characters - it should support the language packs you listed Look here for further information: http://www.unicode.org/ Well I believe now I know everything there is to know about Unicode however I still dont know how to apply it to my PHP documents and mysql database... Tried a lot of combinations never being able to display all kinds of characters at once. Link to comment https://forums.phpfreaks.com/topic/223760-is-there-an-ultimate-chracter-set/#findComment-1157092 Share on other sites More sharing options...
GrooN Posted January 10, 2011 Share Posted January 10, 2011 You can send it as a header directly from PHP, or as a meta tag in your HTML head. <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> header("Content-Type: text/html; charset=UTF-8"); Link to comment https://forums.phpfreaks.com/topic/223760-is-there-an-ultimate-chracter-set/#findComment-1157320 Share on other sites More sharing options...
gordon.c Posted January 10, 2011 Author Share Posted January 10, 2011 Thx for help I found the source of my problem... I will post it for future refence. So I had my html/php document set to UTF-8 coding however I had my database reguest mysql_query("SET NAMES 'utf8'"); which apparently did not work that well so I had to use mysql_query("SET CHARACTER SET utf8"); Now it seems to work fine Link to comment https://forums.phpfreaks.com/topic/223760-is-there-an-ultimate-chracter-set/#findComment-1157461 Share on other sites More sharing options...
gordon.c Posted January 10, 2011 Author Share Posted January 10, 2011 after some testing there is one new issue, when I insert directly into mysql any characters from any char-set it renders fine on my php file however if I use my own forms to submit those characters it buggs again. How do I go about forms in terms of char coding? Link to comment https://forums.phpfreaks.com/topic/223760-is-there-an-ultimate-chracter-set/#findComment-1157468 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.