I have created a MYSQL InnoDB table. The table contains some string fields in which international (e.t.c. Greek) as well as standard Latin characters are to be stored. I assume that when I write a Greek word in a field, the standard Greek code page gets used.
Unfortunately when I connect to the database via the command tool and display all records of the table, I see gibberish in place of the Greek characters. Is there any way to resolve this?
By the way! Can MySQL use Unicode to store strings?