[odb-users] 22021: ERROR: invalid byte sequence for encoding "UTF8": 0x93

[Kenneth Moses]

Hello Boris,

Thank you for the quick response. I double checked that all systems
character encoding are set to UTF-8. Unfortunately, that does not seem to
be the issue here. I have done some drastic measures thus far such as
re-installing PostgreSQL to see if that would fix the problem but no luck.
I will let you know if I come up with a solution.

-Ken

On Mon, Jan 19, 2015 at 8:26 AM, Boris Kolpackov <boris at codesynthesis.com>
wrote:

> Hi Kenneth,
>
> Kenneth Moses <kcm7 at case.edu> writes:
>
> > I am running a PostgreSQL database and compiling ODB with gcc 4.9.2.  The
> > code compiles just fine. However, I receive the above error when
> attempting
> > to persist an object. I have put a standard tracer within the transaction
> > and the error occurs every time at the same line. The SQL line is an
> INSERT
> > INTO command and does not appear to have any non-standard text in it. I
> > have run the exact same code (it was pulled from a repository online) on
> > several other machines and I do not receive the error.
>
> Since this works on other PostgreSQL setups, my guess would be that the
> default TEXT data type's character encoding is UTF-8 on the setup that
> gives you the error while on the other machines it is something else
> (e.g., ISO-8859-1).
>
> Boris
>



-- 
*Kenneth C. Moses*

*Ph.D. Candidate*
*Case Western Reserve University*
*(240)620-6307*