Erik, what database are you using? 

We use an Oracle database (see post).

s

ErikFiets said

We use an Oracle database (see post).

sorry, more specific, what version of oracle and what driver are you using? 

I cannot say anything specifically about the restriction you've found in the documentation. But (as far as I can see) it should be possible to use UTF-8 when calling an Oracle SSP. I've found the following BUG that has been resolved:

• BUG: 30003 - Oracle , SSP , Unicode datatypes: Problems for non Unicode database

You just have to make sure that you are using at least Uniface 9.5.01 + E114 (or higher) or Uniface 9.6.01 + X104 (or higher). If this does not help then it might be a good idea to log a call with support. Hope this helps. Kind regards, Daniel Iseli Uniface Support

Uniface version: 9.5.01.02 (E108 0719_1) Oracle client version: 11.2.0 @Diseli: Uniface crashes when the SSP is called so this is different from "BUG:30003" where the return value contains reversed question marks. Besides, the documentation tells me: “There is no support for multibyte language character sets.”

ErikFiets said Uniface version: 9.5.01.02 (E108 0719_1) Oracle client version: 11.2.0 @Diseli: Uniface crashes when the SSP is called so this is different from "BUG:30003" where the return value contains reversed question marks. Besides, the documentation tells me: “There is no support for multibyte language character sets.”

Thanks for the info. But it still might be a good idea to install (at least) the patch E114 (that includes a fix for 30003). It's at least worth a try. And it might be correct that that documentation states that there "is no support for multibyte language character sets". On the other hand: who says that the documentation is always correct? I did not really dig into this, but it might be possible that the mentioned info from the documentation is not up to date anymore. I know (from our Knowledge Base) that there's at least one customer that has been able to use UTF-8 with Oracle SSPs. In case you are still facing problems then please contact support. We then can also investigate (in more detail) if the documentation needs to be updated here (or not). Hope this helps. Kind regards, Daniel Iseli Uniface Support

Thanks for your help! You are right. It works with "Uniface 9.6.05 (X505)". So maybe the documentation can be updated? Anyway, we will start the migration somewhere in the near future. Hopefully all goes well ;-) Kind regards, Erik

Hi Erik, Thanks for letting know that you've got this working now. And I'll ask the lab if they could have another look at the documentation. Kind regards, Daniel