Using different character set than "lattin1"

[Reuven Nisser]

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 <CHARSET>


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