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 |
|
Mednyk
Starting Member
2 Posts |
 Posted - 2011-11-30 : 18:19:24
|
| Question about how to better handle the Unicode data in particular case:Hi everybody, Here is situation:I have 40 databases with SQL_LATIN_general_CP1_CI_AI Collation, they have the same structure. They are on SQL SERVER 2000 but we are planning very soon to migrate them on SQL Server 2008. I need to be able to insert, sort, update, select Cyrillic, Portuguese, German and so on from one of the databases. What is the best way to do it. We were thinking to either convert existing or create new database in Unicode…. But which collation should we pick? And what is the best way to do it for Performance, Storage and lesser Effort.I was thinking maybe some of you already have experience dealing with UNICODE databases.Also If we do change it to Unicode… Do we still need nvarchar fields, or varchar fields are going to handle it? Also this Unicode database will need to connect to LATIN_general ones on the same or different servers.Thank you very much for your help in advance.P.S. The database has more then 1000 tables...with data (nvarchar ,varchar ,text etc.) |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2011-12-01 : 16:26:17
|
| nvarchar,nchar and ntext are used for unicode data storage. Collation depends on your requirement. |
 |
|
|
Mednyk
Starting Member
2 Posts |
Posted - 2011-12-02 : 11:22:14
|
| Hello, I cannot change all existing fields of a database I have more 9000 of themMy question is : is there a Unicode collation , so I can change a whole database to be UNICODE and work for Cyrillic and Latin . In sql server 2000 or 2008 (which we will migrate soon)Thank you |
|
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2011-12-02 : 18:32:29
|
| Unicode and Collation are two separate concepts. Unicode allows a fuller set of languages to be supported by using two bytes per character. Collation relates to concepts such as upper vs lower case, accent marks, et al, which will be present in any alphabet.=======================================Faced with the choice between changing one's mind and proving that there is no need to do so, almost everyone gets busy on the proof. -John Kenneth Galbraith |
|
|
|
|
|
|
|
|
How to better handle the Unicode data