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 |
|
Nick
Posting Yak Master
155 Posts |
 Posted - 2003-08-21 : 09:33:03
|
| Hello-I was wondering if it was possible for a column to store both English and Greek characters in SQL Server 2000. Doing some searching I have come across the notion of collations, but haven't been able to find any specific detail on how they work. All of my fields are defined as unicode friend (nvarchar vs. varchar and such). What else would I need to do to make this work?As an aside I will be inserting and retrieving data from an ASP page, so I'm thinking the encoding on those pages is also important. Does anyone have an opinion on that as well?Thanks in advance.-Nick |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2003-08-21 : 12:42:23
|
| collations is to do with sorting datastoring the stuff uses unicodeit also requires the correct character set to be implemented.search here for the 3 terms....you seem to be close......... |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-21 : 12:45:52
|
| You should store the information in two columns instead of one. One column would hold the Greek characters and the other would hold the English characters. Each column would have a different collation. Collations are discussed in detail in SQL Server Books Online.Tara |
|
|
|
|
|
|
Greek and English Collations