Skip to content
← SQL Complete

How can we improve SQL Complete?

SQL Complete: Bugs

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Collation names enclosed in square brackets is invalid

I have "Enclose identifiers within square bracket" set to "Always", which in most cases are great.
However, collation names are also being enclosed in square brackets, which seems to be invalid.
Please correct.

1 vote
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Lars I Nielsen shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
AdminPMs (Admin, Devart) responded  · 

Could you please specify what product version you are using?

A video or screenshots would be also of help.

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Lars I Nielsen commented  ·   ·  Report

    -- correct T-SQL
    SELECT [my_string] COLLATE Danish_Norwegian_CI_AS FROM dbo.[TEST_types] [tt]

    -- as SQL Complete writes it
    SELECT [my_string] COLLATE [Danish_Norwegian_CI_AS] FROM dbo.[TEST_types] [tt]