🚀 go-pugleaf

It is not a bug - ADO Express maps BLOB string field (and Memo is BLOB) to
ftMemo. It should not be ftWideString. ADO Express has no field type for
unicode BLOB text field. You will have no succes going to Jet 3.5 or any
other provider - all BLOB text fields will be ftMemo. You can try work with
Recordset object or with ftMemo as with ftBlob.

----------------------------------------------------------------
Regards,
Viatcheslav V. Vassiliev
http://www.oledbdirect.com
The fastest way to access MS SQL Server and MS Jet (MS Access) databases.

"sharon oknin" <sharon@benarit.com> �������/�������� � �������� ���������:
news:3dc7c7f8@newsgroups.borland.com...
> hi all ,
>
> Is there a bug in bcb5 ADO(ADOExpress) regarding reading from memo ?
> I've posted a message not long ago about a problem  reading and writing
> unicode
> text from memo field using ADO . It looks like the problem is in the
casting
> found in adodb.pas , memo field is ftMemo while it should be ftWideString
.
> (ftMemo casts into Ansi) can someone confirm this ?
>
> I'm using bcb5 with sp1 and the ADOExpress update(or upgrade ,whatever)
> mdac 2.6 , microsoft jet 4.x to access ms-access 2000 db .
>
> buy the way , I've asked borland and they say it's a bug in microsoft jet
> engine
> 4.x and i should return to jet version 3.5 (!!?)
>
> thanks ,
> sharon
>
>
>