I am in the process of creating localized ASP.NET 2.0 application.  I am new to localization so any help would be appreciated...

The question I have is "How do GridViews, Sorting, Localization and the Database work together?".  Let me get a little more specific.

Let say I have a Gridview that does CustomPaging.  The Gridview has one column ('Name') and is sortable.  I also have custom paging enable for the Grid.

For the CustomPaging, assume I have methods that query the database to populate my VirtualPageCount and retrieves data for the current page.  The method that retrieves the data executes a sql statement that only returns the row for the current page (the query look like SELECT [name] FROM [Customer] ORDER By [name]).  My SQL/Server database is setup to use language (English (US)) and Server Collation (SQL_Latin1_General_CP1_CI_AS).

In my browser, I set my culture to en-US.  I click the 'Name' column to sort.  Everything is sorts correctly.  NOW, I change my browser culture to fi (Finish).  In Finnish, 'W' and 'V' sort differently than en-US.  The database returns the data in the server collation order.  However, the browser need to display in Finnish order.

Any suggestion on how I can have my browser sort correctly when culture is set to Finnish and the Database collation is SQL_Latin1_General_CP1_CI_AS?

 Thanks.

 
Steve