View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - projeqtor database charset - ProjeQtOr
 
 

projeqtor database charset

More
21 May 2015 23:45 #1 by francis2301
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.

Please Log in or Create an account to join the conversation.

More
22 May 2015 09:05 #2 by babynus
Replied by babynus on topic projeqtor database charset
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.

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.033 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.