Devart Forums

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

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.

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

To use big5 charset you should set the Charset parameter of TCRSQLConnection, like this: 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.

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

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

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.

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

We have answered you by e-mail.