Prev: How to copy a DTS package?
Next: [IMPORTANT!!!] Windows erasing SAN disk
From: pawangargmit on 5 Feb 2010 00:27
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.

Pawan Garg

From: pawangargmit on 5 Feb 2010 07:00
Here we have used ntext to save Hindi or English, yes we can also use
nVarchar(max) fro it.
Also we don't have any column in DB w.r.t. the data which says that it is of
english or hindi, this is because we have any text area where user can put
the message (using copy\paste) without any dropdown and then we are saving it.


Now again I am repeating my question, Please suggest how to write a query to
know the count for all the rows having Hindi text.

Pawan Garg

 | 
Pages: 1
Prev: How to copy a DTS package?
Next: [IMPORTANT!!!] Windows erasing SAN disk