International characters, writing....

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Zoltan

International characters, writing....

Post by Zoltan » Sat 25 Jun 2005 13:14

I have a strange problem. I'm trying to add support for Slovenian language to my program, that uses SDAC (3.5).
In the database, the default Collation is set to Slovenian_CI_AI, also the column (varchar) is set to Slovenian_CI_AI. Also, on the client the default language for non-unicode application is set to Slovenian.

When I use some other application to write to this column, specific slovenian characters ("žđšćč") and use my program the characters display correctly. But if I try to update the column, some of the characters are lost (e.g. converted to "?" and "č" to "c").

Is it possible that SDAC has no international characters support?
What I'm doing wrong? Please help.

Ikar
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Mon 27 Jun 2005 07:22

SDAC completely supports working with national codings.

> In the database, the default Collation is set to Slovenian_CI_AI, also the
> column (varchar) is set to Slovenian_CI_AI. Also, on the client the default
> language for non-unicode application is set to Slovenian.

You have done everything right. Try to connect to the same server from another client to determine the problem.

Post Reply