ADO and Memo field
Delphi
1
Posts
1
Posters
3
Views
1
Watching
-
I have an application which connects to a MS Access DB through ADO. One of the fields in a table is a Memo field. I have this field editable in my application through a TDBMemo, and a grid. The field has been removed and replaced a couple of times during development, but now whenever I view it in my app, it appears to think it is Unicaode, as I get lots of '?????' as the data. If I edit the field in the application, in the database any entries become 2 byte characters eg entering 'Test' becomes 'T e s t '. I have set the BlobType to ftMemo instead of the default ftWideMemo. Any ideas where to go next? I am not entirely familiar with using ADO in Delphi.