Skip to main content

Posts

Showing posts from May, 2013

Localization unicode issues in MySql

Problem : When you trying to use localizations in to you web system with MySql, You may face following problem.    "Incorrect string value: '\xE0\xB6\xB8\xE0\xB6\xBD...' for column 'gen_local_value_si' at row 1"    where gen_local_value_si is the column name which occurring the error. So the issue is the character encoding is not done well for Unicode. We need to specify the charterer encoding to "UTF-8" and Collate to "utf8_general_ci". Solution :  Simply set the character set and collate by executing of following command ALTER TABLE my_database.my_table MODIFY COLUMN gen_local_value_si VARCHAR(255)  CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;   Try on inserting localization values. If it's not work, then do the following configurations To check the variables, execute  following command mysql > show variables like 'char%' ; + --------------------------+----------------------------+ | Variable...