Start Building Professional
Web Apps Today

Special Characters

hi,
i would like to know how can i view rightly Special Characters in render_sql statment like à è etc..

Thank u

dhtmlxConnector includes cell's values into CDATA by default. 

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

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?

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

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

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.

In phpmyadmin the names are diplayed correctly...

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 )

This is part of my xml result:

<rows total_count="2076">
−
<row id="1">
<cell style="font-weight:bold;">602-1213</cell>
<cell>GUALDIERI</cell>
<cell>ANTONIO</cell>
<cell>2009-10-28 09:08:27</cell>
<cell>Entrata</cell>
<cell>2009-09-28 12:41:12</cell>
<cell>Uscita</cell>
<cell>1</cell>
</row>
−
<row id="2307">
<cell style="font-weight:bold;">607-1062</cell>
<cell>GALLINA</cell>
<cell>CRISTINA</cell>
<cell>2009-10-15 13:39:00</cell>
<cell></cell>
<cell>0000-00-00 00:00:00</cell>
<cell></cell>
<cell>1</cell>
</row>
−
<row id="2305">
<cell style="font-weight:bold;">601-1214</cell>
<cell>VERDICCHIO</cell>
<cell>JAN-CLAUDE</cell>
<cell>2009-10-15 13:33:00</cell>
<cell>Ingresso</cell>
<cell>0000-00-00 00:00:00</cell>
<cell></cell>
<cell>1</cell>
</row>
−
<row id="2304">
<cell style="font-weight:bold;">601-1130</cell>
<cell>SECCHI</cell>
<cell>ELISABETTA</cell>
<cell>2009-10-15 13:30:00</cell>
<cell>Entrata</cell>
<cell>0000-00-00 00:00:00</cell>
<cell>2</cell>
<cell>1</cell>
</row>
−
<row id="2303">
<cell style="font-weight:bold;">607-1104</cell>
<cell>DON�</cell>
<cell>RAFFAELLA</cell>
<cell>2009-10-15 13:28:00</cell>
<cell>Entrata</cell>
<cell>0000-00-00 00:00:00</cell>
<cell></cell>
<cell>1</cell>
</row>
</rows>

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 ?

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  )  
−
<rows total_count="151">
−
<row id="2">
<cell style="font-weight:bold;">601-1004</cell>
<cell>SOLIANI</cell>
<cell>ALEARDO</cell>
<cell>Montebelluna</cell>
</row>
−
<row id="6">
<cell style="font-weight:bold;">601-1010</cell>
<cell>POZZI</cell>
<cell>LUIGI</cell>
<cell>Montebelluna</cell>
</row>
−
<row id="31">
<cell style="font-weight:bold;">601-1026</cell>
<cell>BORDIN</cell>
<cell>MIRELLA</cell>
<cell>Montebelluna</cell>
</row>

etc etc etc....