Hi Peter,

In firebird-support@yahoogroups.com, <peter@c...> wrote:

> I am still having real problems creating a table that will take

Danish characters

> I have tried
> ISO8859_1
> and unicode_fss
> Both of these helped in that they accepted more characters but still

they both still complained about the text below.
[...]

> Vindebækvej 48

You are right in choosing ISO 8859-1

So must start asking about the nitty-gritty details:
Operating System? Firebird version?
Which tools are you using?

I can debug it best, when you test using ISQL, and send me
a complete session transscript (Off list, ZIP attached if
is large or the correct transmission of non ASCII characters
is in doubt).

Find below, a session transcript, I've just done
for testing your input. If you have missed the 'chcp'
and 'set names' stepped, we've already found the problem.

Regards,
Peter Jacobi
Hamburg, Germany


F:\fb15rc4\firebird15>chcp 1252
Active code page: 1252

F:\fb15rc4\firebird15\Bin>isql
Use CONNECT or CREATE DATABASE to specify a database
SQL> set names iso8859_1;
SQL> create database 'f:\dansk.fdb' user 'sysdba'
password 'masterkey' default character set iso8859_1;
SQL> create table1 (c1 char(8), c2 char(8) collate da_da);
SQL> create table t1 (c1 char(8), c2 char(8) collate da_da);
SQL> insert into t1 values ('a', 'a');
SQL> insert into t1 values ('ä', 'ä');
SQL> insert into t1 values ('æ', 'æ');
SQL> insert into t1 values ('b', 'b');
SQL> insert into t1 values ('A', 'A');
SQL> insert into t1 values ('B', 'B');

SQL> select * from t1 order by c1;

C1 C2
======== ========

A A
B B
a a
b b
ä ä
æ æ

SQL> select * from t1 order by c2;

C1 C2
======== ========

A A
a a
B B
b b
æ æ
ä ä

SQL>