Devart Forums

Hello,

I developed an application in Delphi 7 using UNIDAC. The database server is MSSQL. It works fine on Windows XP but on Windows 7 the character encoding is wrong. I need the hungarian characters. The collation on the server and the regional settings on the client are fine. I think the problem is that the component can't access to the regional settings on the client(maybe the win7 api does not support something anymore). Is there any way to set up manually the character encoding for the component on login? Thank you.

Hello,

Please try setting the TMSConnection.Options.AutoTranslate property to False. TMSConnection.Options.AutoTranslate is used to translate character strings sent between the client and server by converting through Unicode. For more information, please read the description of the SSPROP_INIT_AUTOTRANSLATE SQL Server initialization property (TMSConnection.Options.AutoTranslate sets this SQL Server property). If the problem persists, it means that you have different code pages on the client and on the server. That's why some extended characters can be misinterpreted. To avoid such problem, you can also use the nchar, nvarchar, and ntext data types instead of the char, varchar, and text data types.