Using different character set than "lattin1"

--Boundary_(ID_J6WXyx8zPtvyo+9uvjDd6A)
Content-type: text/plain; charset=ISO-8859-8-I; format=flowed
Content-transfer-encoding: 7BIT

Hi All,

While connecting, MyODBC changes it's default connection character set
to "lattin1".

I needed to add the following code to change it back:


SELECT @@character_set_database AS CHARSET


To read the database character set and then use it in:


SET CHARACTER SET


I still have a problem with Crystal Reports ODBC connection. I can not
interfere with this ODBC connection so I get garbage. How about adding
the character set parameter as part of MyODBC connection properties?


Thanks,

Reuven Nisser


--Boundary_(ID_J6WXyx8zPtvyo+9uvjDd6A)--