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 |
|
paramu
Posting Yak Master
151 Posts |
 Posted - 2012-04-18 : 11:27:02
|
Hi,Iam using SqlServer2008. I have a table MyTbl and contains data in Arabic... So I want to learn how to select a value for this NVARCHAR() Fields?My Select Query doesn't give the Output..Any mistake is there?My Query:=========Select * from MyTbl where arb_type_name='????' The above query data is correct... And the field type is NVARCHAR() But it's not giving the output...Thanks for right directions..Paramu @ PARANTHAMAN |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2012-04-18 : 12:20:43
|
If you supplying the string predicate (????), then you probably need to tell SQL that you are using an unicode string. You denote that be putting an "n" in front of the string literal. For example:Select * from MyTbl where arb_type_name=N'????' |
 |
|
|
paramu
Posting Yak Master
151 Posts |
Posted - 2012-04-19 : 01:53:38
|
| Thanks Lamprey........Paramu @ PARANTHAMAN |
|
|
|
|
|
|
Select Query for Arabic_Languages -NVARCHAR() ?