I have problems with the upload encoding and also with the setup of MySQL encoding and I would like to find a user who is using Greek chars in order to clarify the following :
1. What character encoding shall I use at "Character Encoding" selection of AppGini Localization settings ?
2. "Don't enforce MySQL encoding" should be checked or not for Greek chars ?
3. on the MySQL side at PHPMyAdmin, what shall I use for Greek characters at the "Collation" ?
Many thanks
Christos
GREEK chars, UTF encoding, My
Re: GREEK chars, UTF encoding, My
It seems I have to add the following code "somewhere".
Could someone please tell me where this "somewhere" might be ?
Code: Select all
mysql_query("SET NAMES 'utf8'");
mysql_query("SET CHARACTER SET 'utf8'");
Re: GREEK chars, UTF encoding, My
my Appgini is version 5.60 rev.975
My problem is solved with the assistance of Ahmed and user pgkounelas with my many thanks.
Now, it works perfectly and I am very happy for this
1. AppGini Preferences
Default character encoding : Unicode UTF-8
Generate Doxygen documentation for hook files : ticked
2. AppGini Database Preferences
Character encoding : Unicode UTF-8
Don't enforce MySQL encoding : NOT ticked
3. phpMyAdmin settings
General Settings
Server connection collation : utf8mb4_unicode_ci
4. Server's charset.ini : default_charset = "utf-8"
located at /etc/php5/mods-available/charset.ini
after change run : service php5-fpm restart
5. If an external data base in sql or CSV or other should be imported in phpMyAdmin, it should have UTF-8 encoding before importing.
My problem is solved with the assistance of Ahmed and user pgkounelas with my many thanks.
Now, it works perfectly and I am very happy for this
1. AppGini Preferences
Default character encoding : Unicode UTF-8
Generate Doxygen documentation for hook files : ticked
2. AppGini Database Preferences
Character encoding : Unicode UTF-8
Don't enforce MySQL encoding : NOT ticked
3. phpMyAdmin settings
General Settings
Server connection collation : utf8mb4_unicode_ci
4. Server's charset.ini : default_charset = "utf-8"
located at /etc/php5/mods-available/charset.ini
after change run : service php5-fpm restart
5. If an external data base in sql or CSV or other should be imported in phpMyAdmin, it should have UTF-8 encoding before importing.