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.
Regards,
Josh
Josh Chamas
Director, Professional Services
MySQL Inc., www.mysql.com
Get More with MySQL!
http://www.mysql.com/consulting
Edited 1 time(s). Last edit at 11/17/2004 02:15AM by Joshua Chamas.