Hindi text in nText column SQL Server 2005

Expand Post »

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

Similar Threads

select data from sql server 2005 in VB.NET
Select data from sql server 2005 DB table. in VB.NET
view data from sql server 2005 in ASP.NET
Getting filegroup name from SQL Server 2005 in MS SQL
SQL Server 2005 vs SQL Server 2008 in C#

pawangargmit

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Feb 2010

Permalink

Feb 8th, 2010

Re: Hindi text in nText column SQL Server 2005

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

MS SQL Syntax (Toggle Plain Text)
SELECT     
  UNICODE(SUBSTRING(colName, 1, 1)) 
FROM  TABLENAME
SELECT     
  UNICODE(SUBSTRING(colName, 1, 1)) 
FROM  TABLENAME

adatapost

Moderator

Reputation Points: 2136

Solved Threads: 1228

Posting Genius

Offline

6,524 posts
since Oct 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MS SQL Forum Timeline: Set a counting for number of field base on a specific common data in a certain field

Next Thread in MS SQL Forum Timeline: how to pass column name as parameter

DaniWeb Message

Cancel Changes

User Name
Password