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. Quote Link to comment 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/ Quote Link to comment 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. Quote Link to comment 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"); Quote Link to comment 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 Quote Link to comment 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? 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.