What happens when I set UseUnicode = True
Posted: Wed 17 Jan 2007 14:43
Hello
First of all I want to thank you for such great data access components. They are very nice.
But I run into a problem cause I don't know what happens inside MyDAC when I set UseUnicode=True in MyConnection.
As I imagine it should do automatic UTF8Decode - when reading from DB and UTF8Encode when writing to DB, but my tests do not prove me this.
I have a MySQL table which is UTF8. I sourced some UTF8 data in that table. Now when I show them in a TntDBGrid the data is not shown correctly.
This is a part of the string I get:
ΑÏ
First of all I want to thank you for such great data access components. They are very nice.
But I run into a problem cause I don't know what happens inside MyDAC when I set UseUnicode=True in MyConnection.
As I imagine it should do automatic UTF8Decode - when reading from DB and UTF8Encode when writing to DB, but my tests do not prove me this.
I have a MySQL table which is UTF8. I sourced some UTF8 data in that table. Now when I show them in a TntDBGrid the data is not shown correctly.
This is a part of the string I get:
ΑÏ