Start Building Professional
Web Apps Today


 
Categories Question details Back To List
Question  posted by Lee on Apr 29, 2009 07:11
open dhtmlx forum
Trademark Character

I am testing Grid using the grid samples 01_basic.html and 01_basic_connector.php in the dhtmlxConnector samples folder using MySQL database.

The trademark symbol ™ displays as a black diamond with question mark inside.

I have set column as rotxt and txttxt but same problem. When i look at data just using 01_basic_connector.php still no trademark symbol, but black diamond.

When i look at MySQL database with program like Navicat or phpMyAdmin the trademark symbol displays correct.

Should I change UTF encoding? But where and in what php file?

Thank you for any help.
Answer posted by Support on Apr 29, 2009 10:00
>>The trademark symbol ™ displays as a black diamond with question mark inside.
Most probably it is an encoding problem. By default connectors mark output as UTF encoded, but in which encoding special char stored in DB?

You can try to add the next line to server side connector code ( before render_table )

$grid->set_encoding("iso-8859-1");

It will change header of XML, and the way how the data rendered. 

To show all data correctly, all steps of data processing need to work in same encoding
  - encoding of data in DB
  - encoding in XML header ( above command ) 
  - encoding of HTML page in browser