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.
| Author |
Topic |
|
sapumal
Starting Member
1 Post |
 Posted - 2006-01-12 : 06:29:12
|
| How can I set the character set for a database to Unicode. This can be done in Oracle, MySQL, DB2. But I have not found a way to do this in Sqlserver. At database creation time, we need to give the collation and then the server use the appropriate code page for it. But in order to use an unicode encoding for whole database I have no suitable collation in the collation list. |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2006-01-12 : 07:18:14
|
| I don't think you can....unicode is specified at column(field) level....CHAR v nCHAR or VARCHAR v nVARCHAR. |
 |
|
|
Arnold Fribble
Yak-finder General
1961 Posts |
Posted - 2006-01-12 : 07:19:37
|
quote:
Originally posted by sapumalHow can I set the character set for a database to Unicode.
You can't. If you want to be able to store all* characters from Unicode, you have to use the nchar, nvarchar or ntext datatypes. The character repertoire for columns of these types is unaffected by the collation.The character repertoire for columns of the char, varchar and text datatypes are affected by the collation on the column. However, there is no collation in SQL Server that would allow you to store all Unicode characters in columns of those types.* well, all characters in the BMP. SQL Server has issues with characters in other planes. |
|
|
|
|
|
|
database level character set