Results 1 to 3 of 3

Thread: collation name

  1. #1
    Join Date
    Jun 2003
    Posts
    1

    Unanswered: collation name

    hello all,
    is it possible to change the propertie "collation name" of a database?
    if it is not the case can we change the properties of our SqlDataAdapter (object of VisualStudio.net) or other objects?
    thanks for responses
    bye
    clem and cyrille

  2. #2
    Join Date
    Feb 2003
    Location
    Montreal, Canada
    Posts
    117

    Re: collation name

    To change the default collation at that stage, you must first export all user data, recreate all database objects, and reload all user data.


    Originally posted by clem
    hello all,
    is it possible to change the propertie "collation name" of a database?
    if it is not the case can we change the properties of our SqlDataAdapter (object of VisualStudio.net) or other objects?
    thanks for responses
    bye
    clem and cyrille
    Steve

  3. #3
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    From SQL 2000 you can define the collation settings on database/table/column levels, refer to BOOKS ONLINE for more information COLLATION topic.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •