Page 1 of 1

MsSql unicode problem

Posted: Thu 07 Sep 2017 09:57
by 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?

Re: MsSql unicode problem

Posted: Fri 08 Sep 2017 10:15
by Shalex
We will investigate the question and notify you about the result.

Re: MsSql unicode problem

Posted: Fri 16 Mar 2018 16:03
by 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.

Re: MsSql unicode problem

Posted: Tue 20 Mar 2018 17:45
by 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