I need Help retrive data from table

[Me.Net]

Good Afternon everybody

I am trying to retrive data from table in Oracle database

using this statement

Dim cm As New OracleCommand("select exp_id,exp_name from ean_master

where EXP_NAME LIKE '%ram%', con)

but no data retrived but when i execute this statment using plsql enviroment

i got result ???

any suggestions ??

 

[crvasquez]

How are you retrieving the data? Are you using a DataSet or a DataReader? Need to see more of the code to try to solve.

Here is a small example:

sql = "......"
dim ConnectionString as string = "......"
dim cn as New OracleConnection(ConnectionString)
dim cmd as New OracleCommand()

cmd.CommandText = sql
cmd.Connection = cn

Dim da as new OracleDataAdapter(cmd)
Dim ds as New DataSet()

da.Fill(ds);

GridView1.DataSource = ds
GridView1.DataBind()

 

[Me.Net]

i discovered that the problem is with the arabic language

when i am save data in oracle database it appears like ???????

i cant solve this issue???

 

[MattP]

When you create the database you need to specify the character set. I don't use Oracle much but http://www.adp-gmbh.ch/ora/misc/globalization.html should give you something to work with for choosing a character set.