Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Installing SQL_Latin1_General_CP1_CI_AS collation order??

706 views
Skip to first unread message

Ward Horsfall

unread,
Feb 5, 2004, 8:57:32 AM2/5/04
to
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


Tibor Karaszi

unread,
Feb 5, 2004, 9:27:50 AM2/5/04
to
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.sqlserver


"Ward Horsfall" <wa...@nospam.threetoed.com> wrote in message
news:gZrUb.43604$Wa.1...@news-server.bigpond.net.au...

Ward Horsfall

unread,
Feb 5, 2004, 12:43:45 PM2/5/04
to
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.n...@hotmail.nomail.com> wrote in
message news:#f3oER$6DHA...@TK2MSFTNGP12.phx.gbl...

Tibor Karaszi

unread,
Feb 5, 2004, 3:30:50 PM2/5/04
to
> 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.sqlserver


"Ward Horsfall" <wa...@nospam.threetoed.com> wrote in message

news:lhvUb.43683$Wa.4...@news-server.bigpond.net.au...

Ward Horsfall

unread,
Feb 6, 2004, 8:30:05 PM2/6/04
to
Thanks for your answer.

So what is purpose of the collation order: SQL_Latin1_General_CP1_CI_AS

Thanks,

WArd

"Tibor Karaszi" <tibor_please.n...@hotmail.nomail.com> wrote in

message news:udCmubC7...@TK2MSFTNGP11.phx.gbl...

Tibor Karaszi

unread,
Feb 7, 2004, 3:13:12 AM2/7/04
to
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.sqlserver


"Ward Horsfall" <ward.h...@nospam.managesoft.com> wrote in message
news:10761172...@excalibur.osa.com.au...

Bart Duncan [MSFT]

unread,
Feb 10, 2004, 8:03:47 PM2/10/04
to
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.n...@hotmail.nomail.com>
References: <gZrUb.43604$Wa.1...@news-server.bigpond.net.au>
<#f3oER$6DHA...@TK2MSFTNGP12.phx.gbl>
<lhvUb.43683$Wa.4...@news-server.bigpond.net.au>
<udCmubC7...@TK2MSFTNGP11.phx.gbl>
<10761172...@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: <uHXS3IV7...@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

Ward Horsfall

unread,
Feb 11, 2004, 4:41:15 AM2/11/04
to
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]" <ba...@online.microsoft.com> wrote in message
news:ef%23dprD8...@cpmsftngxa07.phx.gbl...

Tibor Karaszi

unread,
Feb 11, 2004, 5:27:36 AM2/11/04
to
sp_helpdb

(The status column in SQL2K)

--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver


"Ward Horsfall" <ward.h...@nospam.managesoft.com> wrote in message

news:10764923...@excalibur.osa.com.au...

Bart Duncan [MSFT]

unread,
Feb 11, 2004, 12:07:17 PM2/11/04
to
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.h...@nospam.managesoft.com>
From: "Ward Horsfall" <ward.h...@nospam.managesoft.com>


References: <gZrUb.43604$Wa.1...@news-server.bigpond.net.au>
<#f3oER$6DHA...@TK2MSFTNGP12.phx.gbl>
<lhvUb.43683$Wa.4...@news-server.bigpond.net.au>
<udCmubC7...@TK2MSFTNGP11.phx.gbl>
<10761172...@excalibur.osa.com.au>

<uHXS3IV7...@tk2msftngp13.phx.gbl>
<ef#dprD8D...@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: <10764923...@excalibur.osa.com.au>
Cache-Post-Path: excalibur.osa.com.au!unk...@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

0 new messages