michael lee wrote:
> Hi,
>
> I have just downloaded Connector U (3.1.7). Since
> i encountered some problem on using the
> Traditional Chinese with Hong Kong extensions
> before, i have viewed the source and found
> following on StringUtil.java
>
>
> if (!parserKnowsUnicode
> &&
>
> (encoding.equalsIgnoreCase("SJIS") //$NON-NLS-1$
>
> ||encoding.equalsIgnoreCase("BIG5") //$NON-NLS-1$
>
> ||encoding.equalsIgnoreCase("GBK"))) {
> //$NON-NLS-1$
>
> if
> (!encoding.equalsIgnoreCase(serverEncoding)) {
> b =
> escapeEasternUnicodeByteStream(b, s, 0,
> s.length());
> }
>
>
> It seems that the charset BIG5_HKSCS and
> MS950_HKSCS should be included in the condition.
Michael,
The MySQL does not support those character sets, so while the workaround could be added to the driver, there is no guarantee that data encoded in BIG5_HKSCS and MS950_HKCS would survive intact once the server has parsed it. You might try instead storing the data as UTF-8.
-Mark
Mark Matthews
Consulting Member Technical Staff - MySQL Enterprise Tools
Oracle
http://www.mysql.com/products/enterprise/monitor.html