--- In firebird-support@yahoogroups.com, "lars6696" <ldb@i...> wrote:

>
> I want to be able to save text in a table.
> This text is a mixture of 'normal' and special characters
> like 'ö'/'Ö', 'à'/'À' and 'ü'/'Ü'.
>
>
> I have at firebird database created with IBOconsole v1.1.9.6.
> SQL Dialect is 3 and default character set is set to ISO8859_1.
> The table is created like this:
>
>
> CREATE TABLE 'MEDIA'
> (
> 'MEDIAID' INTEGER NOT NULL,
> 'UNITID' INTEGER,
> 'LOCATIONID' INTEGER,
> 'NAME' VARCHAR(255) CHARACTER SET ISO8859_1 COLLATE DA_DA,
> 'FSIZE' VARCHAR(25) CHARACTER SET ISO8859_1 COLLATE DA_DA,
> PRIMARY KEY ('MEDIAID')
> );
>
>
> When inserting a fieldvalue to 'NAME' in IBOConsole either manually
> or by SQL, the table is updated as expected.
>
> - But using Delphi to insert the exact same string, i recieve

the '..

> cannot transliterate between character sets' error

I used IBConsole 1.0.0.320 to enter text and encounted a similar
error. At last I found the IBConsole is not Unicode support and as a
result, under Windows, it uses the system collate to translate the
text string (clinet side). Try set the sytem collate to your target
language and see if that makes a differece!

>
>
> I use the ibDatabase, ibTransaction, and ibQuery
> When connecting to the database i have added the
> param 'DefaultCharacterSet=ISO8859_1'.
>
>
>
>
> Any suggestions?
>
>
>
> BR
>
> Lars :D
>
> - using Delphi 7
> Firebird 1.5.0.4306
> Win2000 sp4