Re: Installing SQL_Latin1_General_CP1_CI_AS collation order??

From: Ward Horsfall (ward.horsfall_at_nospam.managesoft.com)
Date: 02/11/04 

Date: Wed, 11 Feb 2004 20:41:15 +1100

Bart,

Excellent !! Thanks can you tell me is the a way with SQL I can query or
spme stored procedure to work out what the collation order is on a database?

Thanks,

Ward
"Bart Duncan [MSFT]" <bartd@online.microsoft.com> wrote in message
news:ef%23dprD8DHA.2508@cpmsftngxa07.phx.gbl...
> SQL_Latin1_General_CP1_CI_AS is available in the setup GUI interface. To
> install with this you would select "Dictionary order, case-insensitive,
> for use with 1252 character set" in the list box at the bottom of the
> screen.
>
> FYI, there's a way to map between the text used in the setup (and
> rebuildm.exe) interfaces and a collation designator, although it's not
> incredibly intuitive. If you know the collation name and want to find
> what to select in setup:
> - If your collation name doesn't start with "SQL_" it's a Windows
> collation. Just select the appropriate Windows collation at the top of
> the dialog.
> - Otherwise you have a SQL collation. Find your collation name in the
> "SQL Collation Name" topic in Books Online.
> - If the collation name was listed in the "SQL Collation Name" topic,
> make a note of the Sort Order ID (left column). Look this up in the
> "Selecting a SQL Collation" BOL topic.
> - Find and select the text from "Selecting a SQL Collation" in the list
> box at the bottom of the dialog.
>
> Bart
> ------------
> Bart Duncan
> Microsoft SQL Server Support
>
> Please reply to the newsgroup only - thanks.
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
>
> --------------------
> From: "Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com>
> References: <gZrUb.43604$Wa.13810@news-server.bigpond.net.au>
> <#f3oER$6DHA.1948@TK2MSFTNGP12.phx.gbl>
> <lhvUb.43683$Wa.41220@news-server.bigpond.net.au>
> <udCmubC7DHA.2064@TK2MSFTNGP11.phx.gbl>
> <1076117236.267091@excalibur.osa.com.au>
> Subject: Re: Installing SQL_Latin1_General_CP1_CI_AS collation order??
> Date: Sat, 7 Feb 2004 09:13:12 +0100
> Lines: 107
> X-Priority: 3
> X-MSMail-Priority: Normal
> X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
> Message-ID: <uHXS3IV7DHA.4060@tk2msftngp13.phx.gbl>
> Newsgroups: microsoft.public.sqlserver.setup
> NNTP-Posting-Host: h204n1fls306o871.telia.com 213.64.234.204
> Path:
> cpmsftngxa07.phx.gbl!cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp1
> 3.phx.gbl
> Xref: cpmsftngxa07.phx.gbl microsoft.public.sqlserver.setup:61803
> X-Tomcat-NG: microsoft.public.sqlserver.setup
>
> Hmm, not sure what you are asking. SQL Server comes with a bunch of
> collations, where a collation controls things as the character repertoire,
> case sensitivity, sort order etc. There is plenty of information about
> collations in Books Online.
>
> --
> Tibor Karaszi, SQL Server MVP
> Archive at:
> http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserve
> r
>
>
> "Ward Horsfall" <ward.horsfall@nospam.managesoft.com> wrote in message
> news:1076117236.267091@excalibur.osa.com.au...
> > Thanks for your answer.
> >
> > So what is purpose of the collation order: SQL_Latin1_General_CP1_CI_AS
> >
> > Thanks,
> >
> > WArd
> >
> > "Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> wrote
> in
> > message news:udCmubC7DHA.2064@TK2MSFTNGP11.phx.gbl...
> > > > Correct! Do you know what parameter I should set here.
> > >
> > > Check out the samples and dig into the file format. It isn't hard to
> find.
> > I
> > > believe it is towards the middle-end of the file. Or generate a file
> by
> > > running setup, advanced options, generate iss and dig into the
> generated
> > > file.
> > >
> > >
> > > > Do you know why it is
> > > > on the upgrade for MSDE 2000 and not in the customer install?
> > >
> > > MS decided to skip all SQL Swedish collations with a reasonable
> character
> > > set. I still do not know why... I
> > > --
> > > Tibor Karaszi, SQL Server MVP
> > > Archive at:
> > >
> >
> http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserve
> r
> > >
> > >
> > > "Ward Horsfall" <ward@nospam.threetoed.com> wrote in message
> > > news:lhvUb.43683$Wa.41220@news-server.bigpond.net.au...
> > > > Tibor,
> > > >
> > > > Correct! Do you know what parameter I should set here. Do you know
> why
> > it
> > > is
> > > > on the upgrade for MSDE 2000 and not in the customer install?
> > > >
> > > > Thanks,
> > > >
> > > > Ward.
> > > >
> > > >
> > > > "Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com>
> wrote
> > > in
> > > > message news:#f3oER$6DHA.1948@TK2MSFTNGP12.phx.gbl...
> > > > > Ward,
> > > > >
> > > > > Are you saying that this collation isn't available to select in
> the
> > > SETUP
> > > > program? If so, do an
> > > > > unattended installation and specify the collation in the ISS file.
> > > > >
> > > > > --
> > > > > Tibor Karaszi, SQL Server MVP
> > > > > Archive at:
> > > >
> > >
> >
> http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserve
> r
> > > > >
> > > > >
> > > > > "Ward Horsfall" <ward@nospam.threetoed.com> wrote in message
> > > > > news:gZrUb.43604$Wa.13810@news-server.bigpond.net.au...
> > > > > > Hi,
> > > > > >
> > > > > > I am wondering how do you do a custom install of SQL 2000 and
> set
> > > > > > "SQL_Latin1_General_CP1_CI_AS " to
> > > > > > be your collation order on master and tempdb. It
> > > > > > seems the only way I can see to achieve such a thing
> > > > > > is to do an upgrade from MSDE 2000.
> > > > > >
> > > > > > Thanks,
> > > > > >
> > > > > > Ward
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
>
>

Relevant Pages

  • Re: (RDA = OK) + (SqlClient = PlatformNotSupportedException) + I w
    ... But if i only change server parameter to connect to another instance of SQL ... I checked that the Collation of 192.x.x.x is ... is not due to cross wiring b/w SqlServerCe and SqlClient. ... perhaps devices support only English/Default Collation for SQL Server. ...
    (microsoft.public.sqlserver.ce)
  • Re: change collation
    ... dass beim SQL Server 2000 die Sortier/Vergleichsreihenfolge ... Verbindung zu den Benutzerdatenbanken ebenso wie Benutzerkonten ... How to transfer a database from one collation to another collation in SQL Server ...
    (microsoft.public.de.sqlserver)
  • RE: Install SQL Server 2000 with different COLLATION
    ... When you upgrade an existing SQL 7.0 instance, ... always inherits the 7.0 instance's collation. ... If you want to install SQL ... Microsoft SQL Server Support ...
    (microsoft.public.sqlserver.server)
  • Install SQL Server 2000 with different COLLATION
    ... Please refer to the following article to upgrade SQL Server 7.0 to SQL ... collation settings; ...
    (microsoft.public.sqlserver.server)
  • Re: To unicode or not?
    ... Then again, since SQL Server stores Unicode data in the UCS-2 encoding, ... use them with varchar, you simply work with a subset of the characers, ... an SQL collation is just a Windows collation ...
    (comp.databases.ms-sqlserver)