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 colla
tion 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.ph
x.gbl...
> Hello,
> How can I find out from SQL SRV2000 which characterset and collation is us
ed.
> 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...[vbcol=seagreen]
> 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:
>|||Hi,
To change the collation server level we need to rebuild the master database
and it requires downtime.
http://msdn.microsoft.com/library/d.../>
ll_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...
>|||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...
>
>|||Alternatively you can remove and re-install!!
John
"Hari Prasad" wrote:
> Hi,
> To change the collation server level we need to rebuild the master databas
e
> and it requires downtime.
> http://msdn.microsoft.com/library/d...
tall_8w8p.asp
> Thanks
> Hari
> SQL Server MVP
>
> "William Stokes" <will@.operamail.com> wrote in message
> news:OptCyOfwGHA.4576@.TK2MSFTNGP03.phx.gbl...
>
>
Thursday, February 16, 2012
Charset&collation
Labels:
characterset,
charsetcollation,
collation,
database,
microsoft,
mysql,
oracle,
server,
sql,
srv2000
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment