Charset&collation

Hello,
How can I find out from SQL SRV2000 which characterset and collation is
used.
Thanks
-WillWilliam
SELECT SERVERPROPERTY('Collation') AS [Collation]
sp_helpsort
"William Stokes" <will@.operamail.com> wrote in message
news:OLTYuFdwGHA.4612@.TK2MSFTNGP02.phx.gbl...
> Hello,
> How can I find out from SQL SRV2000 which characterset and collation is
> used.
> Thanks
> -Will
>|||DATABASEPROPERTYEX and SERVERPROPERTY can show this. Note that default collation for a database
can differ from the default for the instance.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"William Stokes" <will@.operamail.com> wrote in message news:OLTYuFdwGHA.4612@.TK2MSFTNGP02.phx.gbl...
> Hello,
> How can I find out from SQL SRV2000 which characterset and collation is used.
> Thanks
> -Will
>|||Hi William
For the database level you can see this in the status column when using
sp_helpdb
For column level collations you can see it using sp_help for the table or in
the INFORMATION_SCHEMA.COLUMNS view,
For more information on a collation try:
SELECT name, description,
COLLATIONPROPERTY( name, 'CodePage' ) AS CodePage ,
COLLATIONPROPERTY( name, 'LCID' ) AS LCID,
COLLATIONPROPERTY( name, 'ComparisonStyle' ) AS ComparisonStyle
FROM ::fn_helpcollations()
John
"William Stokes" wrote:
> Hello,
> How can I find out from SQL SRV2000 which characterset and collation is
> used.
> Thanks
> -Will
>
>|||Cheers!
One more quoestion. If a DB instance collation sort order was setup as
"Binary" can it be changed afterwards to "Accent sensitive"?
Thanks
-Will
"John Bell" <jbellnewsposts@.hotmail.com> kirjoitti
viestissä:F3CB400B-1E1C-4935-BA2F-A812450BCA7C@.microsoft.com...
> Hi William
> For the database level you can see this in the status column when using
> sp_helpdb
> For column level collations you can see it using sp_help for the table or
> in
> the INFORMATION_SCHEMA.COLUMNS view,
> For more information on a collation try:
> SELECT name, description,
> COLLATIONPROPERTY( name, 'CodePage' ) AS CodePage ,
> COLLATIONPROPERTY( name, 'LCID' ) AS LCID,
> COLLATIONPROPERTY( name, 'ComparisonStyle' ) AS ComparisonStyle
> FROM ::fn_helpcollations()
>
> John
> "William Stokes" wrote:
>> Hello,
>> How can I find out from SQL SRV2000 which characterset and collation is
>> used.
>> Thanks
>> -Will
>>|||Hi,
To change the collation server level we need to rebuild the master database
and it requires downtime.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_install_8w8p.asp
Thanks
Hari
SQL Server MVP
"William Stokes" <will@.operamail.com> wrote in message
news:OptCyOfwGHA.4576@.TK2MSFTNGP03.phx.gbl...
> Cheers!
> One more quoestion. If a DB instance collation sort order was setup as
> "Binary" can it be changed afterwards to "Accent sensitive"?
> Thanks
> -Will
> "John Bell" <jbellnewsposts@.hotmail.com> kirjoitti
> viestissä:F3CB400B-1E1C-4935-BA2F-A812450BCA7C@.microsoft.com...
>> Hi William
>> For the database level you can see this in the status column when using
>> sp_helpdb
>> For column level collations you can see it using sp_help for the table or
>> in
>> the INFORMATION_SCHEMA.COLUMNS view,
>> For more information on a collation try:
>> SELECT name, description,
>> COLLATIONPROPERTY( name, 'CodePage' ) AS CodePage ,
>> COLLATIONPROPERTY( name, 'LCID' ) AS LCID,
>> COLLATIONPROPERTY( name, 'ComparisonStyle' ) AS ComparisonStyle
>> FROM ::fn_helpcollations()
>>
>> John
>> "William Stokes" wrote:
>> Hello,
>> How can I find out from SQL SRV2000 which characterset and collation is
>> used.
>> Thanks
>> -Will
>>
>|||iHi
It can be changed, but you would need to change it at the database and for
each column that has a collation. See http://tinyurl.com/429qa and previous
posts such as http://tinyurl.com/om6b4
John
"William Stokes" wrote:
> Cheers!
> One more quoestion. If a DB instance collation sort order was setup as
> "Binary" can it be changed afterwards to "Accent sensitive"?
> Thanks
> -Will
> "John Bell" <jbellnewsposts@.hotmail.com> kirjoitti
> viestissä:F3CB400B-1E1C-4935-BA2F-A812450BCA7C@.microsoft.com...
> > Hi William
> >
> > For the database level you can see this in the status column when using
> > sp_helpdb
> >
> > For column level collations you can see it using sp_help for the table or
> > in
> > the INFORMATION_SCHEMA.COLUMNS view,
> >
> > For more information on a collation try:
> >
> > SELECT name, description,
> > COLLATIONPROPERTY( name, 'CodePage' ) AS CodePage ,
> > COLLATIONPROPERTY( name, 'LCID' ) AS LCID,
> > COLLATIONPROPERTY( name, 'ComparisonStyle' ) AS ComparisonStyle
> > FROM ::fn_helpcollations()
> >
> >
> > John
> >
> > "William Stokes" wrote:
> >
> >> Hello,
> >>
> >> How can I find out from SQL SRV2000 which characterset and collation is
> >> used.
> >>
> >> Thanks
> >> -Will
> >>
> >>
> >>
>
>|||Alternatively you can remove and re-install!!
John
"Hari Prasad" wrote:
> Hi,
> To change the collation server level we need to rebuild the master database
> and it requires downtime.
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_install_8w8p.asp
> Thanks
> Hari
> SQL Server MVP
>
> "William Stokes" <will@.operamail.com> wrote in message
> news:OptCyOfwGHA.4576@.TK2MSFTNGP03.phx.gbl...
> > Cheers!
> >
> > One more quoestion. If a DB instance collation sort order was setup as
> > "Binary" can it be changed afterwards to "Accent sensitive"?
> >
> > Thanks
> >
> > -Will
> >
> > "John Bell" <jbellnewsposts@.hotmail.com> kirjoitti
> > viestissä:F3CB400B-1E1C-4935-BA2F-A812450BCA7C@.microsoft.com...
> >> Hi William
> >>
> >> For the database level you can see this in the status column when using
> >> sp_helpdb
> >>
> >> For column level collations you can see it using sp_help for the table or
> >> in
> >> the INFORMATION_SCHEMA.COLUMNS view,
> >>
> >> For more information on a collation try:
> >>
> >> SELECT name, description,
> >> COLLATIONPROPERTY( name, 'CodePage' ) AS CodePage ,
> >> COLLATIONPROPERTY( name, 'LCID' ) AS LCID,
> >> COLLATIONPROPERTY( name, 'ComparisonStyle' ) AS ComparisonStyle
> >> FROM ::fn_helpcollations()
> >>
> >>
> >> John
> >>
> >> "William Stokes" wrote:
> >>
> >> Hello,
> >>
> >> How can I find out from SQL SRV2000 which characterset and collation is
> >> used.
> >>
> >> Thanks
> >> -Will
> >>
> >>
> >>
> >
> >
>
>