Devart Forums

I do not know if there is a way to fix my problem.
A client of us have some alternative descriptions for some items which is in Chinese.
It was working with BDE, It was possible for him to see the main English description and the Chinese one as an alternative description, on the same «Delphi 5» form.

Do you have any idea what happend there ?

Hello,

Please specify what you mean by "alternative descriptions", and the way you are working with them in Delphi.

Let say my item has a main description field FldMainDesc and an alternative one FldAltDesc

I have a dbcontrol, dbeditbox. With BDE the alternative description which is in chinese appear in chinese but with SDAC same DbEditBox, it doesn't... it show up like ????????????????????

Please specify the following:
- the exact version of SDAC. You can learn it from the About sheet of TMSConnection Editor;
- the exact version of SQL Server server and client. You can learn it from the Info sheet of TMSConnection Editor;
- your client and server Windows codepages;
- the table structure that contains the FldMainDesc and FldAltDesc fields.

SDAC Version 4.80.0.56
SQL Server express 2005 english
Field or table structure: we use default char
Code source: add a connection a datasource, a tquery, and a DBEditBox and you have your testing code

Hi AndreyZ,

I'm taking over dpoulin work and I'm going to follow up with you.

Thank you

dpoulin wrote:SDAC Version 4.80.0.56
SQL Server express 2005 english
Field or table structure: we use default char
Code source: add a connection a datasource, a tquery, and a DBEditBox and you have your testing code

Odimar is taking over...

otomazeli wrote:Hi AndreyZ,

I'm taking over dpoulin work and I'm going to follow up with you.

Thank you

dpoulin wrote:SDAC Version 4.80.0.56
SQL Server express 2005 english
Field or table structure: we use default char
Code source: add a connection a datasource, a tquery, and a DBEditBox and you have your testing code

To see Chinese characters in the standard components such as TDBEdit in Delphi 5, you should set the Windows codepage that contains such characters (for example, Chinese (Singapore) ). Also you should set a font that can display Chinese characters (for example, Tahoma) in these components.

Hi,

Well let me explain what was our configuration at the customer

Our Application (Displaying Chinese) BDE SQL Server (2005 and 2008) was working fine our customer already has Chinese windows code page installed. so our components were displaying Chinese.

After replace BDE for your component SDAC

Our Application (Not displaying Chinese) SDAC SQL Server(2005 and 2008).

Here is not a matter of component font or code page our application still the same the only peace different is your component.

so do you have any other suggestion to fix the issue!?

Please backup the database that contains the table with FldMainDesc and FldAltDesc fields, and send it to andreyz*devart*com for investigation.

Hi I've sent you the database last Friday!

Thank you!

We received your database backup, and the investigation of the problem is in progress. As soon as we have any results, we will let you know.

We have investigated this problem. The point is that BDE uses its own methods of encoding and decoding data. SDAC returns data exactly as it's stored in a database. You can check that ADO components and Microsoft SQL Server Management Studio return data in the same way as SDAC does. To get Chinese characters in this case, you can try decoding data using the OnGetText and OnSetText event handlers.