MsSql unicode problem

[rimaSamir]

Hello,

This is an update string that was sent by add-in

Code: Select all

UPDATE [MYDB].[dbo].[CITY] SET [NAME] = 'Bakı şəhəri' WHERE [ID] = 1; SELECT [ID], [NAME] FROM [MYDB].[dbo].[CITY] WHERE [ID] = 1

and I get "Bak? s?h?ri" as result. There is have to be N'some unicode text' so N is needed.

How to resolve this problem please?

[Shalex]

We will investigate the question and notify you about the result.

[Pinturiccio]

We have fixed the bug with corrupting unicode characters for the SQL Server source. We will post here when the corresponding build of Excel Add-ins is available for download.

[Pinturiccio]

New version of Devart Excel Add-ins 1.7 is released.
It can be downloaded from https://www.devart.com/excel-addins/download.html or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to viewtopic.php?t=36931