Subject | Umlauts (Non-ASCII-Signs) |
---|---|
Author | dvdwalter |
Post date | 2003-12-09T19:36:42Z |
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.
Thanx.
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.
Thanx.