Unicode Characters And Oracle

[Ram]

Hey,
I'm using VB.NET and I'm trying to execute SQL Command,
Where one of the parameters I'm trying to insert, has some unicode
characters.
The execute command gives no error, but when I use Nevigator to see the new
line,
Alll the unicode characters have been misteryously converted to - "?" !!!
I'v tried every known Oracle Provider - ADO 2.7,
System.Data.Oracle,Oracle.DataAccess (ODP) and OleDB, and had no success...
My Oracle DataBase is 9.2, And I'm using FrameWork 1.1
Please - I need help ASAP!

Thansk ahead

--Ram

[Cor Ligthert]

Ram,

Not that you are not welcome here, but most Oracle people are in this
newsgroup.

Adonet
news://msnews.microsoft.com/microsof...amework.adonet

Web interface:
http://communities2.microsoft.com/co...amework.adonet

I give you much more change there,

Cor
"Ram" <ni***@bezeqint.net>

I'm using VB.NET and I'm trying to execute SQL Command,
Where one of the parameters I'm trying to insert, has some unicode
characters.
The execute command gives no error, but when I use Nevigator to see the
new
line,
Alll the unicode characters have been misteryously converted to - "?" !!!
I'v tried every known Oracle Provider - ADO 2.7,
System.Data.Oracle,Oracle.DataAccess (ODP) and OleDB, and had no
success...
My Oracle DataBase is 9.2, And I'm using FrameWork 1.1
Please - I need help ASAP!

Thansk ahead

--Ram

[Anand[MVP]]

Is your base column in Oracle defined to store unicode characters(nvarchar
instead of varchar etc). Also if I remember right you need to set the NLS
settings in both client and server for Oracle.

Rgds,
Anand M
VB.NET MVP
http://www.dotnetindia.com

"Ram" wrote:

Hey,
I'm using VB.NET and I'm trying to execute SQL Command,
Where one of the parameters I'm trying to insert, has some unicode
characters.
The execute command gives no error, but when I use Nevigator to see the new
line,
Alll the unicode characters have been misteryously converted to - "?" !!!
I'v tried every known Oracle Provider - ADO 2.7,
System.Data.Oracle,Oracle.DataAccess (ODP) and OleDB, and had no success...
My Oracle DataBase is 9.2, And I'm using FrameWork 1.1
Please - I need help ASAP!

Thansk ahead

--Ram