working with text > 1000 chars via odbc and mysql

[franky]

Dear Forum,

I am working on mysql database using oo base as frontend via odbc driver. I access the database over the network.

The database contains bibliographic data, including article abstracts (plain text of up to 10.000 characters), which are stored as varChar in my database.
The problem is that I can't open a table execute a query in open office that includes this data. It causes base to crash if some abstracts have more than approx. 1100 characters in length.
I don't a problem accessing the data in the database directly (via phpMyAdmin) or when opening the tables by using the same odbc driver with MS Access.

I have no idea about the reason of this problem and how to solve it without involving other applications (which I do not prefer).

Has anyone encountered this problem before?
I'd really appreciate an answer.

Best regards, Frank

[cilt]

what version of oo do you have

there is an extension for oo3 that makes a direct connection to mysql
works great for me but i dont have huge fields

its called
MySQL Connector for OpenOffice.org

[SnowmanDK]

This is not a solution, but a little added info.

I use OOo 3.2.0 and when I get to about 1000+ characters in a MySQL DB then base crashes when saving the record.
After that, Base crashes every time I try to reopen the database.
When checking the MySQL DB directly, then it DID save the data.
If I then change the record to contain fewer characters (around 900) then Base works again. Until I save the next record, that is...

I tried using VarChar and other formats, but all of them crashes.

Error Reports have been sent