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 |
|
vishal.todkar
Starting Member
20 Posts |
 Posted - 2009-07-30 : 05:03:50
|
| We have requirement for Multilingual Database support for the web application.All the string/text type database columns are using NVARCHAR data types. Currently my database can store and retrieve UNICODE and multilingual data. The main requirement is - Sorting should be based on local language settings. For example say webserver is in japanaese and database has multilingual data, and database server collation is English. when I search firstname or lastname on webclient it should sort the result according to Japanese collation. When my webserver is in German locale, the result should be sorted by German collation. There are two options to achieve this.1) Set collation in ORDER BY clauses.2) Set collation in the connection string.Both does not seems to be feasible solutions because in SQL Server, there are numerous collations available. Which one to chose based on OS locale is very tough.Any other suggestions or advice, how I can achieve this? Thanks in advance.Thanks & RegardsVishal |
|
|
|
|
|
Need help on Multilingual Database support