Special character: UTF8, Oracle, JDBC

[Former Member]

Hi,

we have a connection to a Oracle database using JDBC; the tables there are set to UTF8. Unfortunately, some special characters don't appear as they should.

In Crystal Reports 2008 (with all updates) I already set the "Preferred Viewing Locale" to "Danish", but I still have the wrong characters.

Where else could I look to troubleshoot this?

Thanks!

[former_member11696 · Accepted solution]

As a test try connecting using one of the other drivers, ODBC, OLE DB or Native Oracle drivers. If it works then look at the JDBC driver causing the problem.

Try using your JDBC driver out side of CR and see if it works also to confirm it will work.

Thank you

Don