Rafael Rodrigues asked 11 years ago
Hi,
I'm having trouble reading portuguese characters from MySql.
I think this is the same behaviour as in thread "Trouble reading norvegian characters from MSSql server", but in MySql.
The text fields that have accented characters before using phpgrid, are not visible in the grid.
If I write accented characters in the grid, then I can read them, but they are wrong in the table (viewing with phpadmin).
Thank you.
Abu Ghufran answered 11 years ago
Grid uses utf8 encoding for special characters.
Please make sure your encoding of mysql table is same.
If it is different for e.g. isoxxxxx then, you need to change mysql connection encoding too.
You can do it by editing jqgrid_dist.php line
@mysql_query("SET NAMES 'utf8'");
Change utf8 to your db table encoding.
Rafael Rodrigues answered 11 years ago
The table encoding is utf8 (Colation is utf8_general_ci)
An example:
A text field with the word Amélia that was not inserted in phpgrid, doesn't show in the grid (the field is blank).
If I insert the same word Amélia in the grid everything seems correct but, when I view the table data in, for example, phpadmin, I see Amélia instead (?)
As I said, the behaviour is the same as in the thread about norvegian characters.
Rafael Rodrigues answered 11 years ago
Hi, Abu
It seems the problem is solved.
I'm using Mysqli and I remember reading that there was a problem with SET NAMES 'utf8' in this case.
But, as I purchased yesterday the grid, I thought the code was corrected, but it's not! Modifying the code, the problem was solved.
What should I do to have the last updated version?
Abu Ghufran answered 11 years ago
Hello Rafael,
You are right, the v1.5 in purchased email need an update.
Meanwhile, i am emaling you latest build at your email.
