Character set conversion from/to MySQL

[Torbjörn Nordlindh]

Hi,

I'm going to make a database browser/editor for my MySQL databases.

All my MySQL databases and tables are set up to use UTF-8 only. Still  
everything is delivered in ISO-8859-1 when I read data into  
Revolution (2.8.1).

I can't find how to tell Revolution what character set it should use  
in communication with MySQL.

Right now I have to do something like this:

if the platform contains "Mac" then
     put ISOToMac(theText) into theText
end if

and the opposite before I want to write to the database.

I expected the database driver to follow the character set as defined  
in MySQL field, table or database.


Torbjörn