delphi 7 by devart mysql driver
-
- Posts: 4
- Joined: Mon 14 Sep 2009 06:52
delphi 7 by devart mysql driver
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 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
-
- Posts: 4
- Joined: Mon 14 Sep 2009 06:52
devart mysql driver for delphi 7 ( unicode )
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
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.
Code: Select all
TCRSQLConnection.Params.Values['Charset'] := 'big5';
The UseUnicode option is available for Delphi 2006 and higher IDE versions.
For more information please see the Readme.htm file.
-
- Posts: 4
- Joined: Mon 14 Sep 2009 06:52
UTF8 UNICODE CHINESE CHARACTER
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
俴亸乸鯻羴鰂
俴亸乸鯻羴鰂
俴亸乸鯻羴鰂
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
俴亸乸鯻羴鰂
俴亸乸鯻羴鰂
俴亸乸鯻羴鰂
-
- Posts: 4
- Joined: Mon 14 Sep 2009 06:52
delphi 7 by devart mysql driver
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
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