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

vinhpt vinhpt2 at yahoo.com
Sun Jan 31 12:12:04 EST 2010

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

            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)
            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()

            GridView1.AutoGenerateColumns = True
            GridView1.DataSource = dTable

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.

More information about the Mono-list mailing list