Unanswered: Hindi text in nText column SQL Server 2005
We are using SQL Server 2005, and saving Hindi, English, Japaneese, Chiness languages in nText column.
This all we are doing using google analytical. However, we don't know how to know which value is Hindi or Englsh as they are encoded.
Please suggest how to write a query to know the count for all the rows having Hindi text.
Provided no ntext value (and you should probably change that to nvarchar(max)) has multiple languages, you could try to judge which unicode range the first non whitespace character comes from. It will take me a few minutes to come up with an example, but you should be able to tell what ranges each characterset occupies in the unicode standard.