I believe many of the web programmers have been troubled by character coding. Customers require a number of Chinese simplifications, Chinese Traditional, Japanese, Korean and other versions. It is no longer able to meet the requirements using the original GB2312 character set. At this time, UTF-8 encoding is preferred. But when using UTF-8, new issues, how to design a database structure? How to write data and reading data does not appear? Why can't you query?
I have also experienced such a process, there is some experience in the process of solving, in the near future, I will organize it, and put it out to share with you.