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 |
|
sneha_inpursuitofdreams
Starting Member
1 Post |
 Posted - 2008-12-05 : 12:28:41
|
| I have a databse with collation as SQL_Latin1_General_CP1_CI_AS. I want to save Swedish strings in my database. I am using non-unicode datatype like char and text to save strings. If I save Swedish strings in my DB will they be sorted in proper order?Can anybody guide me on Sql server collation? How does it affect sorting and storing the data? If my database has collation SQL_Latin1_General_CP1_CI_AS and my System Locale has some different collation say Swedish.....which code page will be used to save data in database and which sorting order will be followed? Does System Locale impact the sorting order of data in Sql Database if there is Locale difference? Does datatypes come in to picture here? |
|
|
under2811
Constraint Violating Yak Guru
366 Posts |
Posted - 2009-05-18 : 06:15:10
|
| No Way!!!can u ellaborate!! |
 |
|
|
|
|
|
Collation in Sql Server