List:MySQL and Java« Previous MessageNext Message »
From:hory Date:January 15 2004 6:48pm
Subject:Problems with unicode
View as plain text  
Hi!

I'm trying to write into az innodb-base utf8-encoded mysql table
(4.1.1-alpha), using connector/j 3.0.10.
It works well, the only problem is when I try to write some national
characters (0xC591 for example, little-endian), it stores an '?' character
instead. Funny is, it recognises 0xc591 as a multi-byte character, but when I
select that field, it returns a single byte which is the question mark in
ascii encoding (0x3f).

I've tracked down the jdbc source until send(), where it actually sends the
sql command to mysql server, but the beforementioned character is still there
at that point.

So it seems it's lost somewhere else, but where? Could someone help me?

(using a stable version of mysql is not an option, since we need ordering and
toupper/tolower of national characters of europe and russia at the same time)

thanks,
hory

Thread
Problems with unicodehory15 Jan
  • Re: Problems with unicodehory15 Jan
    • Re: Problems with unicodeMark Matthews16 Jan
      • Re: Problems with unicodehory16 Jan
        • Re: Problems with unicode [SOLVED]hory16 Jan
          • Re: Problems with unicode [SOLVED]Mark Matthews16 Jan
            • Re: Problems with unicode [SOLVED]hory16 Jan
              • Re: Problems with unicode [SOLVED]hory16 Jan
        • Re: Problems with unicodeAdam Hardy25 Jan
  • Transaction/Autocommit problemClark Wright16 Jan