Collate options

Cowski

I'm using SQL Prompt 4 & have run into an issue that requires some code to use the "Collate" function within T-SQL. It appears that SSMS recognizes the "Collate" word because it turns it blue after I type it, but SQL prompt 4 does not. And since SQL Prompt does not recognize that function there is no option to pick what kind of collation to use. I.E. SQL_Latin1_General_CP1_CI_AS or SQL_Latin1_General_CP1_CS_AS, etc.

Am I missing something in the options or is this something to be added in a future version of SQL Prompt?

Eddie D

Thank you for your post into the forum.

Can you please reply with the T-SQL commands you will be using?
Also the exact version of SQL Prompt you are using?

I suspect that there is a bug within SQL Prompt with regards to the collate keyword. My testing of the condition has brought me mixed results.

This query does bring up the collate keyword for selection from the candidate list but there are no collations listed:

create table #test (
  title varchar(500) COLLATE
)

This query does not bring up the collate keyword from the candidate list:

CREATE TABLE [test] (
Col1 INT,
Col2 VARCHAR(10)) COLLATE

Once I receive your code example I will submit a bug report for the SQL Prompt Development Team to consider.

We have also created a Support Call for you, the reference number is F0033002.

Many Thanks
Eddie