How to use charcters not supported by default OS in MySQL?

Question

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

Answer 1

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.