LC Server UT08 Encode Error

[Rick Harrison]

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