Devart Forums

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.

Hi,
I'm wondering if Unidac 1.x is even compatible with D2009 and/or Unicode.
Maybe you could try your example with the Unidac v3 trial also?
Regards,
Tobias

We could not reproduce the problem. Please send to support*devart*com a complete small sample that demonstrates the problem, including the script for creating database objects.