On Fri, Oct 21, 2011 at 12:39 PM, JAGANADH G <[email protected]> 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 _______________________________________________ ILUGC Mailing List: http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
