Post reply

Collate Syntax Error

  • November 18, 2003 at 12:28 pm

    #65259

    I am trying to create a table using:

    CREATE TABLE [dbo].

    (

    [cust_no] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL)

    But it gave me an error:

    Incorrect syntax near 'COLLATE'.

    What did I miss? Thank You!

  • November 18, 2003 at 12:47 pm

    #482494

    Check the compatibility level with sp_helpdb. If it's less than 80, you can't use collations on columns.

    --Jonathan



    --Jonathan

  • November 18, 2003 at 1:59 pm

    #482504

    Thank you, Jonathan. You are right. The compatibility level is 65. What determines the compatibility level? What can be done to make it 80? Thanks again.

  • November 18, 2003 at 2:12 pm

    #482507

    quote:

    Thank you, Jonathan. You are right. The compatibility level is 65. What determines the compatibility level? What can be done to make it 80? Thanks again.

    The compatibility level was set for some (good?) reason, so you should check with others at your site before changing it using:

    

    sp_dbcmptlevel <dbname>,80

    --Jonathan



    --Jonathan

  • November 18, 2003 at 2:31 pm

    #482509

    Thank you!!!

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply