Hi all,

From my isql example:

> SQL> insert into utable values (_iso8859_1 'Reißbrett');

Please notice that I made a mistake here. The active Windows codepage was 850, which is not the same as iso8859_1. The 'ß' is in a different spot (E1, not DF). As a result, what was *really* inserted into the table was the UTF8 sequence C3 A1 ('á'), not C3 9F ('ß').

Of course, when I read this back under connection character set iso8859_1, Firebird kindly sent me the 'á' as an E1 byte, and it showed up on my screen as a 'ß' - because of the 850 codepage. It wasn't until I looked at the data with FlameRobin that I discovered my mistake.

Moral: know your codepage! :-)


Paul Vinkenoog