MySQL Memo Fields Returned (D5e, BDE5.11, MySQL on Linux Server, MyODBC)

Robert MacLean

Delphi Developer

Tue, 20 Apr 2004 21:37:17 GMT

MySQL Memo Fields Returned (D5e, BDE5.11, MySQL on Linux Server, MyODBC)

I'm using MyODBC via BDE5.11 to connection to a mysql database on a
linux server.
The table only has strings in it, but I keep getting memo fields
returned?
Any ideas how to get strings?
--

___________________________________________
Robert MacLean

M.H. Avegaar

Delphi Developer

Wed, 21 Apr 2004 03:37:31 GMT

Re:MySQL Memo Fields Returned (D5e, BDE5.11, MySQL on Linux Server, MyODBC)

The BDE interpretes all String fields longer than 255 characters as Memo.

ps. Have you considered skipping BDE and ODBC and use the MySQL driver
directly with TMySQL (http://www.productivity.org/projects/mysql/) ?

Quote

"Robert MacLean" <rob...@idws.com> wrote in message

news:3be2a2bb$0$221@proctor...

Quote

> Hi

> I'm using MyODBC via BDE5.11 to connection to a mysql database on a
> linux server.
> The table only has strings in it, but I keep getting memo fields
> returned?
> Any ideas how to get strings?
> --

> ___________________________________________
> Robert MacLean

Other Threads

1. dbExpress WILL NOT connect to a remote mysql (linux) server

2. TQuery,MyODBC, and MySQL.

3. MySQL, Delphi 4 and MyODBC

4. MySQL, MyODBC, Delphi: record locked and cursor errors ?

5. urgent myodbc/mysql question

6. [MySQL]myODBC vs MyOLEDB

7. Problem accessing MYSQL through ADO(MYODBC)

8. MySQL, Delphi 4 and MyODBC

9. Mysql Server in Linux with aplication runing in Windows

10. Cannot connect to MySQL Server in Linux?