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 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