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 |
|
wkm1925
Posting Yak Master
207 Posts |
 Posted - 2010-01-24 : 07:44:27
|
| What a unicode data? Can someone show me the sample of unicode string?Me assume, email such as wkm1925@yahoo.com is a unicode. Correct me. if I'm wrong |
|
|
Kristen
Test
22859 Posts |
|
|
wkm1925
Posting Yak Master
207 Posts |
|
|
Kristen
Test
22859 Posts |
|
|
wkm1925
Posting Yak Master
207 Posts |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2010-01-25 : 06:55:26
|
| correct....other languages also affected. japanese, chinese, swedish, etc |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2010-01-25 : 06:59:36
|
Hey... Swedish is covered on Windows 1252 code page, SQL_Latin and other single byte character sets!
N 56°04'39.26"E 12°55'05.63" |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-01-25 : 07:32:30
|
| Indeed, its not as simple as Arabic / Spanish require Unicode.I think that all languages with with non-Roman characters require Unicode.Roman-character languages can use non-unicode, but may then need appropriate codepage to support any accents etc.A mix of Roman-character languages may not be possible to support in non-unicode because all the accents may not be available.But if you can use non-unicode you save 50% of your storage (although there is compression in SQL 2008 which may reduce this) |
|
|
|
|
|
|
What's a unicode data?