confusing invalid UTF8 byte sequence error

Started by Peter Eisentrautover 14 years ago3 messages
#1Peter Eisentraut
peter_e@gmx.net

Has anyone else ever found this error message confusing:

ERROR: 22021: invalid byte sequence for encoding "UTF8": 0xdb24

I think what is really meant is better expressed like this:

ERROR: 22021: invalid byte sequence for encoding "UTF8": 0xdb 0x24

Otherwise it looks like a codepoint or a 16-bit word (endianness?) or
who knows what.

In reply to: Peter Eisentraut (#1)
Re: confusing invalid UTF8 byte sequence error

Has anyone else ever found this error message confusing:
ERROR: 22021: invalid byte sequence for encoding "UTF8": 0xdb24
I think what is really meant is better expressed like this:
ERROR: 22021: invalid byte sequence for encoding "UTF8": 0xdb 0x24
Otherwise it looks like a codepoint or a 16-bit word (endianness?) or
who knows what.

Talking about this error, I find the lack of context in this error message
more confusing... relative position or surrounding charachters would be
really helpful, when searching for a problem with encoding...

-- Valentine Gogichashvili

#3Robert Haas
robertmhaas@gmail.com
In reply to: Valentine Gogichashvili (#2)
Re: confusing invalid UTF8 byte sequence error

On Mon, Aug 29, 2011 at 11:03 AM, Valentine Gogichashvili
<valgog@gmail.com> wrote:

Has anyone else ever found this error message confusing:
ERROR:  22021: invalid byte sequence for encoding "UTF8": 0xdb24
I think what is really meant is better expressed like this:
ERROR:  22021: invalid byte sequence for encoding "UTF8": 0xdb 0x24
Otherwise it looks like a codepoint or a 16-bit word (endianness?) or
who knows what.

Talking about this error, I find the lack of context in this error message
more confusing... relative position or surrounding charachters would be
really helpful, when searching for a problem with encoding...

+1. Twiddling with the exact wording of the error message doesn't
seem likely to make a huge difference in terms of usability, but
providing some more context would be *really* helpful.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company