How i can read results in Greek language in MySql 5.0?

If data in my database uses both latin and greek characters, can anyone tell me how i can enable Greek? Some short of command in query browser maybe?

[Join us @ facebook]

Hey dyereve,

You should give me a big credit for that, as it took me about 9 hours to find out how is done

Before any query that you do, you should execute this one :

Code:

SET NAMES 'greek';

Enjoy

[Join us @ facebook]

Excuse me, I didn't write it right.

You should execute it when you open a connection. Then it will work for all the queries that you'll do using this connection.

Thanks mate!!!

[Join us @ facebook]

you are welcome

[Guest]

[62.853]

Googlebot, Yahoo crawler, froz