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 |
|
linokd
Starting Member
2 Posts |
 Posted - 2009-08-24 : 09:26:58
|
| Hi, I have nvarchar field which contains data in different languages.Whenever i fire a select query on this table i get improper data.(??? characters instead of actual data) If any one can help me with this. Thanks,Nilesh |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-08-24 : 09:40:50
|
| What is the collation of the column?You can try something like this: Maybe in a CASE statement, for the different languagesselect AddressLine1 collate Lithuanian_100_CS_AS_KS from Person.Address |
 |
|
|
|
|
|
Foreign Language Support.