Hi "dvdwalter",

Character set confusion, see below:

In firebird-support@yahoogroups.com, "dvdwalter" wrote:

> Hello,
>
> I've created a database with this statement via API:
> CREATE DATABASE '...' PAGE_SIZE 4096
> USER 'SYSDBA' PASSWORD 'masterkey'
> DEFAULT CHARACTER SET ISO8859_1;
>
> Then I created a table via API:
> CREATE TABLE TEST1 (ID INTEGER NOT NULL, NAME VARCHAR(50),
> CONSTRAINT PK_T1ID PRIMARY KEY (ID));
>
> And last but not least I tried to insert a record with an non-ASCII-
> character (also with help of the API).
> INSERT INTO TEST1 VALUES (0, _ISO8859_1 'König');
>
> If I start ISQL and make a select I get 'K÷nig. Where's the error?
>
> OS is Windows XP SP1, Firebird is 1.5 RC5, the compiler was Visual
> C++ 6.0.

You are not working in an ISO8859_1 environment, I assume.

Have you switched your command line to CP1252?

o-umlaut in ISO-8859-1 is 0xF6. But in CP437, 0xF6
is the division sign.

If you redirect the output of ISQL to a file and view
with a Windows editor, you will see the o-umlaut.

To see it in interactive mode ISQL, chcp 1252.

Regards,
Peter Jacobi