Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Unicode database/code pages

Author  Topic 

blakmk
Starting Member

45 Posts

Posted - 2003-04-11 : 06:33:24
Is there anyway to create a database that is of an entirely Unicode character set.

In oracle for example its posible to have a hybrid database, one main character set (eg Western European) plus specific Unicode datatypes (NChar, NVarChar) but also its possible to create a database that uses Unicode (UTF-8) as its character set. Is there any way to do this with sqlserver?

robvolk
Most Valuable Yak

15732 Posts

Posted - 2003-04-11 : 07:13:07
You can set collations at the database and column level in SQL Server 2000, but for earlier versions it can only be set at the server level. Books Online has details under CREATE DATABASE and CREATE TABLE.

Go to Top of Page
   

- Advertisement -