Hi,
I am installing SQL 2008 for a web project.
My question is which Collation should I select for a web site database which can receive all languages and characters?
My understanding is that I can use varchar and nvarchar to Insert the data for specific character coming in from the web site. I assume varchar and nvarchar will mange to collect all collation characters we have on this planet today.
The key is to select the data in the country collation selected by the user using the web site; when the data is presented back on the web site (In correct sort order for the specific user).
I assume I can find the Collation on every client PC who is using the web site and present the data back correctly.
I assume I should select following parameters on my SQL 2008 server:
•Binary
•Case-sensitive
•Accent-sensitive
•Binary-code point
•Kana-sensitive
•With-sensitive
...but which Collation designator should I select on my SQL 2008 server?
After reading (Pre-SQLServer2008_NativeDataProviders_and_NewCollations.docx) I assume is doesn’t matter; because the Client-to-SQL Server Data Flow and Data Conversions is done between my server and the client using the web site (See below); if the user is using Microsoft OS; what about if not (Linux and Firefox)???
Thank you, Rune
Client-to-SQL Server Data Flow and Data Conversions The following figures illustrate scenarios in which the native data providers must convert the data into the corresponding code page used by SQL Server char and varchar data types or into Unicode. In figures 1 and 2, data conversions occur when the Windows active code page on the client and the database collation that is used to store the character data used by the char and varchar data types are in different code pages.