SQL Server Performance Forum – Threads Archive

unicode database ?

Hi folks, There are relevat articles on building unicode database which paly around with data types nvarchar , ntext etc.. Do we have setting whne creating database to define it unicode or is it rather defining right data type which supports unicode at table level ?
Cheers
Sat

---

The easiest way to manage character data in international databases is to always use the Unicode nchar, nvarchar, and nvarchar(max) data types, instead of their non-Unicode equivalents, char, varchar, and text. SQL Server 2005 stores all textual system catalog data in columns having Unicode data types. The names of database objects, such as tables, views, and stored procedures, are stored in Unicode columns. This enables applications to be developed by using only Unicode, and helps avoid all issues with code page conversions. Get more frm BOL on Unicode topic. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

---

Thx Satya.. Cheers
Sat

---

]]>