Hallo,
i hope there is a solution for the following problem:
Error message
-----------------
"Cannot transliterate character between character sets."
Surrounding:
---------------
- Delphi 2009
- UniDac Professional Edition Version 1.20.0.13
- Firebird 2.5 Database (Character Set UTF8)
- Structure of error causing table:
CREATE TABLE Analysen (
Analyse_Id CHAR(38) NOT NULL,
Analyse_Parent CHAR(38),
Analyse_Name VARCHAR(100),
Analyse_Info VARCHAR(255),
SQL BLOB SUB_TYPE TEXT,
PRIMARY KEY(Analyse_Id)
);
- TUniConnection - Parameters
object IBConnection: TUniConnection
ProviderName = 'InterBase'
Database = '..\xxxxx.fdb'
SpecificOptions.Strings = (
'InterBase.SQLDialect=1'
'InterBase.Charset=UTF8'
'InterBase.UseUnicode=True')
end
- TUniTable - Parameters
* object IBAccess: TUniTable
TableName = 'Analysen'
Connection = IBConnection
Options.DefaultValues = True
end
* no persistent fields
Error causing behaviour
----------------------------
- the error raised when i open the TUniTable "IBAccess" at designtime or at runtime
Tests
------
- When i declare the primary key field "Analyse_Id" as Integer the error does not occur.
But i cannot exchange the fieldtype because this field has to hold GUID-Information
Thanks for any answer.