[Ilugc] MySQL insert Unicode characters
- From: gurukumara@xxxxxxxxx (Kumara Guru)
- Date: Sun, 23 Oct 2011 00:54:38 +0530
On Fri, Oct 21, 2011 at 12:39 PM, JAGANADH G <jaganadhg at gmail.com> wrote:
when I inserted the data all the non english text were converted to "???".
I tries setuung collocation as utf8_common_cli , SET CHARACTER SET utf8; etc
.. still I am failing to repserve the original data.
utf8_common_cli ? Never heard that one before; even SHOW COLLATION is
not listing it. Did you mean utf8_general_ci ?
You may have to use utf8_unicode_ci (which implements the Unicode
Collation Algorithm as described here:
http://www.unicode.org/reports/tr10/ )
Regards,
Kumaraguru
Other related posts: