Unanswered: problem in storing euro character "€".
I have written an OCI application in which I want to fire a query :
select * from xxx where name= '€';
the last character is the Euro character i.e. Alt+0128
The OCIStmtPrepare call takes a text (OraText) string as parameter
i.e. unsigned character.
However the problem is that I am not able to convert a wide character string to a text string containing the Euro character. I tried to do this using the NT library function wcstombs.
Is it possible to fire an SQL statement directly using a wide character string? Are there any other ways to do the same.