LC Server UT08 Encode Error

[Bob Sneidar]

Based on the source of the data, I'm going to say it's an encoding issue. I cannot imagine that pages is embedding non-printing characters that get past the clipboard. 

Bob S


> On Sep 12, 2019, at 18:21 , 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