Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2002
    Posts
    5

    Unanswered: Accent-insensitive HELP.

    Hello,

    I need to change for an old db (SQL 2K) the property Accent-sensitive to Accent-insensitive and I don't know how .

    If someone has a solution I needs some help please.

    Thank you.

  2. #2
    Join Date
    Jan 2003
    Location
    Midwest
    Posts
    138
    Example: on a database named Products with the language French


    ALTER DATABASE Products

    COLLATE French_CI_AI


    the CI_AI tells it to be Case Insensitive and Accent Insensitive

  3. #3
    Join Date
    Dec 2002
    Posts
    5
    Originally posted by Memnoch1207
    Example: on a database named Products with the language French


    ALTER DATABASE Products

    COLLATE French_CI_AI


    the CI_AI tells it to be Case Insensitive and Accent Insensitive
    I try but doesn't work .
    The script : ALTER DATABASE Products COLLATE French_CI_AI
    return : The command(s) completed successfully.

    but my select with : WHERE id = 'abcdé' and WHERE id = 'abcde' is different .

    ?!

  4. #4
    Join Date
    Dec 2002
    Location
    Czech Republic
    Posts
    249
    Changed default database collation only.
    You must alter all tables in you database.

    A,Change collation of table columns by EM.

    B,Faster would be
    1.Generate script for all database by EM to text file without Generate drop existing option.
    2.Open this file in notepad
    3.Replace collation strings French_CI to French_CS (use your collation)
    4.Copy create database part to QA and change database name and run
    5.Switch to new database
    5.Copy create tables part to QA and run
    6.Use DTS wizard to copy data from your old database
    7.Copy all remaining code to QA and run
    8.Switch your databases by sp_renamedb (old->bak,new->old)

    Note that server can use different collation from database. TempDb uses collation of model.

Posting Permissions

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