Re: Collation

From: John Bell (jbellnewsposts_at_hotmail.com)
Date: 06/21/04 

Date: Mon, 21 Jun 2004 10:40:06 +0100

Hi

You may want to send this request to sqlwish@microsoft.com. Using the
default collation may result in the application behaving differently
depending on the collation. Specifying a collation when accessing objects
external to your database should help. Another option would be to make sure
that they are installed in their own instance.

Rather than having to script the database you should think about storing the
database objects in a version control system. If you do this a mechanism
that parameterised the collation could be written.

John

"jb" <jb@discussions.microsoft.com> wrote in message
news:935AD5FB-40B0-40B0-B01D-7C58EDE54EEB@microsoft.com...
> When you supply scripts to customers, where you believe their collation
default may be different from yours (e.g. UK <-> US), do you --- in order to
avoid collation conflicts --- go through (manually) and remove all the
"COLLATE" clauses that scripts from EM etc. seem to generate in their
database & column definitions? I am suprised that EM does not seem to have
an option to do this, as it seems to me forcing in collation clauses just
leads to problems?

Relevant Pages

  • Re: Change field collation
    ... constraints and statistics on the columns before you can alter ... There are quite a lot of caveats and you use this script at your own risk. ... Changing the collation of the existing tables is unfortunately not very ... You might consider using SEM to script out the objects in the database, ...
    (microsoft.public.sqlserver.programming)
  • Re: Changing collation -- URGENT
    ... You can use the following script to change the collations of your columns, ... duplicate primary key constraints create statements, ... Changing the collation of the existing tables is unfortunately not very ... You might consider using SEM to script out the objects in the database, ...
    (microsoft.public.sqlserver.server)
  • Re: Database collation error after moving to a remote sql server
    ... I think I'm going to try plan B: Install a second instance of SQL 2000 onto ... the remote server and set its default collation to the same as my SMS ... database, then move my db to the new instance. ... The char, varchar, text, nchar, nvarchar, or ntext system data types, ...
    (microsoft.public.sms.setup)
  • Re: COLLATION PROBLEM CAN ANY ONE HELP
    ... Sounds like you may have code page X data in a code page Y database. ... database with a collation that matches the data's actual code page: ... COLLATION PROBLEM CAN ANY ONE HELP ... | Content-Type: text/plain; ...
    (microsoft.public.sqlserver.datamining)
  • Re: Need to reconfigure SQL Server to be Case-Insensitive
    ... You will want to perform ALTER DATABASE and ALTER TABLE statements. ... You can change the collation of a column by using the ALTER TABLE statement: ... applied to all columns, user-defined data types, variables, and parameters ...
    (microsoft.public.sqlserver.server)
Loading