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 |
|
nebrom
Starting Member
1 Post |
 Posted - 2007-04-21 : 02:05:42
|
| CREATE TABLE product( product_id integer , translated_name NVARCHAR2(50) ); insert into product values(1,N'kenenisa')insert into product values(2,N'Ethiopia')Note that i have used N becuase it is unicode data thenselect * from product; this works fine.select * from product where product_id=1; this also works fine,but select * from product where translated_name=N'kenenisa'; this doesnot work correctly, so how can i fix this problem ? |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-04-21 : 02:18:17
|
this is a SQL Server forum.try http://www.dbforums.com for oracle questions.
www.elsasoft.org |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-21 : 20:27:28
|
| By the way, it works on sql server. :=) |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-04-21 : 22:41:17
|
well, everything but the NVARCHAR2 part 
www.elsasoft.org |
|
|
|
|
|
|
How to select non english values from a table?