Devart Forums

I am using ODAC 5.5 for delphi 7. My application needs to display some chinese character so I need to make it support unicode. I have set the OraSession's UseUnicode property to true. The field in the OraQuery is TWideStringField. But when I get the data from the database, the return value is still "?". My database's character set is unicode. Are there anything else I need to set? Thanks for anyone's help.

Could anyone help me? I have tried to use the TNT component to display the unicode character. Most of the character can be displayed, but some words like "蒳" is displayed as a "?". I can type the "蒳" in the TNT editor, but when I load it from the DB, it is displayed as a "?"

Please specify type of the field in the database table and whether you use Net option to connect to database. Also specify full version of ODAC including build number (see Odac\About ODAC in Delphi menu).

The field type is VARCHAR2 in the DB (Oracle 9i) and is TWideStringField in the delphi 7. My ODAC version is 5.50.0.17. I have set the net option to true. I have no problem on the connection. I can successfully connect to the DB. I have set the UseUnicode option property of the TOraSession to true. I also try to set the Charset property to UTF8, but it still cannot display the character "蒳" correctly. If I type the "蒳" in the TntDbEdit control and post it back to the DB. The word is correctly write back to the DB. I can successfully display the word "蒳" from another web application that support unicode. But while I try to refresh the dataset in my delphi application, it gets a "?" instead of "蒳". Thanks for help.

This problem is fixed in new versions of ODAC. You should upgrade your ODAC to work with Unicode correctly.

How can I upgrade my ODAC?

You can download the latest build of ODAC using link you've recived upon registration.