Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Preparing unicode SQL statements in OCI

Preparing unicode SQL statements in OCI

From: Michael J. Skarpelos <mskarpelos_at_nquire.com>
Date: 15 Oct 2001 17:53:20 -0700
Message-ID: <abfca438.0110151653.158be90e@posting.google.com>


The OCI 8i (8.1.5) documentation shows how bind unicode input variables and define unicode output variables, but what if the SQL statement itself is in unicode (for example, to access unicode column names or table names, or to specify unicode character literals in the WHERE and HAVING clauses)? Is there a way to prepare such a unicode SQL statement? I would have expected a flag parameter to OCIStmtPrepare() indicating unicode SQL text, but unfortunately it doesn't seem to be that simple.

Michael Skarpelos Received on Mon Oct 15 2001 - 19:53:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US