Additional
dbCAP
AnyDAC
ThinDAC
NCOCI8
Topic: AnyDac-Delphi7-Unicode
AnyDac-Delphi7-Unicode
Posted: 2008/04/25 22:12
 
I am new in this, so please don't be hard on me.

I use Delphi 7, AnyDac 1.12.2, Tnt Unicode Controls 2.3 and MySQL 4.1.12a.
MySQL 4.1.12a support unicode.

Login params are:

Host=???.???.???.???
DataBase=???
User_Name=?????
Password=?????
CharacterSet=utf8
Utf8Mapping=WideString
DriverID=MySQL

In MySQL database manager I am able to enter and see unicode characters,
but in a TnTDBgrid of my application I do not see unicode characters.
(font is Tahoma)

I have to say that I was trying MyDAC 5.10 and with those components I was
able to solve my problem. In MyDac it was easy, I just have to set params:

charset=utf8 and
useunicode=true

Everything from above (Delphi 7, Tnt Unicode Controls 2.3 and MySQL 4.1.12a) was working just fine.

But fact is that I want to use AnyDac.
I am desperate now. Can anybody help me ?

Best regards to all.
Re:AnyDac-Delphi7-Unicode
Posted: 2008/04/28 10:18
 
This issue was fixed in 2.0. So, you can consider to download 2.0 Trial version from www.anydac.com.
Re:AnyDac-Delphi7-Unicode
Posted: 2008/04/28 13:02
 
I was hoping you shall say something easier.
What is, or better, what are differences between
trial and full version of AnyDAC 2.x?
I was checking that web site and I was not able to find that answer.


Re:AnyDac-Delphi7-Unicode
Posted: 2008/04/28 13:18
 
I was hoping you shall say something easier.
Actually, MySQL UTF8 support is broken in 1.12.2.
what are differences between trial and full version of AnyDAC 2.x?
1) Full version includes all library sources. Trial - only binaries.
2) Full version does not have any nag screens. Application compiled with Trial version, will show nag screen if Delphi IDE is not running.
3) Full version may be integrated with TSynEdit, to use syntax hilighting editor in Delphi IDE to edit SQL text. Trial version - cannot.
Re:AnyDac-Delphi7-Unicode
Posted: 2008/04/28 14:18
 
Thanks. But I have to ask a question more

I have

AnyDAC 1.6.1
AnyDAC 1.8.0
AnyDAC 1.9.1
AnyDAC 1.9.2
AnyDAC 1.10.0
AnyDAC 1.10.1
AnyDAC 1.11.0
AnyDAC 1.12.2

You said MySQL UTF8 support is broken in 1.12.2.
I think that version 1.9.x does not support UTF8 either, I cant remember that now.
You shall save me a lot of time if you answer this:
Which of these versions support UTF8?
Does any ... ?

Thanks and best regards.
You are wery sincere, I apprecheate that.
Re:AnyDac-Delphi7-Unicode
Posted: 2008/04/28 14:26
 
The UTF8 support was implemented in 1.9.0.
But it works OK only in 2.0.
Re:AnyDac-Delphi7-Unicode
Posted: 2008/04/28 14:37
 
That is a sad thing for me. I shall consider buying 2.0.
I am from country where price of EUR 259 is a about two
month pay. But that is my problem.
Thanks again. I have to do some thinking.