Re: Installing SQL_Latin1_General_CP1_CI_AS collation order??
From: Bart Duncan [MSFT] (bartd_at_online.microsoft.com)
Date: 02/11/04
- Next message: mickey: "Re: slow display"
- Previous message: Wayne Snyder: "Re: Caching of linked server data"
- In reply to: Ward Horsfall: "Re: Installing SQL_Latin1_General_CP1_CI_AS collation order??"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 11 Feb 2004 17:07:17 GMT
To find the collation of a SQL 7.0 instance:
EXEC sp_helpsort
To find the default instance-level collation on SQL 2000:
SELECT SERVERPROPERTY ('Collation')
To find default database-level collation on SQL 2000:
SELECT DATABASEPROPERTYEX ('pubs', 'Collation')
To find column-level collation on SQL 2000
SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
(or)
EXEC sp_help '<tablename>'
HTH,
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.
--------------------
Reply-To: "Ward Horsfall" <ward.horsfall@nospam.managesoft.com>
From: "Ward Horsfall" <ward.horsfall@nospam.managesoft.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>
<uHXS3IV7DHA.4060@tk2msftngp13.phx.gbl>
<ef#dprD8DHA.2508@cpmsftngxa07.phx.gbl>
Subject: Re: Installing SQL_Latin1_General_CP1_CI_AS collation order??
Date: Wed, 11 Feb 2004 20:41:15 +1100
Lines: 182
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
Organization: ManageSoft Corporation
Message-ID: <1076492300.368877@excalibur.osa.com.au>
Cache-Post-Path: excalibur.osa.com.au!unknown@sharkface.osa.com.au
X-Cache: nntpcache 2.3.3 (see http://www.nntpcache.org/)
Newsgroups: microsoft.public.sqlserver.setup
NNTP-Posting-Host: fw01.mgsft.com 203.6.130.130
Path:
cpmsftngxa07.phx.gbl!cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP1
1.phx.gbl
Xref: cpmsftngxa07.phx.gbl microsoft.public.sqlserver.setup:61902
X-Tomcat-NG: microsoft.public.sqlserver.setup
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
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
>
>
- Next message: mickey: "Re: slow display"
- Previous message: Wayne Snyder: "Re: Caching of linked server data"
- In reply to: Ward Horsfall: "Re: Installing SQL_Latin1_General_CP1_CI_AS collation order??"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
