What are the challenges you face when working across database platforms? Take the survey

Collate options

CowskiCowski Posts: 23 New member
edited March 29, 2010 12:28PM in SQL Prompt Previous Versions
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?


  • Options
    Eddie DEddie D Posts: 1,789 Rose Gold 5
    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,

    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 Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.