URLEncode accent-i

[Pierre Sahores]

Hi Jacqueline,

When you say « I need to send this word to the server: Santería » :

Are you speaking from the web server or from the database server ?

If the database server is your problematic target, witch one are you using :

PostgreSQL;
MySQL;
SQLite;
other ?

I got, times ago such kind of troubles against PostgreSQL before solving them definitively in using a simple and trustable solution i can explicit if appropriate.

Best Regards,

Pierre 


Le 25 juin 2014 à 21:35, J. Landman Gay <jacque at hyperactivesw.com> a écrit :

> I had high hopes but converting to ISO didn't work. That yields: Santer%EDa
> 
> The server wants UTF8 and I think (but am not sure) that I need to get:
> Santer%C3%ADa
> 
> I haven't found the right combination of uniEncode/Decode and urlEncode that doesn't make a mess of the string. Does anyone know how to do this without manually replacing every possible combination of high-ascii characters?
> 
> On 6/23/2014, 4:26 PM, Matthias Rebbe | M-R-D wrote:
>> Hi,
>> 
>> this is because you are working on Mac. You have to convert it first from Mac to Iso.
>> 
>> A URLencode(mactoiso("Santería"))
>> 
>> should do.
>> 
>> Regards,
>> 
>> Matthias
>> 
>> 
>> Am 23.06.2014 um 22:25 schrieb J. Landman Gay <jacque at hyperactivesw.com>:
>> 
>>> I need to send this word to the server: Santería
>>> 
>>> When urlEncoded, LiveCode produces: Santer%92a
>>> 
>>> The encoded character is a backslash instead of the accent-i. The server doesn't recognize that, and online URL encoders give various different encodings depending on what source I designate (ascii, UTF8, UTF16, etc.)
>>> 
>>> Where did LC get %92, and how would I correct the encoding? I'm using LC 6.6.1, we're not ready to make a switch yet.
>>> 
>>> --
>>> Jacqueline Landman Gay         |     jacque at hyperactivesw.com
>>> HyperActive Software           |     http://www.hyperactivesw.com
> 
> -- 
> Jacqueline Landman Gay         |     jacque at hyperactivesw.com
> HyperActive Software           |     http://www.hyperactivesw.com
> 
> 
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode

--
Pierre Sahores
mobile : 06 03 95 77 70
www.sahores-conseil.com