Reply To: Accented Characters

[GDufresneParticipant]

Sorry. Thanks for a so rapid answer.

Using:

jquery-1.8.2.min.js
jQWidgets ver. 2.5.5 – personal use

Server: localhost via TCP/IP
Server version: 5.1.48-community
Protocol version: 10

User: root@localhost
MySQL charset: UTF-8 Unicode (utf8)

Apache/2.2.15 (Win32) PHP/5.3.2
MySQL client version: mysqlnd 5.0.7-dev – 091210 – $Revision: 294543 $
PHP extension: mysql

On a PC with IE9
===============================================
Here is the SQL code to generate the table:
SET SQL_MODE=”NO_AUTO_VALUE_ON_ZERO”;

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

CREATE TABLE IF NOT EXISTS `ajax_example` (
`ae_name` varchar(50) NOT NULL,
`ae_age` int(11) NOT NULL,
`ae_sex` varchar(1) NOT NULL,
`ae_wpm` int(11) NOT NULL,
PRIMARY KEY (`ae_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `ajax_example` (`ae_name`, `ae_age`, `ae_sex`, `ae_wpm`) VALUES
(‘Regis Philbin’, 75, ‘m’, 44),
(‘Frank Furt’, 45, ‘m’, 87),
(‘Jill Hill’, 22, ‘f’, 72),
(‘Tracy Sax’, 27, ‘f’, 0),
(‘Amélie Barker’, 35, ‘f’, 90),
(‘Blake Black’, 54, ‘m’, 30),
(‘Jack Black’, 30, ‘m’, 20),
(‘Martina White’, 14, ‘f’, 114),
(‘Martin White’, 41, ‘m’, 32),
(‘Jason Biggs’, 23, ‘m’, 4),
(‘Colin Smith’, 21, ‘m’, 50),
(‘Joséphine Baker’, 45, ‘f’, 60),
(‘Léo Bélanger’, 21, ‘m’, 80);

==========================================

Here is the data.php file
$row[‘ae_name’],
‘ae_age’ => $row[‘ae_age’],
‘ae_sex’ => $row[‘ae_sex’],
‘ae_wpm’ => $row[‘ae_wpm’],
);
}

echo json_encode($applicants);
?>

=============================================
and the index.php file

$(document).ready(function () {
// prepare the data
var source ={
datatype: “json”,
datafields: [{ name: ‘ae_name’ },{ name: ‘ae_age’ },{ name: ‘ae_sex’ },{ name: ‘ae_wpm’ }],
url: ‘data.php’
};
$(“#jqxgrid”).jqxGrid({
source: source,
theme: ‘classic’,
columns: [{ text: ‘Name’, datafield: ‘ae_name’, width: 100 },{ text: ‘Age’, datafield: ‘ae_age’, width: 100 },{ text: ‘Sex’, datafield: ‘ae_sex’, width: 50 },{ text: ‘WordsPerMinute’, datafield: ‘ae_wpm’, width: 160 }]
});
});

=======================================

Hope this helps.

Many thanks

Georges
Hope this helps.