Invalid JSON response when table contains non-English characters

bsuk

Hi,

I'm hoping this might be a quick and easy one, but when I add a value into my DB (outside of Editor) using non-English characters, I get an invalid JSON response when loading the table.. _ (DataTables warning: table id=Language - Invalid JSON response. For more information about this error, please see http://datatables.net/tn/1)_

For example, when my SQL table values contain the word "Authentication", the table loads without problems, but when I change this value to "Autenticação" (Brazilian Portuguese translation) directly in the DB, I get the error.

However, If I put the value in using Editor, everything seems to work, though the raw SQL then displays: "Autenticação".

Is there some sort of UTF-8 setting I can change?
I'm not using "server side processing", but rather whichever the client side (with AJAX for SQL access) settings Editor uses as default.

Many thanks.

BSUK.

bsuk

Doh, sorry, after more searching I found the answer in another forum post:

"dsn" => "charset=utf8" in the config.php file.

allan

Hi,

Thanks for posting back. Good to hear you've got it working now!

Allan