Re: Moving Servers, Matching Collation
From: Bart Duncan [MSFT] (bartd_at_online.microsoft.com)
Date: 04/08/04
- Next message: Frank van Tour: "Installation failure"
- Previous message: Dinesh T.K: "Re: full-text indexing"
- In reply to: David Morgan: "Re: Moving Servers, Matching Collation"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 08 Apr 2004 03:49:40 GMT
If you change your default locale to U.S., that will be sufficient to have
setup default to SQL_Latin1_General_CP1_CI_AS just as you say. However,
it's also true that this collation is always available during setup
regardless of the system locale. I'll grant that the dialog is not nearly
as straightforward as it could be and it's not so intuitive to use, though.
Here are the specific steps that will work on a UK English machine without
changing system locale:
1. Be sure to select a Custom setup on the "Setup Type" dialog. If you
don't do this you won't have an opportunity to select a non-default
collaltion.
2. When you reach the "Collation Settings" dialog, select the radio button
that is labeled "SQL Collations (Used for backwards compatibility with
previous versions of SQL Server)". By default, the other radio button
("Windows Locale") will be selected.
3. In the listbox below this select "Dictionary order, case-insensitive,
for use with 1252 character set". This coresponds to
SQL_Latin1_General_CP1_CI_AS. On a US English machine this sort order will
be highlighted by default, but on a UK (or other) English machine you'll
have to scroll down a little ways to see this one.
This is definitely just as doable on a UK English machine (or any other
locale) as it is on a US English machine. If you haven't seen the option
in the past you may want to try again following the above steps as a guide.
It's just a bit harder to find the dialog and harder to know what to
select on it than it probably should be.
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.
--------------------
| From: "David Morgan" <david@davidmorgan.me.uk>
| References: <OygpH4lGEHA.3576@tk2msftngp13.phx.gbl>
<epJVrB7GEHA.2052@TK2MSFTNGP12.phx.gbl>
<2Qd4qv$GEHA.1988@cpmsftngxa06.phx.gbl>
| Subject: Re: Moving Servers, Matching Collation
| Date: Wed, 7 Apr 2004 09:16:08 +0100
| Lines: 99
| 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: <OOXIViHHEHA.3144@TK2MSFTNGP10.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.setup
| NNTP-Posting-Host: host217-46-185-37.in-addr.btopenworld.com 217.46.185.37
| Path:
cpmsftngxa06.phx.gbl!TK2MSFTNGXA06.phx.gbl!TK2MSFTNGXA05.phx.gbl!TK2MSFTNGP0
8.phx.gbl!TK2MSFTNGP10.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.setup:63396
| X-Tomcat-NG: microsoft.public.sqlserver.setup
|
| Yes, but as per my previous link to an MS Article if you want the
collation
| I needed, you have to configure your server as US English and then the
| default collation is the one I required. This collation is NOT AVAILABLE
if
| your Windows location is UK, irrespective of what you have written.
|
|
| "Bart Duncan [MSFT]" <bartd@online.microsoft.com> wrote in message
| news:2Qd4qv$GEHA.1988@cpmsftngxa06.phx.gbl...
| > For SQL_Latin1_General_CP1_CI_AS you select "Dictionary order,
| > case-insensitive, for use with 1252 character set" under the "SQL
| > Collations" section in the collation selection dialog. To install with
a
| > nondefault collation you must do an Advanced install.
| >
| > In general, here's a method for determining what to select in setup (or
| > rebuildm.exe) if you need to install with a SQL collation:
| > - Locate your collation name in the BOL topic "SQL Collation Name".
Make
| > a note of the corresponding sort order ID.
| > - Locate your sort order ID in the BOL topic "Selecting a SQL
Collation".
| > The text here is what you select in setup.
| >
| > 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: "David Morgan" <david@davidmorgan.me.uk>
| > | References: <OygpH4lGEHA.3576@tk2msftngp13.phx.gbl>
| > | Subject: Re: Moving Servers, Matching Collation
| > | Date: Tue, 6 Apr 2004 09:23:17 +0100
| > | Lines: 37
| > | 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: <epJVrB7GEHA.2052@TK2MSFTNGP12.phx.gbl>
| > | Newsgroups:
| > microsoft.public.sqlserver.programming,microsoft.public.sqlserver.setup
| > | NNTP-Posting-Host: host217-46-185-37.in-addr.btopenworld.com
| 217.46.185.37
| > | Path:
| >
|
cpmsftngxa06.phx.gbl!TK2MSFTNGXA06.phx.gbl!TK2MSFTNGXA05.phx.gbl!TK2MSFTNGP0
| > 8.phx.gbl!TK2MSFTNGP12.phx.gbl
| > | Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.setup:63376
| > microsoft.public.sqlserver.programming:436083
| > | X-Tomcat-NG: microsoft.public.sqlserver.setup
| > |
| > | http://tinyurl.com/39pft
| > |
| > |
| > | "David Morgan" <REMOVE_david@davidmorgan.me.uk> wrote in message
| > | news:OygpH4lGEHA.3576@tk2msftngp13.phx.gbl...
| > | > Hi
| > | >
| > | > We are moving our database from a SQL 2K installation on W2K to a
SQL
| 2K
| > | on
| > | > Windows 2003 machine.
| > | >
| > | > We have a problem with some of the queries where the collation is
not
| > | > matched. We are using rebuildm.exe to try and change the collation
| but
| > | > cannot seem to find an available collation that matches our old
| server.
| > | >
| > | > The old server's collation is: SQL_Latin1_General_CP1_CI_AS.
| > | >
| > | > We have tried several of the available collations within rebuildm
and
| > | Latin1
| > | > case insensitive from the first selection options, but we just
cannot
| > find
| > | a
| > | > match and therefore, get our queries to run.
| > | >
| > | > The closest so far is Latin1_General_CI_AS.
| > | >
| > | > Can anyone help me identify which collation in the rebuildm utility,
| (or
| > | > elsewhere), can be used to get our new server to reflect the same
| > | collation
| > | > as our old server.
| > | >
| > | > Thanks in advance
| > | >
| > | > David M
| > | >
| > | >
| > |
| > |
| > |
| >
|
|
|
- Next message: Frank van Tour: "Installation failure"
- Previous message: Dinesh T.K: "Re: full-text indexing"
- In reply to: David Morgan: "Re: Moving Servers, Matching Collation"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
