How can we help you today? How can we help you today?

! Error refactoring unicode strings

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
torsten.strauss
0

Comments

7 comments

Sort by
  • MaximeBOTOKAPOAKA
    Hello,

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

    Maxime

    MaximeBOTOKAPOAKA
    0
  • 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.

    Anu D
    0
  • 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];<br>GO<br><br>DECLARE @p1 BIGINT;<br>SET @p1 = 123456789012345;<br>GO<br><br>--DROP TYPE [dbo].Junk;<br>CREATE TYPE [dbo].[Junk] AS TABLE<br>&nbsp;&nbsp;&nbsp; ([JunkID] UNIQUEIDENTIFIER NOT NULL,<br>&nbsp;&nbsp;&nbsp;&nbsp; [Name] VARCHAR(25) NOT NULL,<br>&nbsp;&nbsp;&nbsp;&nbsp; [Value] VARCHAR(100) NULL,<br>&nbsp;&nbsp;&nbsp;&nbsp; [GUID] UNIQUEIDENTIFIER NOT NULL,<br>&nbsp;&nbsp;&nbsp;&nbsp; [TimeStampUTC] DATETIME NOT NULL);<br>GO<br><br>DECLARE @p0 dbo.Junk<br>GO
    Thanks,
    Tony Green


    TonyGreen
    0
  • 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

    torsten.strauss
    0
  • 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.





    Tianjiao_Li
    0
  • MaximeBOTOKAPOAKA
    Hello,

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

    Thks, have a nice day.
    MaximeBOTOKAPOAKA
    0
  • 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.
    Tianjiao_Li
    0

Add comment

Please sign in to leave a comment.