Thanks Peter

Luc pointed me in the right direction, I hadn't / didn't know I had to specify the char set for my connection. I've done that now and it works wonderfully.

Thanks all.

Rgds

Peter

----- Original Message -----
From: peter_jacobi.rm
To: firebird-support@yahoogroups.com
Sent: Friday, November 14, 2003 4:16 PM
Subject: [firebird-support] Re: Danish Characters


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>


Yahoo! Groups Sponsor
ADVERTISEMENT




To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


[Non-text portions of this message have been removed]