MsSql unicode problem

Discussion of issues, suggestions and bugs of Devart Excel Add-ins, our product line for connecting Excel to external data from cloud applications and databases
Post Reply
rimaSamir
Posts: 1
Joined: Thu 07 Sep 2017 09:49

MsSql unicode problem

Post by rimaSamir » Thu 07 Sep 2017 09:57

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
Site Admin
Posts: 8368
Joined: Thu 14 Aug 2008 12:44

Re: MsSql unicode problem

Post by Shalex » Fri 08 Sep 2017 10:15

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

Pinturiccio
Devart Team
Posts: 2279
Joined: Wed 02 Nov 2011 09:44

Re: MsSql unicode problem

Post by Pinturiccio » Fri 16 Mar 2018 16:03

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
Devart Team
Posts: 2279
Joined: Wed 02 Nov 2011 09:44

Re: MsSql unicode problem

Post by Pinturiccio » Tue 20 Mar 2018 17:45

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

Post Reply