Post reply

Collation on database

  • August 10, 2011 at 6:30 pm

    #100409

    How can I change collation on db?

    Thank you

  • August 10, 2011 at 8:16 pm

    #1367033

    ALTER Database COLLATE <collation_name>

    That will alter the default collation for the database. It will NOT alter the collation of any existing columns in tables. You'll have to alter the collations for those separately.

    Tom

Viewing 2 posts - 1 through 1 (of 1 total)

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