[Mono-list] Help on read unicode data from Oracle

[vinhpt]

Hi All.
I have a ASP.NET application read Unicode data from Oracle Database and show
Unicode on the webpage. Please help me how to config (webbrowser, webserver
and database server) 

OS: Ubuntu 8.10
Mono: 2.6.1
Webserver: XSP2
Database: Oracle 10g (NLS_LANGUAGE=AMERICA_AMERICAN.UTF8 data store in
NVARCHAR2 field type)
Application: ASP.NET VB.NET 2.0

Code:
            Dim strConn as String
            strConn = "Data Source=" & txtDatabase.Text & ";User ID=" &
txtUser.Text & ";Password=" & txtPassword.Text & ";Unicode=True"
            Dim conn As OracleConnection
            conn = New OracleConnection(strConn)
            conn.Open()
            Dim cmd As OracleCommand
            cmd = conn.CreateCommand()
            cmd.CommandText = "SELECT * FROM AD_ORG"
            Dim read As OracleDataReader
            read = cmd.ExecuteReader()

            Dim dTable As DataTable
            dTable = New DataTable()
            dTable.Load(read)

            GridView1.AutoGenerateColumns = True
            GridView1.DataSource = dTable
            GridView1.DataBind()

Result:
VALUE        NAME          DESCRIPTION
CNDLT        DA L?T        DA L?T
NTHC         NH?N          NH?N TR?CH

All the unicode character be replaced by '?'.
If test on Window and IIS is ok.

Please help.

-- 
View this message in context: http://old.nabble.com/Help-on-read-unicode-data-from-Oracle-tp27394445p27394445.html
Sent from the Mono - General mailing list archive at Nabble.com.