GREEK chars, UTF encoding, My

Please report bugs and any annoyances here. Kindly include all possible details: steps to reproduce, expected result, actual result, screenshots, ... etc.
Post Reply
adjuster
Posts: 3
Joined: 2016-12-26 16:08

GREEK chars, UTF encoding, My

Post by adjuster » 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

adjuster
Posts: 3
Joined: 2016-12-26 16:08

Re: GREEK chars, UTF encoding, My

Post by adjuster » 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 ?

adjuster
Posts: 3
Joined: 2016-12-26 16:08

Re: GREEK chars, UTF encoding, My

Post by adjuster » 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 :D

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.

Post Reply