Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Dhanushkodi
Starting Member
21 Posts |
 Posted - 2013-09-12 : 08:24:19
|
| 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
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-09-12 : 09:06:08
|
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; |
 |
|
|
Dhanushkodi
Starting Member
21 Posts |
Posted - 2013-09-12 : 09:16:51
|
| Mr. James,following is the query,SELECT * FROM tblname WHERE colname= N'????????????'it's not bring the result.thanks,Dhanushkodi |
|
|
|
Dhanushkodi
Starting Member
21 Posts |
Posted - 2013-09-12 : 09:24:38
|
| Mr. James,sorry sir, query is working. actually data have space , but i put the data without space. thank you very much.Dhanushkodi |
|
|
|
|
|
|
Multi language query