I have nvarchar column in sql server 2005 and it can contain data in English, Turkish or Russian.
Supposing that I know the language of any given string beforehand, how do I make lower/upper convert "i" in Turkish and English correctly? I need it to change between dotless capital I and small dotted i for English, and I want it to retain the dot or its absense for both cases for Turkish. What kind of collations do I use or do I use something else?
Supposing that I know the language of any given string beforehand, how do I make lower/upper convert "i" in Turkish and English correctly? I need it to change between dotless capital I and small dotted i for English, and I want it to retain the dot or its absense for both cases for Turkish. What kind of collations do I use or do I use something else?