Problem with Umlaut, mySQL PHP & UTF-8

Suite and Optimus Suite 5
#1

Hi,

I am wondering why I am experiencing troubles with Dataprocessor, although I have the mySQL tables in “utf8_general_ci” collation?

I want to store the values in the DB as “öäü” and not some weird version. I have no problems with phpMyAdmin, I can store values with Umlaut in the DB straight.

If I use GridConnect, values get displayed as ��� , so I changed line #104 of grid_connector.php to

now the values get displayed properly as “öäü” in the grid… though, I wonder whether I’ve done it right this way. I guess I did. Maybe someone can point me to where the “post values” get processed once a row is updated, as connector still stores in some URI encoded way, such as äöü in the DB.

PS: great product. looking forward to get my first application together

#2

GOT IT :slight_smile:

The SQL Statement

SHOW VARIABLES LIKE ‘collation%’;

showed me:
collation_connection utf8_unicode_ci
collation_database utf8_unicode_ci
collation_server latin1_swedish_ci

so MySQL server was still in latin1_swedish_ci mode.

I therefore changed the my.ini of mySQL, uncommented
collation_server=utf8_unicode_ci
and
character_set_server=utf8
restarted SQL server and now… é voila! works like a charm.