AppGini Community Forums

Posted: **2016-12-26 16:20**

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

Posted: **2016-12-27 08:56**

It seems I have to add the following code "somewhere".

Code: Select all

mysql_query("SET NAMES 'utf8'");
mysql_query("SET CHARACTER SET 'utf8'");

Could someone please tell me where this "somewhere" might be ?

Posted: **2016-12-30 13:32**

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.

AppGini Community Forums

GREEK chars, UTF encoding, My

GREEK chars, UTF encoding, My

Re: GREEK chars, UTF encoding, My

Re: GREEK chars, UTF encoding, My