ODP.NET

I am programming in C# and querying against an oracle9i database that is unicode. Here is my problem: I am querying a database based off a usr_id, and when I call the .Fill(DataSet) routine it doesn't find the proper rows if the user_id is in a foreign language.

- When sending it a query such as "select * from wst_usg where usr_id = N'testuser'" it finds the record correctly.

- But sending it a query where 'testuser' is replaced with a foreign name, such as russian or chinese, like "select * from wst_usg where usr_id = N'insertrussiancharacternamehere'", it finds zero records.

- However if I simply do "select * from wst_usg" and then use the DataTable.Select() function to search for the foreign language name, the record is found.

Any ideas why this isn't working? Like I said the database is unicode and the column "usr_id" is of type nvarchar. It just seems odd that it works on the english usernames but not the foreign ones when using the "where" clause.

Note, we are changing over to support unicode, so simply using the DataTable.Select() workaround isn't really an option, as the .Fill code is already in place and we would like to avoid changing all that code.

Thanks
Jim