accent problem

Suite and Optimus Suite 5
#1

Good morning,

i would have a problem with grid connection to mysql database.

the problem is stupid but it not allows me to load data in the grid.

In my database i have some column set with text or varchar(250), everything is ok but if i wrote a word in my database with the accent for example “già”, the grid connector shows me a pop up windows and no data is loaded.

The problem is right with accent letters (àèìòù).

how can i solve the problem?

thank you very much

#2

Hi.
In your server side code include the following line:

mysql_query(“set names UTF8”);

it worked for me.

Hope it help.

Lux