Chinese simplified - cast from Char to NChar

[former_member897217]

Hi,

my problem: We have a tool (Delphi 5 + old ADS database version that did not know NChar or NVarChar), and a new tool developed with Delphi Tokyo and ADS 12.

Chinese text has always be stored in CHAR datatype in ADS, which did not create any problems. Chinese text could be displayed properly. I can't use NChar or NVArChar because the old tool would not be able to open *.adt files with unknown datatype.

Internally it seems that ADS treats for example 是 as ÊÇ

This is the result of Select Cast(Name as SQL_WVARCHAR) from test

where 'Name' is Char(255) and stores 是

All my problems I am facing right now would be solved if I am able to program a Delphi function (Delphi Tokyo) like:

function GetCastResult(s: string): string;

where s:=是

result:=ÊÇ

I hope that anybody can help me, thank you in advance

[Former Member]

Thank you for visiting SAP Community to get answers to your questions. Since this is your first question, I recommend that you familiarize yourself with: https://community.sap.com/resources/questions-and-answers, as the overview provides tips for preparing questions that draw responses from our members.

Should you wish, you can revise your question by selecting Actions, then Edit. By adding a picture to your profile you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html