Problem with polish letters [UTF-8]

Problem with polish letters [UTF-8]

sirksirk Posts: 2Questions: 0Answers: 0
edited February 2013 in General
Hello,

I'am starting with DataTables but I have big problem.
Cells containing polish letters (ó,ł,ż,ć etc.) does't display in my server-side installation. Row is ok, but cell with polish letter is empty.

Screen: http://scr.hu/0lfe/558d9

I have UTF-8 charset in MYSQL database/tables and in header.

What is wrong? What should I change?

Replies

  • tomaszstomaszs Posts: 3Questions: 0Answers: 0
    Any solutions?
  • allanallan Posts: 63,520Questions: 1Answers: 10,473 Site admin
    DataTables doesn't care about the character set - its going to be a problem with the database, the connection to the database, or the page. Will it display correctly if you draw them in plain HTML from your script?

    Allan
  • tomaszstomaszs Posts: 3Questions: 0Answers: 0
    No, they are saved badly to the database. But i have set utf-8 for database correctly. But normally when i save to database with my routines i need to do query SET NAMES utf8 before. How to do this in datatables.net?
  • allanallan Posts: 63,520Questions: 1Answers: 10,473 Site admin
    DataTables is a Javascript library. It does not directly interact with the database at all - if you need to set a database connection option, you need to do that in whatever script you are using to connect to the database. As I say, DataTables itself doesn't care about the character set.

    Allan
This discussion has been closed.