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!
Joined: Aug 16, 2005
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?
Joined: Jun 07, 2007
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.