String data from oracle is being converted in to a kind of cipher text ...

Question

0.00/5 (No votes)

See more:

i am using System.Data.OracleClient.Dll version 2.0.0.0
and oracle 9i and visual studio 2008 and vb.net language.

I have tried using System.Text for Encoding it in windows defalult encoding before displaying it but nothing worked. please save me.

Posted 14-Dec-14 21:56pm

varun150

Add a Solution

Comments

Richard MacCutchan 15-Dec-14 4:33am

What is the format of the data in the Oracle database?

varun150 15-Dec-14 4:50am

if i view this data in Oracle(Toad) then it fine but it displays a non readable format
in my windows forms app

Converted Data has datatype Varchar2 in Oracle Length 20

Richard MacCutchan 15-Dec-14 5:03am

Then you must be converting it into something. Check exactly what encoding Varchar2 is.

Richard MacCutchan 15-Dec-14 5:04am

See also http://www.orafaq.com/wiki/Varchar2.

varun150 15-Dec-14 5:48am

i do not understand this..

VARCHAR2 data is stored as variable length values: at http://www.orafaq.com/wiki/Varchar2.

what does it mean variable lenght values.
Does it mean lenght of variable in bytes and thats how calculate column lenght for storage.
How can it change the text to be displayed on windows form.

Richard MacCutchan 15-Dec-14 6:00am

It just means byte data and can be any length. But if you don't know what the actual format of the field is then how can anyone else guess?

varun150 15-Dec-14 6:12am

Are asking encoding in oracle database ,its set to default.
columns datatype is Varchar2 in oracle database table
and i m fetching it using oracle datatable
then converting to string then showing in Datagrid.

tell me what format you are asking if i am wrong.
http://i.stack.imgur.com/Heubs.jpg

Richard MacCutchan 15-Dec-14 6:23am

What are you converting to String? Unless you know what the original data is, then that conversion serves no purpose.

varun150 15-Dec-14 6:46am

i am converting to string whatever dataReader returns but you are right,I dont know what format datareader using to return varchar2 from sql.

and i dont even how to know the datatype returned by datareader.

Richard MacCutchan 15-Dec-14 7:06am

That has nothing to do with it. You need to talk to the owners of the database to find out what it is.

varun150 15-Dec-14 7:11am

ok.

varun150 15-Dec-14 7:14am

i talked to them they dont know what it is.

Jörgen Andersson 1-Jan-15 6:18am

You need to make sure the Oracle client software has the same NLS_Lang setting as on the client that entered the data, and preferably also the same as on the server.

Have a first look here: http://www.oracle.com/technetwork/products/globalization/nls-lang-099431.html

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)