jQuery Grid Plugin - jqGridForum

Topic RSS

jGrid and french accents

12/11/2009
07:03

phicarre

Member

Members

Forum Posts: 132

Member Since:
09/11/2009

Offline

I begin my HTML code like this:

...

...

...

I begin my PHP code like this:

<?php

header('content-type:text/html;charset=iso-8859-15');

...

while($row = mysql_fetch_array($result)) {
       $responce->rows[$i]['id']=$row['Id_Nom'];
       $responce->rows[$i]['cell']=array($row['Nom'],$row['Prenom'],$row['Sexe']);
       $i++;
   }

$row['Prenom'] is a string with accent (check by debug),

but $responce doesn't contain this string (null instead).

Any explanation ?

12/11/2009
11:06

tony

Sofia, Bulgaria

Moderator

Members

Moderators

Forum Posts: 7721

Member Since:
30/10/2007

Offline

Hello,

maybe you will need to use SET NAMES before the requesting data in mysql

Regards

Tony

For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.

12/11/2009
12:10

phicarre

Member

Members

Forum Posts: 132

Member Since:
09/11/2009

Offline

The solution was

mysql_query("set names 'utf8'"); before extracting data from mysql

I am definitively lost with these charsets Embarassed

Thank you Tony

All RSS

Forum Timezone: Europe/Sofia

Most Users Ever Online: 994

Currently Online:
44 Guest(s)