I work with MySQL/PHP/Apache many years.
I am Greek so, in many pages, I use Greek language.
the problem is this:
I have 2 group of programs with different interaction:
group 1: PHP, MySQL Command Center
group 2: MySQL Query Browser, MySQL Administrator
and I have 2 CREATE TABLE
for 1st CREATE TABLE (greek), group 2 works fine and group 1 display
greek characters like this "?"
for 2st CREATE TABLE (latin1), group 1 works fine and group 2 display
greek characters like this "|"
Until now, I worked with MySQL Command Center but now project is stopped.
So, I must fix this problem.
What's wrong?
----------1----------
CREATE TABLE `anniversaries` (
...........
`event` text NOT NULL,
) ENGINE=MyISAM DEFAULT CHARSET=greek
----------2----------
CREATE TABLE `anniversaries` (
...........
`event` text NOT NULL,
) ENGINE=MyISAM DEFAULT CHARSET=latin1
---------------------