How to change characterset in SQL Enterprise Manager?

Hi,
I want to change characterset to Unicode in server 2000.
How I can do it?
Thanks,
ms_sql_characterset
If you want to change all you character data to unicode, you will need to
alter all your char, varchar, and text fields to nchar, nvarchar, and ntext
fields.
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"ms_sql_characterset" <anonymous@.discussions.microsoft.com> wrote in message
news:1c37301c4523a$8f26ec10$a101280a@.phx.gbl...
> Hi,
> I want to change characterset to Unicode in server 2000.
> How I can do it?
> Thanks,
> ms_sql_characterset
>
>
|||Yes, I will alter them to nchar, nvarchar, and ntext. But
where I can set sql server characterset to unicode?
Thanks,

>--Original Message--
>If you want to change all you character data to unicode,
you will need to
>alter all your char, varchar, and text fields to nchar,
nvarchar, and ntext
>fields.
>--
>----
--
>----
--
>--
>Need SQL Server Examples check out my website at
>http://www.geocities.com/sqlserverexamples
>"ms_sql_characterset"
<anonymous@.discussions.microsoft.com> wrote in message[vbcol=seagreen]
>news:1c37301c4523a$8f26ec10$a101280a@.phx.gbl...
2000.
>
>.
>
|||By character set I guess you mean code page, or another name might be
collation setting. Unicode and collation are really two different things.
The collation setting of a server/database/column is how SQL Server stores
char, varchar, and text fields, which of course are not UNICODE data types.
This article should provide you with information about how to change the
collation settings of a server, a database and/or a column.
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
<anonymous@.discussions.microsoft.com> wrote in message
news:1c13001c45243$9c920c00$a301280a@.phx.gbl...[vbcol=seagreen]
> Yes, I will alter them to nchar, nvarchar, and ntext. But
> where I can set sql server characterset to unicode?
> Thanks,
>
> you will need to
> nvarchar, and ntext
> --
> --
> <anonymous@.discussions.microsoft.com> wrote in message
> 2000.