Special characters in the grid

Suite and Optimus Suite 5
#1

Hello,

I am testing your grid and I connected it to a mysql database that I am using and I have some special German characters in there for example “Köln” (in html “Köln”) but using the grid these characters are not shown properly. Instead some other weird characters show up.

How can I handle this?

Usually I don’t have problems to show the result of the database in a normal table or form - only using the grid.

спасибо,
R.

#2

In which encoding you are storing data in database?

As you have problems, most-possible it is iso-8859-1 ( grid uses utf-8 by default )
In connector’s code, before render_table|render_sql command, try to add

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

#3

Thank you. Yes, if I use utf-8 as encoding it works properly. So far I had been using latin-1 or something like this. I am accessing the mysql database also with OpenOfficeBase and this one cannot work with utf-8 properly - but fine. Now, in which file exactly do I need to put this

$grid->set_encoding(“iso-8859-1”);

in? I haven’t found anything like “render_table”.

Thank you,
R

#4

Thank you. Yes, if I use utf-8 as encoding it works properly. So far I had been using latin-1 or something like this. I am accessing the mysql database also with OpenOfficeBase and this one cannot work with utf-8 properly - but fine. Now, in which file exactly do I need to put this

$grid->set_encoding(“iso-8859-1”);

in? I haven’t found anything like

Thank you,
R

#5

I am testing your grid and I connected it to a mysql database

If you are using grid, you are loading data through some server side script.
If it based on connector (php, java), it must have some render command and before it you need to place the set_encoding command.

If you form xml by some custom script, you need to define its header

<?xml version="1.0" encoding="iso-8859-1" ?>

set the encoding value to the one which is necessary in your case.