Urgent (desperate) cry for help...

[Eric Chatonet]

Hi Ton,

Your problem seems to come from the fact you entered the data on a  
Mac and then it works correctly on a Mac :-)
When you go to Windows you have to translate ASCII values:

if the platform = "Win32" then put MacToIso(tData) into tData

Hope this helps.

Best Regards from Paris,

Eric Chatonet.

Le 28 juil. 05 à 14:58, Ton Kuypers a écrit :

> I know I'm doing something wrong, there has to be a better way, but  
> I just can't figure out what I'm doing wrong...
>
> Situation:
> - mySQL 4.1 running on a windows server
> - RR 2.6 OSX & Windows XP
> - Clients need to be Mac OS9, Mac OS-X and Windows XP
>
> I started development on the OS-X. Data in a field on a card needs  
> to be stored in the database.
> No problem there for regular text, but when entering text with  
> special chars in, it's a no-go... The word "Coördinator" appears in  
> the database as "Co".
>
> In a clever moment (at least that's what I thought), very early in  
> the project, I implemented the URLencode and URLdecode functions to  
> get rid of this pesky little problem.
>
> Then D-Day arrived: We had to install at the client the first beat- 
> version of the program, to start testing.
>
> First the OS-X Macs: Works like a charm.
> Then the Windows machines... No way of getting the data in the  
> correct way out of the database!
>
> URLencode("Coördinator") on OSX stores "Co%9Ardinator" in the database
> URLencode("Coördinator") on Windows stores "Co%F6rdinator" in the  
> database
> URLdecode of the Mac-encoded data on the PC obviously returns the  
> wrong data :-((
>
> The tables in mySQL are set to accept UTF-8, when I enter the text  
> manually there is no problem with special chars, so it is RR  
> needing something special.
>
> Anyone, HELP, PLEASE!!!!
>
> - Waht is the best way to communicate with mySQL?
> - Why is the URLencode different on both platforms WITHOUT ANY  
> NOTIFICATION IN THE MANUAL?
> - And of course: What is the proper way to enter and retrieve data  
> in and out a mySQL?
>
> The URLencode/decode stuff shocked me, the main problem must be  
> something stupid...
>
> Many thanks in advance,
>
>
> Ton Kuypers
> Digital Media Partners bvba
> Tel. +32 (0)477 / 739 530
> Fax +32 (0)14 / 71 03 04
> http://www.dmp-int.com
>
>
>
> _______________________________________________
> 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

----------------------------------------------------------------
So Smart Software

For institutions, companies and associations
Built-to-order applications: management, multimedia, internet, etc.
Windows, Mac OS and Linux... With the French touch

Free plugins and tutorials on my website
----------------------------------------------------------------
Web site        http://www.sosmartsoftware.com/
Email        eric.chatonet at sosmartsoftware.com/
Phone        33 (0)1 43 31 77 62
Mobile        33 (0)6 20 74 50 86
----------------------------------------------------------------