• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

MySql Query Browser problem!

 
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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!
 
Ranch Hand
Posts: 134
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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!
 
What are your superhero powers? Go ahead and try them on this tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic