Returning Unicode Characters
320111Feb 25 2004 — edited Mar 2 2004How can I get the following code to return both the (Unicode 2122 TRADE MARK SIGN) and the ® (Unicode 00AE REGISTERED SIGN) correctly with ODP.NET 9.2.0.401?
Dim oc As New OracleConnection("User Id=scott;Password=tiger;Data Source=oracle")
Dim da As New OracleDataAdapter("select '', '®' from dual ", oc)
Dim dt As New DataTable
da.Fill(dt)
MsgBox(dt.Rows(0).Item(0) & dt.Rows(0).Item(1))
The ® is returned fine, but the returns a ¿ (Unicode FFFD REPLACEMENT CHARACTER) as though it is unkown. This is true when I retrieve a VARCHAR2 column as well.
Is there a parameter that can be set to return characters outside of the ASCII range or is this some kind of a restriction? In VB6, OO4O handles this query correctly, but ODP seems to misinterpret it.