470,591 Members | 2,005 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,591 developers. It's quick & easy.

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
Nov 21 '05 #1
2 2181
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

Nov 21 '05 #2
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

Nov 21 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by oozyscab via AccessMonster.com | last post: by
2 posts views Thread by Ram | last post: by
24 posts views Thread by ChaosKCW | last post: by
8 posts views Thread by Richard Schulman | last post: by
8 posts views Thread by Yves Dorfsman | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.