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

OO crashes with MySQL table containing special chars

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





PostPosted: Fri May 07, 2004 2:36 am    Post subject: OO crashes with MySQL table containing special chars Reply with quote

I have connected a MySQL database to OO under Fedora 1.0 Linux. Everything works fine as long as there are no special characters like "" in the table. I have played to no avail with the Character Set in the MySQL tab in the Data Source Administration.
The special character table is displayed without problems in the standard Linux MySQL client. It is also displayed in OO under Mandrake 8.2 Linux.

Thanks for any suggestions
Back to top
nom
OOo Enthusiast
OOo Enthusiast


Joined: 17 Dec 2003
Posts: 153
Location: NSW, Australia

PostPosted: Wed May 12, 2004 6:58 am    Post subject: Reply with quote

I have had similar problems with characters whose ASCII number is greater than 126.

So basically I had to get rid of them before inserting a record into a mySQL table.

I am not sure if it is the driver or mySQL that is the problem. (I was using JDBC)

Nom
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