OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

working with text > 1000 chars via odbc and mysql

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
franky
Newbie
Newbie


Joined: 31 May 2010
Posts: 1

PostPosted: Mon May 31, 2010 12:34 pm    Post subject: working with text > 1000 chars via odbc and mysql Reply with quote

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
Back to top
View user's profile Send private message
cilt
Power User
Power User


Joined: 20 May 2010
Posts: 89

PostPosted: Tue Jun 01, 2010 7:58 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
SnowmanDK
General User
General User


Joined: 13 Apr 2010
Posts: 10
Location: Denmark

PostPosted: Tue Jun 08, 2010 12:06 am    Post subject: Reply with quote

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 Smile
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group