How can I work with Chinese characters from a database?

Answer 1

I need more information before answer your question.

1. What database you use?
2. What is the encoding setting for the field you store the chinese characters?

You may paste the table's DDL here for further discussion.

Answer 2

Hi Mr Chau,

1) Im using ClientDataset standalone without any data provider.

2) We are expecting that the result should be same for TEdit and TDBEdit. Isn't it D2010 a Native Unicode ?

it is just a simple standalone ClientDataset as follow:

---

type TForm1 = class(TForm)

ClientDataSet1: TClientDataSet;

ClientDataSet1Name: TStringField;

ClientDataSet1Description: TMemoField;

DataSource1: TDataSource;

ClientDataSet2: TClientDataSet;

ClientDataSet2Name: TStringField;

ClientDataSet2Description: TMemoField;

DataSource2: TDataSource;

Answer 3

In Delphi 2010, TStringField and TMemoField's value property is of type AnsiString. That is the reason why the Chinese characters doesn't show in the data aware controls.

Instead, you should declare the field type as ftWideString or ftWideMemo to create TWideStringField and TWideMemoField respectively.