LC Server UT08 Encode Error
bobsneidar at iotecdigital.com
Fri Sep 13 11:01:16 EDT 2019
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.
> 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
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
More information about the use-livecode