February 4, 2010 at 10:49 pm
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
February 5, 2010 at 12:55 am
Why don't you add another column say "Language" and while inserting rows in the table insert a value say
"HINDI","ENGLISH" .... This way you would be able to get a count easily.
February 5, 2010 at 1:43 am
Reason is we have a textarea in which user can put above listed languages text without knowing us which language is this...
So again I am putting my question,
Please suggest how to write a query to know the count for all the rows having Hindi text?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply