Page 1 of 1
Unicode problem with Enterprise Library
Posted: Wed 05 Sep 2007 21:12
by richard
I am using Enterprise Library (January 2006) and the Corelab driver 2.55.25.0. I have found that unicode characters in the database (such as ©) are correct in pgAdmin, but appear as © when retrieved from the database using EL.
Shouldn't the EL driver perform the conversion? The database is set to UTF8 encoding.
Posted: Thu 06 Sep 2007 12:19
by Alexey
Please send me a test project to reproduce the problem.
It is desirable to use 'test' schema objects, otherwise include definition of your own database objects.
Use e-mail address provided in the Readme file.
Do not use third party components.
Posted: Thu 06 Sep 2007 15:10
by richard
I will try to find some time to put that together, but since this is a pretty simple test case, I would think your team could easily set this up.
Furthermore, there is a history of Unicode related issues in the forums, all of which have been fixed, but none yet reported in Enterprise Library.
Posted: Thu 06 Sep 2007 16:23
by Alexey
I will be looking forward to your test project and database objects definition.
Posted: Mon 10 Sep 2007 14:52
by richard
I have sent a test project that reproduces the problem to
[email protected].
Posted: Wed 12 Sep 2007 11:25
by Alexey
I haven't received your letter.
Please resend it to me directly (alexeyi at crlab dot com).
Posted: Wed 19 Sep 2007 12:35
by Alexey
What database encoding do you have?
Please set Unicode attribute of the connection string to True.
Posted: Thu 20 Sep 2007 18:31
by richard
I confirm that the Unicode attribute fixes the problem. Hopefully nobody else will get caught by this in the future, as it's not obvious.
Posted: Fri 21 Sep 2007 07:48
by Alexey
I think it is obvious.
From our documentation:
Gets or sets a value indicating whether the UTF8 charset will be used.
true, if client charset UTF8 is used; false, if default client charset is used. The default value is false.