! Error refactoring unicode strings

torsten.strauss

Hi!

After upgrading to the latest version I got the mentioned error for every! SQL code line I would like to format.
I consider this as a critical bug cause I cannot use SQL Prompt anymore.

Would be nice if you find a solution for this issue.

Thanks!

Torsten

MaximeBOTOKAPOAKA

Hello,

Same issue after updating SQL Prompt this morning.
Current SQL prompt version is : 9.1.4.4532.

Maxime

Anu D

Hi guys,

Thanks for the post!

As mentioned over my email to both of you, we are investigating the issue and would like to get further details from you.

TonyGreen

I am having the same problem as above.
SSMS: 17.6
SQL Prompt: 9.1.4.4532
SQL Server 2014 - SP2

Sample Code which errors when attempting to format:

USE [master];

Thanks,
Tony Green

torsten.strauss

Same here!
The formatting fails for ALL scripts but if I copy the statement to a new fresh query window it will work for me.
I played around with different code page settings when saving the.sql file but this did not help neither.
I am just wondering why it tells that this error is related to unicodestrings ....

Torsten

Tianjiao_Li

Hi @torsten.strauss  @TonyGreen @MaximeBOTOKAPOAKA

Sorry for the issue you are having.

We have it logged as SP-6888 in our internal bug tracking system.

Can you please uncheck "Prefix N to unicode literal string variable assignments"? It should resolve the issue.

MaximeBOTOKAPOAKA

Hello,

issue solved by uncheck of "Prefix N to unicode literal string variable assignments".

Thks, have a nice day.

Tianjiao_Li

Hi @torsten.strauss  @TonyGreen @MaximeBOTOKAPOAKA

Thanks for your patience with this issue.

I'm pleased to let you know the bug is fixed. Please upgrade to the latest version.

Thanks.