Re: Installing SQL_Latin1_General_CP1_CI_AS collation order??
From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 02/11/04
- Next message: skc: "Install advice"
- Previous message: Jørn Jørgensen: "SQL Server and DFS"
- In reply to: Ward Horsfall: "Re: Installing SQL_Latin1_General_CP1_CI_AS collation order??"
- Next in thread: Bart Duncan [MSFT]: "Re: Installing SQL_Latin1_General_CP1_CI_AS collation order??"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 11 Feb 2004 11:27:36 +0100
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.horsfall@nospam.managesoft.com> wrote in message news:1076492300.368877@excalibur.osa.com.au... > 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: skc: "Install advice"
- Previous message: Jørn Jørgensen: "SQL Server and DFS"
- In reply to: Ward Horsfall: "Re: Installing SQL_Latin1_General_CP1_CI_AS collation order??"
- Next in thread: Bart Duncan [MSFT]: "Re: Installing SQL_Latin1_General_CP1_CI_AS collation order??"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
