LC Server UT08 Encode Error

[Dar Scott Consulting]

When you Zap Gremlins, are you removing non-ASCII or converting to ASCII? Maybe you can do the same thing before saving to the db. 

Codes 0xca 0x59 do form an invalid UTF-8 sequence. They are good letters in both Latin-1 and CP1252, so I'm not getting a hint.

Wild, wild guess... Are you using an accept-charset attribute in <form>? Maybe fiddling with that will help.

> On Sep 12, 2019, at 7:21 PM, Rick Harrison via use-livecode <use-livecode at lists.runrev.com> wrote:
> 
> I am having a problem with LC Server
> posting data to my Postgresql database.
> (LC Server version 9.0.4)
> 
> If I type into a form field such as for
> a field named “description”, and submit
> the field, it goes into the database without
> any problems whatsoever.
> 
> If I compose a description in an application
> such as Apple’s Pages or in Text Edit, and
> then copy and paste the text into the
> description field.  It throws an error.
> 
> ERROR: invalid byte sequence for
> encoding "UTF8": 0xca 0x59 (0)
> 
> Of course due to this error the
> record never gets written out to
> the database.
> 
> I know this error is due to gremlins
> in the text because if I zap gremlins 
> with BBEdit and then copy and
> paste into the field, everything
> works fine!
> 
> I’m sure that other users will
> probably use a copy and paste
> method at some point, so I need
> to scrub the data somehow to
> prevent the error from occurring.
> 
> Or is this an encoding/decoding
> problem requiring some other
> solution?
> 
> Suggestions?
> 
> Rick
> _______________________________________________
> 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
>