SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 Multi language query
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Dhanushkodi
Starting Member

India
21 Posts

Posted - 09/12/2013 :  08:24:19  Show Profile  Reply with Quote
Hi All,

i have tamil values in my table columns.

How can i select or give that value in where clause. please explain.

thanks,
Dhanushkodi

James K
Flowing Fount of Yak Knowledge

3705 Posts

Posted - 09/12/2013 :  09:06:08  Show Profile  Reply with Quote
Make sure that the column is of type NCHAR or NVARCHAR. Then, you would use it like in the example below.
CREATE TABLE #tmp(col1 NVARCHAR(64));
INSERT INTO #tmp VALUES (N'A Tamil Expression');
INSERT INTO #tmp VALUES (N'Another Tamil Expression');
SELECT * FROM #tmp WHERE col1 = N'A Tamil Expression';
DROP TABLE #tmp;

Edited by - James K on 09/12/2013 09:06:19
Go to Top of Page

Dhanushkodi
Starting Member

India
21 Posts

Posted - 09/12/2013 :  09:16:51  Show Profile  Reply with Quote
Mr. James,

following is the query,

SELECT * FROM tblname WHERE colname= N'????????????'

it's not bring the result.


thanks,
Dhanushkodi
Go to Top of Page

Dhanushkodi
Starting Member

India
21 Posts

Posted - 09/12/2013 :  09:24:38  Show Profile  Reply with Quote
Mr. James,

sorry sir, query is working. actually data have space , but i put the data without space.

thank you very much.

Dhanushkodi

Edited by - Dhanushkodi on 09/12/2013 09:25:37
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000