Jul 23, 2007 04:48 PM|NeoRev|LINK
We have an existing C# application that uses SQL Server 2000 database. Currently, the app is English-only, however the business now wants to internationalize the app to support multiple languages (Spanish, Russian, Chinese, Korea, etc.). We will have only
one database. So, data in multiple languages will be stored in the same database.
My question is about how this affects the ORDER BY clauses in our SQL stored procedures.
I found an article on Microsoft's web site which seemed to imply that we will have to use COLLATE on every single ORDER BY. If this is true, that means we'll have to pass down a collation name to the stored procedures and then have huge CASE blocks for
This seems crazy to me.
Can anyone clear this up?