Member Avatar for pawangargmit

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

  • 2 Contributors
  • 1 Reply
  • 132 Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by kvprajapati
Member Avatar for kvprajapati

UNICODE .
Returns the integer value, as defined by the Unicode standard, for the first character of the input expression.

SELECT     
  UNICODE(SUBSTRING(colName, 1, 1)) 
FROM  TABLENAME
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.