MS SQL Server - Collation

Author

Collation

Seelan Raja

2006-04-05, 11:24 am

Hey guys,
How do I
1) Set the COLLATION_SEQ to charset=iso_1 sort_order=nocase_is
o
charset_num=1 sort_order_num=52 on the master database and rebuild it

2. Dictionary Order, Case Insensitive.

amish

2006-04-05, 1:25 pm

use Rebuildm.exe and specify collation , SQL Server will build master
database with new collation.

Regards
Amish Shah

Seelan Raja

2006-04-05, 1:25 pm

Thanks Amish,
But I dont see a specific setting for
COLLATION_SEQ to charset=iso_1 sort_order=nocase_is
o

charset_num=1 sort_order_num=52

Can u please help? Im new to SQL

Thanks

"amish" <shahamishm@gmail.com> wrote in message
news:1144254842.055747.245210@j33g2000cwa.googlegroups.com...
> use Rebuildm.exe and specify collation , SQL Server will build master
> database with new collation.
>
> Regards
> Amish Shah
>

amish

2006-04-06, 3:23 am

AFAIK default collation

dictionary order, case insensitive,for use with 1252 character set

is equivalent to this.

After installation to verify look at exec sp_server_info 18.

Regards
Amish Shah.

John Bandettini

2006-04-06, 9:23 am

Seelan

Use the Rebuild master utility. It is Rebuildm.exe and it is located in the
Program Files\Microsoft SQL Server\80\Tools\Binn
directory. See BOL ofr more
details.

regards

john

"Seelan Raja" wrote:

> Hey guys,
> How do I
> 1) Set the COLLATION_SEQ to charset=iso_1 sort_order=nocase_is
o
> charset_num=1 sort_order_num=52 on the master database and rebuild it
>
> 2. Dictionary Order, Case Insensitive.
>
>
>

Seelan Raja

2006-04-06, 11:24 am

Thanks Guys,
One more thing,
IS there a website or a reference page where i can see the settings for
collation. For example, Amish said charset=iso_1 sort_order=nocase_is
o
charset_num=1 sort_order_num=52 is DEFAULT collation.

Where can I see this table??

Thanks

"Seelan Raja" < seelan_rd@NOSPAMyaho
o.com> wrote in message
news:%23VJymIMWGHA.5012@TK2MSFTNGP05.phx.gbl...
> Hey guys,
> How do I
> 1) Set the COLLATION_SEQ to charset=iso_1 sort_order=nocase_is
o
> charset_num=1 sort_order_num=52 on the master database and rebuild it
>
> 2. Dictionary Order, Case Insensitive.
>
>

Sponsored Links