I am a new developer with Flash-amfphp and i deal the following problem.
I have a DB (called "mycities") and in this there is one - only - table called "cityT"
The table has two columns
a)cityid
b)city
The collation and the charset both of the table and the DB are set to utf8 and utf8_general_ci, in order to be able to store and retrieve data in greek and english both.
Now i have stored two cities with english names and two in greek names.
But when i call my service (WoldCities.php - showcities)in the browser i get only the cities with english names.
Unfortunately the cities with greek names are presented with a couple of questionmarks(one ? for each character of the name).
For example the city "Αθήνα" is represented by "?????"
or the city "Θεσσαλονίκη" is represented by "???????????"
Could you please help me find a way in order to be able showing and retrieving greek names ?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
One correction to the above.
The greek cities are shown not with questionmarks (?)but with smth like chinese.
If i change the charset (in the showcities service) to 'iso-8859-7' or to 'windows-1253' then these cities are represented with questionmarks
Please help me
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hallo Friends,
I am a new developer with Flash-amfphp and i deal the following problem.
I have a DB (called "mycities") and in this there is one - only - table called "cityT"
The table has two columns
a)cityid
b)city
The collation and the charset both of the table and the DB are set to utf8 and utf8_general_ci, in order to be able to store and retrieve data in greek and english both.
Now i have stored two cities with english names and two in greek names.
But when i call my service (WoldCities.php - showcities)in the browser i get only the cities with english names.
Unfortunately the cities with greek names are presented with a couple of questionmarks(one ? for each character of the name).
For example the city "Αθήνα" is represented by "?????"
or the city "Θεσσαλονίκη" is represented by "???????????"
Could you please help me find a way in order to be able showing and retrieving greek names ?
One correction to the above.
The greek cities are shown not with questionmarks (?)but with smth like chinese.
If i change the charset (in the showcities service) to 'iso-8859-7' or to 'windows-1253' then these cities are represented with questionmarks
Please help me