Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

encoding problem us...
 
Notifications
Clear all

encoding problem using UTF-8

3 Posts
2 Users
0 Reactions
5,435 Views
(@yoyomc)
Posts: 8
Active Member
Topic starter
 
[#551]

Hi everybody,

I am currently using the Project'Or RIA RC version with Wampp (version 2.2), Apache (version 2.2.21) and PHP (version 5.3.10).

I have specified utf8-bin (but also tried with others characters format) in PhpMyAdmin but I always have the following problem:

Using my browser, for example creating a new activity in Project'Or RIA interface, when I add a value like "é" in the name box, even if the value seems correct in the Project'Or RIA interface, the value is false in the name column (checking the database): "é".

It seems to be an issue due to the encoding parameter but I do not understand where is the problem as I have specified UTF-8 for the database format.

Moreover, If I try to manually insert a row in the table, using the PhpMyAdmin interface, the format is ok with the "é" value!

If I store in a file all the queries run in the database (including queries run by Project'Or Ria), I can see "é" values in the insert command.
It seems to be an issue with the queries created by Project'Or RIA.

Do you understand why I have this problem ?

Many thanks for your help 🙂


 
Posted : 12 Jun 2012 19H57
(@babynus)
Posts: 14952
Member Admin
 

Hi,

It is due to your MySql config.
in my.ini you must have

[mysql]
default-character-set=utf8

[mysqld]
character-set-server = utf8 

In most wamp installations, character-set-server is not set by default to utf8.


 
Posted : 12 Jun 2012 20H01
(@yoyomc)
Posts: 8
Active Member
Topic starter
 

Many thanks it works 🙂


 
Posted : 12 Jun 2012 20H14
Share:

Scroll to Top