Re: [cx-oracle-users] Antw: Bad conversion of a unicode value?

[Michael S. <ms...@co...>]

matilda matilda schrieb:
>>>> Michael Schlenker <ms...@co...> 28.11.2007 12:13 >>>
>> So i think cx_Oracle somehow mistakenly converts to database encoding =
somewhere in between.
>=20
> Hi Michael,
>=20
> I'm not sure if this is a problem of cx_Oracle. That's the reason I wro=
te this little
> Embedded C Program for that. On the C level I only get byte sequences a=
nyway. So, I'm
> sure that nothing but the Oracle client library is in between (hopefull=
y ;-)).
>=20
> I don't know if we have a change to verify this by using another access=
 method.

I tried to do a similar thing with the Tcl Oratcl package, but it failed =
in a similar
way (not the same way, it produced different garbage), so i don't know if=
 its OCI thats
just damn hard to get right, or if it is some environment setup thats bro=
ken.

Sure, only Oracle OCI in between but from my cursory reading of the OCI d=
ocs,
it seems you need to do at least some special handling for NCHAR values w=
hen binding,
but OCI docs are huge...

Not sure if cx_Oracle does them yet, hoped to escape this mess by using c=
x_Oracle
in the first place (to replace an ancient non unicode savy ProC/C++ based=
 Oracle connector,
which could only be converted to unicode with a complete rewrite).

It might all work fine for database encoding =3D utf-8, but for people st=
uck with older
codebases and databases that need slow migration of only some columns the=
 split brained
Non-Unicode Database Charset and Unicode National Charset are a must.

I hope i do not have to ditch cx_Oracle again and try to find happiness d=
own an ODBC or JDBC
route (where none is to be found).

Michael

--=20
Michael Schlenker
Software Engineer

CONTACT Software GmbH           Tel.:   +49 (421) 20153-80
Wiener Stra=DFe 1-3               Fax:    +49 (421) 20153-41
28359 Bremen
http://www.contact.de/          E-Mail: ms...@co...

Sitz der Gesellschaft: Bremen | Gesch=E4ftsf=FChrer: Karl Heinz Zachries
Eingetragen im Handelsregister des Amtsgerichts Bremen unter HRB 13215