Ajax DataGrid Support Product Page

Not a problem

special french character doesn't show right

03 Jan 2012 12:53:12 Herve de Brabandère 7ok sprl posted:
Hello,
using dw cs4, adg 1.1.0, mysql 5.0.51a-log
special french characters appear like Dé .
you can see it here www.enchantant.be/liste-magasin.php 3rd record and others)
i'm using utf8 everywhere and don't have any problem using dynamic apps (with dmw google map www.enchantant.be/magasins.php).
if i test a page without adg, using recordset, a table and a repeated region everything is ok www.enchantant.be/otesttable.php
please help
Hervé

Replies

Replied 04 Jan 2012 09:41:16
04 Jan 2012 09:41:16 Teodor Kuduschiev replied:
Hello,

Actually there is no problem for Ajax Datagrid to display such characters. Can you please check what is your database table collation for the selected columns?
Replied 04 Jan 2012 12:21:31
04 Jan 2012 12:21:31 Herve de Brabandère 7ok sprl replied:
Hello,
you can find related mysql parameters here www.enchantant.be/db-param.html
i'm using phpmyadmin Version: 3.4.7.1 on a shared hosting server without accees to the root or shell.
www.enchantant.be is a life running site so i have to pay attention not to impact other pages.
i must admit i'm definitively not a mysql guru
regards
Replied 05 Jan 2012 09:49:21
05 Jan 2012 09:49:21 Teodor Kuduschiev replied:
You need to set your whole database table collation to utf8_genreal_ci
Replied 29 Jan 2012 10:57:15
29 Jan 2012 10:57:15 Herve de Brabandère 7ok sprl replied:
How can i achieve that? Can i do this at run time ?
Replied 14 Oct 2014 09:54:12
14 Oct 2014 09:54:12 Herve de Brabandère 7ok sprl replied:
mysql_set_charset('utf8',$septok_be);
has to be add after msql_pconnect statment

$septok_be = mysql_pconnect($hostname_septok_be, $username_septok_be, $password_septok_be) or trigger_error(mysql_error(),E_USER_ERROR);
mysql_set_charset('utf8',$septok_be);

Reply to this topic