by Salocin.TEN. (www.salocinten.net)

Question by Ravi K: How to use charcters not supported by default OS in MySQL?
Dear all,
I am not able to insert/select data which are not supported by default Windows system in MySQL. I couldn’t get success even after changing the table’s character set into “utf-8″ and collation into “utf8_unicode_ci”. For example “中文聽說”, I could not insert characters like this in MySQL 4.1.
Is it necessary to do OS level changes to accept foreign characters in MySQL?
Kindly help me to solve this problem

Best answer:

Answer by ♥HotIce♥
Go through the following articles they might be of help to you:

http://dev.mysql.com/tech-resources/articles/4.1/unicode.html

http://www.onlamp.com/pub/a/php/2004/03/18/php_foundations.html

Add your own answer in the comments!

Question by Ravi K: How to use charcters not supported by default OS in MySQL?
I am not able to insert/select data which are not supported by default Windows system in MySQL. I couldn’t get success even after changing the table’s character set into “utf-8″ and collation into “utf8_unicode_ci”. For example “中文聽說”, I could not insert characters like this in MySQL 4.1. Kindly help me sort this problem

Best answer:

Answer by John J
Where does the information from the MySQL table need to be rendered? If you only need to display this on a web page it might be best to encode the information (using the % codes) so that it will render in a web page and not have issues in the database.

Give your answer to this question below!

Question by Ravi K: How to use charcters not supported by default OS in MySQL?
I am not able to insert/select data which are not supported by default Windows system in MySQL. I couldn’t get success even after changing the table’s character set into “utf-8″ and collation into “utf8_unicode_ci”. For example “中文聽說”, I could not insert characters like this in MySQL 4.1. Kindly help me sort this problem.

Best answer:

Answer by iammisc
use linux.

Add your own answer in the comments!