Re: 7.3.1 UTF-8 bug(?) and 7.2.x Charset compatibility

Achilleus Mantzios wrote:
> b) NOT GREEK RELATED!
> With database_encoding set to SQL_ASCII, the server converts these wierd
> 2 chars (0xA0 0x0A) to UTF-8, and then the driver simply fails.
>
> I think you should deal with problem b).
> To create a test case is easy.
> Create a SQL_ASCII database, then insert these 2 chars in a text column
> (having typed these two chars with some utility like khexedit),
> and then out.println this string.
>

Achilleus,

I want to understand what you mean by 'deal with the problem'. Since
0xA0 and 0x0A are invalid SQL_ASCII characters, the only thing I can
think of is to produce a better exception in this case. So instead of
the current ArrayIndexOutOfBounds exception, this case would throw a SQL
Exception with a message something like: "Invalid characters were
found. This is most likely caused by stored data containing characters
that are invalid for the character set the database was created in. The
most common example of this is storing 8bit data in a SQL_ASCII database."

thanks,
--Barry