Does dbexpoda40.dll support TWideMemoField?

StephenKuo · Post by **StephenKuo** » Tue 16 Jun 2009 11:34

I try to create field from NCLOB

dbexpoda40 create TMemoField and ftOraClob

dbxora.dll create TWideMemoField and ftWideMemo

TMemoField is not for unicode

Stephen Kuo

Plash · Post by **Plash** » Wed 17 Jun 2009 09:09

Add UseUnicode=True to the Params property of TSQLConnection.

In this case the TWideStringField and TWideMemoField will be used.

StephenKuo · Post by **StephenKuo** » Wed 17 Jun 2009 09:30

Thanks for reply
I tried, but only TWideStringField and TMemoField, no TWideMemoField
(TWidestringField works well)

Is there something I missed ?

Stephen Kuo

My development Env.

Delphi 2009 Update 3,4
Windows Vista 64 bit OS
Oracle 11.1.0.6.0 64bit
2 databases created
1: ZHT16MSWIN950, AL16UTF16
2: AL32UTF8, AL16UTF16 (design time connect to)

design time bds load
oci.dll 11.1.0.1 in c:\Oracle\product\11.1.0\client_1\BIN
there are another 2 oci.dll in my PC

c:\Oracle\product\11.1.0\db_1\BIN\oci.dll
c:\Oracle\product\10.2.0\client_1\BIN\oci.dll

dbxconnections.ini

[CONNECTIONNAME]
BlobSize=-1
DataBase=DBNAME
DriverName=DevartOracle
ErrorResourceFile=
LocaleCode=0000
Password=***
Oracle TransIsolation=ReadCommited
User_Name=***
UnicodeEnvironment=True
UseUnicode=True

Plash · Post by **Plash** » Thu 18 Jun 2009 10:52

I made a mistake. Currently UseUnicode only works for CLOBs in ODAC, not for our dbExpress driver.

In the next build of the driver we will add the ClobAsWideMemo extended option. TWideMemoField will be created if you set it to True.