windows - macOs char problems

[Klaus Major]

Bonjour Sylvain,

> Hello,
> 
> I have a MySQL database. I develop some applications with revolution. 
> Those applications have to run with windows and MacOS 9.2.
> 
> And of course, I have charset problems that I can't solve.
> 
> example:
> 
> win numToChar(160) is a space (I don't know the exact word, but I mean 
> that you can't break it!)
> I use it to update my database through my windows revolution 
> application.
> But if I load data from my database through my MacOS revolution 
> application, this char is displayed as 
> 
> --> 
> 
>  --> ,
> 
> and so on...
> 
> 
> How can I prevent that ?

Don't know if this is useful to you, but i always use a
hand-made function to serve correct text to win and mac:
Presuming the text comes from a windows-pc !!!

You get the picture...

function cleanuptext the_text
    if the platform contains "win" then
      return the_text
      ## no need to convert...
    end if
   return isotomac(the_text)
   ## convert to mac charset...
end cleanuptext

And then i call it with:

...
put cleanuptext(fld "the returned text from mySQL") into xxx
...

Hope this helps...


Regards

Klaus Major
klaus.major at metascape.org