• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

MySql Query Browser problem!

 
timothy smith
Greenhorn
Posts: 11
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 134
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 11
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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!
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic