Special Character of CSV file like(Ñ) not loaded on grid

[zandroParticipant]

Hi, Can someone help me with my problem. I have a grid that loads data from a csv file. My grid successfully loaded the data from csv file but the problem is that it wasn’t able to display special characters like(Ñ) or (ñ). Instead of displaying the character it displays a black cube with a question mark inside. How can I get rid of this?

[DimitarParticipant]

Hello zandro,

The suggestion given in the following post may be helpful in this situation: http://www.jqwidgets.com/community/topic/encoding-utf8-grid-problem/#post-8084.

Best Regards,
Dimitar

jQWidgets team
http://www.jqwidgets.com/

[zandroParticipant]

Hi Dimitar,

I’m not binding the grid to php,Im binding the grid from a CSV File. I don’t have problem on displaying special character on grid when it came from php. But my situation now is that i need to use the grid as a data entry method and the data will come from a csv file not from a php or jason file. Heres my process.

1.) I created a csv file that contains the data that I need.(Done)

2.) I need to load the csv file on the grid. (here is the problem)

3.) after the data is loaded on the grid i will call all its content and send it trough ajax to save in the database.(done)

The problem is on no. 2. I can load the csv file on the grid but the grid does not recognize the special character on my csv file. like for example i have a data on the csv file that contains ñ or Ñ. instead of displaying the character it dispalys somethinglike this “<?><?>”.

I gues the problem when the binding of grid to csv. it does not recognize the Ñ characters. But I don’t know how to get rid of this.

Barely need your help guys.

Thanks in advance,
Zandro

[DimitarParticipant]

Hi Zandro,

Please make sure the CSV file’s encoding is UTF-8. You can change the encoding with Notepad++ (go to Encoding → Convert to UTF-8).

Best Regards,
Dimitar

jQWidgets team
http://www.jqwidgets.com/

[zandroParticipant]

Hi Dimitar,

Yuhooooo.. It works perfectly. Thanks so much for your help. I need to deploy this system two days from now, you saved my day. Thanks. 🙂

Regards,
Zandro

[zandroParticipant]

By the Way Just for additional information for those who may encounter the same problem, notepad++ may not always the solution. just like mine still even though i used notepad++ still at some point it’s not solving the problem. what i did was i used the default notepad on windows, re-save the csv file using the utf-8 encoding option then it works flawlessly. thanks.

-Zandro

[Author]

Posts