Hi,
I'm facing a problem which I really don't know if I should ask here or not. If no, please forgive me. 🙂
My projeqtor database uses charset "utf8_general_ci". When I look the data in the database (using PHPMyAdmin) or load the data from the database to Excel (using MySQL ODBC connector with utf8 charset), for instance, special characters are not properly shown.
For instance, the text "Estruturação de diretórios" is shown as "Estruturação de diretórios". The characters "ç", "ã" and "ó" (or even the char "é"), do not show properly in the database client or in my Excel import. Althought, they appear correctly in Projeqtor software.
Am I using an incorrect charset for projeqtor's database? If Yes, wich one should I use? If No, any hint on why the data is not shown correctly in excel?
Thanks in advance.
Regards.
It is due to MySql server configuration which is not fully UTF8 configured.
You should have in my.ini :
[mysql] default-character-set=utf8 [mysqld] character-set-server = utf8
If it's not, characters stores in database may not be fully UTF8 compliant.
To fix this, there is a new parameter in ProjeQtOr :
$enforceUTF8='1';
This is set to 1 for new installs in order to work correctly on with UTF8, but should not be used afterwards.
To haved it work correctly with an existing database, you should :
- export database in UTF8 format
- open exported file : you'll see it's not really full UTF8
- convert file into UTF8 (with notepad++ for instance)
- reimport data
- set $enforceUTF8='1'; in parameters.php file
This should fix issue.