|  |
| Author |
difference between SQL_Latin1_General_CP1_CI_AS and Latin1_General_CI_AS
|
Shibani
Guest
Registered: Not Yet
Location:
Country:
State:
Certifications:
Working on:
Total Posts: N/A
|
|
 difference between SQL_Latin1_General_CP1_CI_AS and Latin1_General_CI_AS
Hi,
On SQL Server 2000, when creating a database I saw that I
can choose either of these collations
- SQL_Latin1_General_CP1_CI_AS
- Latin1_General_CI_AS
The default for English Locale setting is
SQL_Latin1_General_CP1_CI_AS while the default for other
locales is Latin1_General_CI_AS.
From what I have read about these 2 collations, they are
the same. Is there any difference between these 2? How
should I decide which one to use? Or does it even matter
which one I use?
Report this post to a moderator
|
|
 08-06-02 12:23 AM
|
|
Narayana Vyas Kondreddi
Guest
Registered: Not Yet
Location:
Country:
State:
Certifications:
Working on:
Total Posts: N/A
|
|
|
Re: difference between SQL_Latin1_General_CP1_CI_AS and Latin1_General_CI_AS
First one is Windows collation and the latter is SQL collation.
It is better to stick to a single collation globally. Otherwise you will
experience problems when working with temporary tables.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server FAQ, articles, code samples, interview questions and more @
http://vyaskn.tripod.com/
"Shibani" <shibani.sanan@intraspect.com> wrote in message
news:105601c23cdd$ef22f600$3ae
f2ecf@TKMSFTNGXA09...
Hi,
On SQL Server 2000, when creating a database I saw that I
can choose either of these collations
- SQL_Latin1_General_CP1_CI_AS
- Latin1_General_CI_AS
The default for English Locale setting is
SQL_Latin1_General_CP1_CI_AS while the default for other
locales is Latin1_General_CI_AS.
From what I have read about these 2 collations, they are
the same. Is there any difference between these 2? How
should I decide which one to use? Or does it even matter
which one I use?
Report this post to a moderator
|
|
|
08-06-02 08:23 AM
|
|
Dan Guzman
Guest
Registered: Not Yet
Location:
Country:
State:
Certifications:
Working on:
Total Posts: N/A
|
|
|
Re: difference between SQL_Latin1_General_CP1_CI_AS and Latin1_General_CI_AS
To add to the response by Vyas, there are some minor differences between
these 2 collations with special characters. See
http://support.microsoft.com/defaul...;EN-US;Q305704&
The Books Online (architec.chm::/8_ar_da_3xbn.htm) suggests that you use
Windows collations unless you need to maintain compatibility.
Hope this helps.
Dan Guzman
SQL Server MVP
-----------------------
SQL FAQ links (courtesy Neil Pike):
http://www.ntfaq.com/Articles/Index...epartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
-----------------------
"Shibani" <shibani.sanan@intraspect.com> wrote in message
news:105601c23cdd$ef22f600$3ae
f2ecf@TKMSFTNGXA09...
> Hi,
>
> On SQL Server 2000, when creating a database I saw that I
> can choose either of these collations
> - SQL_Latin1_General_CP1_CI_AS
> - Latin1_General_CI_AS
>
> The default for English Locale setting is
> SQL_Latin1_General_CP1_CI_AS while the default for other
> locales is Latin1_General_CI_AS.
>
> From what I have read about these 2 collations, they are
> the same. Is there any difference between these 2? How
> should I decide which one to use? Or does it even matter
> which one I use?
Report this post to a moderator
|
|
|
08-06-02 03:23 PM
|
|
|
Forum Rules:
Who Can Read The Forum? Any registered user or guest.
Who Can Post New Topics? Any registered user.
Who Can Post Replies? Any registered user.
Changes: Messages can be edited by their author.
Posts: HTML code is OFF. Smilies are ON. vB code is ON. [IMG] code is OFF. |
|
ExamNotes forum archive
|
