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

[Kenneth Moses]

Hello Boris,

After many days of trying to track down the problem I finally discovered
the issue. It came down to an uninitialized variable. Simple problem that
caused a big headache!

Cheers,

Ken

On Mon, Jan 19, 2015 at 12:02 PM, Kenneth Moses <kenneth.moses at gmail.com>
wrote:

> 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 <%28240%29620-6307>*
>



-- 
*Kenneth C. Moses*

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