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 |
|
TonyCav
Starting Member
4 Posts |
 Posted - 2010-04-27 : 09:33:43
|
| Currently our SQL server Collation is set to Latin1_General_CI_AS.But there is a global need to store messages in other languages not covered by Latin1_General_CI_AS.These languages have there own Collation, but using them will mean that we can only store data in that language.Is there a way to set our DB up so that we can store say both Greek an English.Thanks for any Help. |
|
|
TonyCav
Starting Member
4 Posts |
Posted - 2010-04-27 : 10:48:05
|
| Sorted the text was being stored as a VARCHAR(MAX) I just changed it to NVARCHAR(MAX) and it will now store Greek as well as English |
 |
|
|
|
|
|
Unicode is there a global Collations covers all.