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@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@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
