jQuery Grid Plugin - jqGridForum

Topic RSS

Jqgrid isn't showing special characters(spanish language)

26/02/2010
01:37

0le0

New Member

Members

Forum Posts: 1

Member Since:
23/02/2010

Offline

Hi to all!

After a lot of work i'm developing with jqgrid but there is a problem with my app.

I'm adding and deleting rows from my db but like my db uses spanish characters when i try to add words which have accent like "áéíóú" or "ñ" what i get in my db is this Ã¡Ã©ÃÃ³Ãº. If i insert some values with mysql browser like 'día' when i load my jqgrid i just have a 'd' and the rest of my string isn't loaded.

So i decided to try with firebug to see what was being send t othe server and i found this:

fecha=2010-02-03&motivo=V&descMotivo=%C3%A9l%C3%A9f%C3%A1nt%C3%A9&oper=add&id=_empty.

descMotivo variables should be éléfánté so i'm guessing i should use something like hrmlspecialchars() function or another php string function to handle that but can this be done?

01/03/2010
21:25

tony

Sofia, Bulgaria

Moderator

Members

Moderators

Forum Posts: 7721

Member Since:
30/10/2007

Offline

Hello,

Sorry, but this is not jqGrid problem and this issue is discussed many times here:

Short:

1. Your html page should have appropriate meta for your language.

2. When you insert/update/delete your connection should have the appropriate caharcter set - in mysql this is done with SET NAMES command before doing evrething.

3. Your database should be encoded in the appropriate way.

4. When you send the output to the grid you should set the appropriate headers.

Hope this helps

Regards

Tony

For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.

All RSS

Forum Timezone: Europe/Sofia

Most Users Ever Online: 994

Currently Online:
40 Guest(s)

Currently Browsing this Page:
1 Guest(s)