abstract:

In the browser when the data are fetched they seem fine(pure greek), in query browser or commnand line thay seem in the above funny way.
What can i do about it?

Originally Posted by pabloj
i think you need to set the client charset also (see the manual for command line options, they can also be specified with an ini file)
NOTE THAT YOU POSTED IN THE WRONG FORUM, there is a specific one for MySQL

Originally Posted by blockcipher
Before we go too far...
1. What version of MySQL are you using?
2. What character set are you currently using?

abstract:

In the browser when the data are fetched they seem fine(pure greek), in query browser or commnand line thay seem in the above funny way.
What can i do about it?

Originally Posted by blockcipher
O.K.  First off, it's not the English Charset, it's Latin1 (Not to be nit-picky).  AFAIK, it covers most languages used in western europe (English, Dutch, Spanish, French, etc.)  I'm not sure if it can handle Greek.  The easy solution would be to switch to using Unicode, like UTF-8.  You can also use a different more specific character set, like Latin2.  I prefer to use UTF-8 just because if I add another language, I don't have to muck around with character sets.  Read the MySQL manual for info on setting up the character sets because you can set it at several different levels and you want to ensure that the character set of your connection is UTF-8 or whatever you're using.