DELPHI7 Call Berlin Middleware The solution of the name garbled in the Chinese text field

MSSQL database table using the Text field name, Berlin developed DATASNAP Middleware, DELPHI7 call the middleware query method to return data to Clientdataset.data, found in the text field name garbled, the value of the text field name can be displayed normally.

What to do?

It is found that the text snippet name as in the SQL statement can solve the problem of garbled characters.

Select C1, field Name 2 as C1 from T1

Why?

Berlin uses Unicode strings by default, Berlin Clientdataset also uses Unicode strings, DELPHI7 is an ANSI string, DELPHI7 Clientdataset uses ANSI strings, This is the cause of garbled characters in the text segment.

In the end, it is not recommended to use Chinese as the field name.

DELPHI7 Call Berlin Middleware The solution of the name garbled in the Chinese text field