I have written one function which inserts the data into database table. In some of the columns I have special characters like japanese character , El Año , ¿Cómo estás? etc like that. The query is not storing the special characters. Like in El Año it saves as “El A” so once the special char appears its cut off the rest of the word.If the word starts with special character like “¿Cómo estás?” the whole word is not getting inserted. In php query I can use this query functions i.e mysql_query(“SET NAMES ‘utf8’”); but in yii framework how to save this kind of special characters. The special character column is set as utf8_unicode_ci in database structure.
I’d guess either PHP is using the wrong character set, or the browser is using the wrong character set. Have a look at the various suggestions here and see if any of them help: