Topic: Help with storing east asian characters in mySQL
Hi im new to ruby on rails please forgive me if my question has been posted before.
so i've generated a scaffold and have been able to successfully store data in the fields. That is until i tried to store chinese characters.
the mySQL fields are already set to UTF-8 and UTF-8 bin for collate.
the following error came up
Mysql::Error: Incorrect string value: '\xE4\xB8\xAD\xE6\x96\x87' for column 'content' at row 1: UPDATE `anouncements` SET `content` = 'chinese testing 中文', `title` = 'testing chinese' WHERE `id` = 6
Appreciate any help!