delphi 7 by devart mysql driver

dbxmda440std · Post by **dbxmda440std** » Mon 14 Sep 2009 08:17

How Can I make use devart mysql driver saving utf8 chinese character ?

I have set servercharset = utf8 , useunicode =true.

it does not work . Errors shown : expecting widestring and actual string.

addfield list is tstring;

I also use tms unicode component of tntdbctrl grid. it still come out problem.

Could you give me information how to solve the utf8 chinese character at
delphi 7 ?

Mr Yeung

Dimon · Post by **Dimon** » Mon 14 Sep 2009 12:02

I could not reproduce the problem.
Please send me a complete small sample to dmitryg*devart*com to demonstrate it, including a script to create and fill a table.

dbxmda440std · Post by **dbxmda440std** » Sat 19 Sep 2009 15:47

Hi

Have sufficient material for your study ?
If you have any need , i will provide more case for your study .

I would like to request to find out and solve my delphi 7 application using devart mysql driver using at unicode /big5 chinese character.

Up to now I don't know where is wrong ... Althought delphi vcl 7 not support widestring.

But I can succeed saving and reading record by following utf8 / big5 chinese character as below case:

InterExpress Firebird driver & firebird database with TNTdbCtrl unicode support component.

Mr Yeung
Longfit Technology

Dimon · Post by **Dimon** » Mon 21 Sep 2009 10:58

To use big5 charset you should set the Charset parameter of TCRSQLConnection, like this:

Code: Select all

TCRSQLConnection.Params.Values['Charset'] := 'big5';

Please, make sure that you use the TCRSQLConnection component and not TSQLConnection. For quick converting TSQLConnection in TCRSQLConnection you can use the "Convert to TCRSQLConnection" menu of the component pop-up menu.

The UseUnicode option is available for Delphi 2006 and higher IDE versions.

For more information please see the Readme.htm file.

dbxmda440std · Post by **dbxmda440std** » Tue 22 Sep 2009 05:11

Hi

unfortunately , it does work properly and all unicode chinese character
became as ?

I will send you utf8_sample.txt which contain utf8 chinese character.

you can try to test it save and retrieve it.

thanks
Mr Yeung

attached UTF8 CHINESE

俴亸乸鯻羴鰂
俴亸乸鯻羴鰂
俴亸乸鯻羴鰂

Dimon · Post by **Dimon** » Tue 22 Sep 2009 08:40

The problem is that the UseUnicode option is available for Delphi 2006 and higher IDE versions. Therefore DbxMda for Delphi7 doesn't support working with unicode.

dbxmda440std · Post by **dbxmda440std** » Tue 22 Sep 2009 11:52

Hi

Yes I know,

Please help me confirm delphi 7
which Can work out or support utf8 /big character ?

attached utf8_sample.txt which contain ut8 chinese character.?

Help me emulate same case for delphi by sqlclientdataset+datasetProvider+clientDataset

mysql server have set utf8 and devart mysql driver have tried to set servercharset = ut8 or
servercharset utf8.

Both can didn't work properly

Thanks
Mr Yeung

Dimon · Post by **Dimon** » Wed 23 Sep 2009 13:39

We have answered you by e-mail.

Devart Forums