File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes MySql Query Browser problem! Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "MySql Query Browser problem!" Watch "MySql Query Browser problem!" New topic

MySql Query Browser problem!

timothy smith

Joined: Jun 07, 2007
Posts: 11
hello all! i am having a problem with mySql Query Browser and i dont know how to solve it..

i use query Browser to add data in my tables.The problem is that when i try to enter data in greek i get the message Data too long. That message appears even if a write a single letter (and the column is varchar(70)!).i have defined as charset greek in mySql Administrator.

does anyone have any ideas on how to fix this problem??

thanks in advance!
Chad Clites
Ranch Hand

Joined: Aug 16, 2005
Posts: 134
What I usually do is do a System.out.println of the data that I am trying to enter in into the database. I have made some really stupid mistakes where I thought I was entering an int, and I was accidentally trying to enter an entire string of unrelated data. Also, are you getting a truncation error? What is the exact error message?
timothy smith

Joined: Jun 07, 2007
Posts: 11
hello chad! it turned out that the problem was easy to solve..

all i had to do is change from the properties of the column the encoding to greek.

that's rather simple! thanks for the reply!
I agree. Here's the link:
subject: MySql Query Browser problem!
It's not a secret anymore!