Special Characters

Discontinued products Uncategorized discussions
#1

hi,

i would like to know how can i view rightly Special Characters in render_sql statment like � � etc…



Thank u

#2

dhtmlxConnector includes cell’s values into CDATA by default.

#3

Be sure that you are using the same encoding on server side and on client side pages.
Also, if you are using non-utf encoding , you can add the next line
$grid->set_encoding(“iso-8859-1”); //or any other necessary value

#4

I’m using the same encoding

header('Content-Type: text/html; charset=ISO-8859-1

and in server side

$employee_grid->set_encoding(“ISO-8859-1”);

what could be?

#5

Is it just throw an “incorrect XML” or renders data incorrectly?

#6

All works well…only words in grid that have for example à è etc. is shown like usual

#7

Is the same table shows correct data while accessing by phpMyAdmin or any other tool.
The description of the problem is very similar to the situation when DB itself changes the data because of incorrect collation.

#8

In phpmyadmin the names are diplayed correctly…

#9

If issue still occurs for you - please provide a sample of xml, which is generated by connectors ( you can send it directly to support@dhtmlx.com )

#10

This is part of my xml result:


−

602-1213
GUALDIERI
ANTONIO
2009-10-28 09:08:27
Entrata
2009-09-28 12:41:12
Uscita
1

−

607-1062
GALLINA
CRISTINA
2009-10-15 13:39:00

0000-00-00 00:00:00

1

−

601-1214
VERDICCHIO
JAN-CLAUDE
2009-10-15 13:33:00
Ingresso
0000-00-00 00:00:00

1

−

601-1130
SECCHI
ELISABETTA
2009-10-15 13:30:00
Entrata
0000-00-00 00:00:00
2
1

−

607-1104
<cell>DON�
RAFFAELLA
2009-10-15 13:28:00
Entrata
0000-00-00 00:00:00

1


#11

If you have used
$employee_grid->set_encoding(“ISO-8859-1”);
the xml must start from
<?xml version="1.0" encoding="ISO-8859-1" ?>
This line is not visible in above code snippet, is it just skipped or there was not such line in XML output ?

#12

There is no such line…the file starts with:

Il file XML specificato apparentemente non ha un foglio di stile associato. L’albero del documento è mostrato di seguito.
  ( means that yhe xml file doesn’t have an associated  stylesheet  )  
−

−

601-1004
SOLIANI
ALEARDO
Montebelluna

−

601-1010
POZZI
LUIGI
Montebelluna

−

601-1026
BORDIN
MIRELLA
Montebelluna


etc etc etc…