[Hsqldb-user] strange unicode behaviour

[Dean O. <de...@ki...>]

Hi,

Just thought I'd mention some strange behaviour I have encountered when
trying to insert unicode characters within an INSERT or UPDATE statement (
Hsqldb v2.2.9).

UPDATE foo SET bar = U&'\00E9'

As far as I'm aware, this should translate to the é character. However it
seems to convert to the equivalent of u000E.

It turns out that shifting the characters one to the left seems to produce
the desired result (although you are still forced to enter a redundant 4th
character which seems to get ignored). ie:

UPDATE foo SET bar = U&'\0E90'

The above produces the desired result of é
To me this seems a bit odd? Just thought I'd mention it in case it's a bug.

Cheers,
Dean