Re: Insert UNICODE data with ODBC

In article <8s2ud6$78d$1_at_nnrp1.deja.com>,   David Murphy <DavidMurphy_at_j-netdirect.com> wrote:
> Hi - we are trying to use SQLBindParameter to insert data into a
> regular CHAR column. The data is stored as WCHAR double byte.
>
> Using SQL Plus when we select the data back we get A B C instead of
> ABCDEF. The column is CHAR(12)
>
> We use C Type SQL_C_WCHAR and sql type SQL_UNICODE in the binding :-
>
> SQLBindParam Param Index:1 IOType:INPUT CType:-8 SQLType:-8
> ColSize:6 Scale:0 BufSize:12 StrLen:12
>
> The ODBC driver is 8.1.56 (the latest)
>
> Is there a setting required to tell Oracle that we want the CHAR to
> hold double byte UNICODE?

I'm assuming that this question is a subset of the other Unicode/ODBC thread we've been going on with recently, so I'll summarize.

• CHAR columns can hold either single- or multi-byte character data (ANSI or Unicode). A CHAR(12) column will hold 12 bytes of data.
• If you bind data as Unicode, it will be inserted into the database as Unicode
• I suspect you intend for ColSize to be 12 if your data is 6 2-byte characters.

Justin Cave
Oracle ODBC Development

Opinions expressed herein are my own and may not reflect those of Oracle Corporation.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Oct 12 2000 - 14:18:42 CDT