Re: Installing SQL_Latin1_General_CP1_CI_AS collation order??

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 02/07/04 

Date: Sat, 7 Feb 2004 09:13:12 +0100

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.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.sqlserver
> >
> >
> > "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.sqlserver
> > > >
> > > >
> > > > "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: Replication Monitor didnt work because different collations
    ... Looking for a SQL Server replication book? ... SQL 2005 filtered merge replication. ... We changed collations to match the server collation and Replication ... After this change we started all publication snapshots. ...
    (microsoft.public.sqlserver.replication)
  • Re: sort order ID
    ... SQL Server allows to create different collations for each database inside ... Get the equalent collations in SQL 2000 from books online. ... > 52 collations differece from server. ...
    (microsoft.public.sqlserver.server)
  • RE: Collation....
    ... ANSI SQL-92 suggests that two strings which differ only in trailing spaces ... In SQL Server, with most collations a simple ...
    (microsoft.public.sqlserver.programming)
  • Re: Error in Inintial Replication
    ... Make sure the publisher and subscriber have the same collations - this ... Looking for a SQL Server replication book? ... Jeff Dillon wrote: ... Bulk data stream was incorrectly specified as sorted. ...
    (microsoft.public.sqlserver.server)