
However I have only about 10 columns in whole database which use Chinese. I have changed all my fields to UTF-8, so that I can simply store anything anywhere Chinese. But as I had to add new field to the system to show Chinese info to employees who cannot handle English as their first language. I had all my tables as default latin1 with collation as latin1_swedish_ci. Chinese is used only to store additional information like address and Chinese specific name of employee.

I am working on web application which has partial English and partial Chinese simplified as text.Įnglish is mainly used in the whole system.
