wrong characters returned from oracle

Hi,

I created an rdo connection to an oracle database to read out the tables and records.
Always worked fine. Now I used the same application to read in a similar database, only this one comes from Sweden.
The fields where just plain text is in, returns wrong charachters like a "?" while it should be "Ä ".
I read somewhere about OEMTOANSI, but cant find any details...

Global cn As New rdoConnection
cn.Connect = "uid=system;pwd=manager;" _
& "driver={Microsoft ODBC Driver for Oracle Version 1};connectstring=intralink;"
cn.CursorDriver = rdUseOdbc
cn.EstablishConnection rdDriverNoPrompt

Above is the way I make a connection right now, this way always works perfect, but it does mess up the characters.

Any ideas or help would be great...........

Although it could be a language issue in oracle, it's more likely a codepage problem on the computer displaying the language. I assume you're not using some obscure font that don't support sweedish.
I have the same problem with .no charsets æøå on an english codepage.
Try to ensure that the codepage is set correctly, or that you set it correctly if necessary.

Merlin, thanks for getting me into a new approach for my problem. However, I'm not there still, not in a long shot.

A program what comes with the database is seing the characters as they should be, in Swedish, as meant to be. With the idea,that it might be a codepage issue, I took another look and figured out that VB6 is mainly an ANSI compatible application while databases like Oracle itself is an UNICODE compatible application. The thing is, that strings read out from an UNICODE database with characters in the higher part as in ANSI will come back as questionmarks. I tried to get a hex output from the database to convert them myself but with the resultset i created ( with use of sql statements ) it already is messed up.

Any help would be much appreciated.....

Please anyone .....


Any help would be much appreciated....