Character set conversion from/to MySQL

[Bill]

Check out Trevor's library of database functions for this as I remember
seeing lots of UTF conversion functions there that I ignored.


On 5/27/07 11:13 AM, "Torbjörn Nordlindh" <tn at nul.se> wrote:

> 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
> 
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution

            |    |    |
           )_)  )_)  )_)
          )___))___))___)\
         )____)____)_____)\\
       _____|____|____|____\\\__
-------\                   /--------- http://www.bluewatermaritime.com
 ^^^^^ ^^^^^^^^^^^^^^^^^^^^^
  ^^^^      ^^^^     ^^^    ^^
       ^^^^      ^^^

24 hour cell: (787) 378-6190
fax: (815) 331-0838

Blue Water Maritime
P.O. Box 2087
Rio Grande, PR 00745