Re: ODBC and Unicode

In article <MPG.200d775ab7521379896d6_at_news.free.fr>, migeon.alain_at_tdcspace.dk says...
>
> The query is still in UTF-8 at the time I call the SQLExecDirect
> function. So something is happening after, maybe in the ODBC layer. But
> I need to investigate.

In fact, I look in the Oracle ODBC driver help. There is an Unicode programming example.

To resume the steps :

• in the query, replace strings that contains Unicode characters by the interrogation point.
• call SQLPrepare with this query
• for each string replaced by ?, call SQLBindParameters
• call SQLExecute

then continue with normal process, like SQLFetch if the query is a select.

I don't know if there are any other ways, but this one works fine for me.

By the way, I tried to copy / paste some Unicode characters in SQL*Plus, and there were all replaced by ?. That let me think that it is not allowed at that time to place directly any Unicode characters in a SQL query.

Alain

>
> _________________________________________________
> Alain Migeon
> Please reverse alain and migeon for replying.
>

-- 
_________________________________________________
Alain Migeon
Please reverse alain and migeon for replying.