Re: problem using non english charsets
Posted by: Josh Chamas
Date: November 17, 2004 02:09AM

Alon Agmon wrote:
> hi
> we have an application running on Jboss 4.0 with
> J/connector 3 with MS sql
> we are trying to migrate to MySql
> oh and i forgot we are using hebrew characters
> ....(disaster)
> till now with microsoft i simply used NCHAR for
> the hebrew fields -
> we are just having extreme difficulty to use it
> with mysql
> 1. we tried to use utf-8 as MySql default
> 2.we tried to use ucs2 as MySql default
> 3............ to set these charsets to each table
> too
> 4..............every collation with utf8/ucs2 -
> _bin/_general_ci
> everything we just dont know what to do
> all we get is gibberish ....

To make sure the data is able to get into MySQL at all, you might use binary columns at first like BLOB, TINYBLOB, VARBINARY, etc. Then when you make sure you can get the data in/out cleanly, you might try converting the column to a character set type that you want explicitly supported and work through the issues from there. I am merely proposing a troubleshooting methodology you can use here.

If you do not get adequate help in the forum, you might try escalating this issue through support and I am sure they can help troubleshoot this with you.



Josh Chamas
Director, Professional Services
MySQL Inc.,
Get More with MySQL!

Edited 1 time(s). Last edit at 11/17/2004 02:15AM by Joshua Chamas.

Options: ReplyQuote

Written By
November 09, 2004 09:25AM
Re: problem using non english charsets
November 17, 2004 02:09AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.