Datatables editor and special chars (ñ.`´,ç)

noslan

My wordpress form stores data from a form to the database, here, every rhing works fine, special characters are stored correctly, but when I make the query with datatables, all words containing any special words appear as "null".



PD: Here you have and example:

In database I have a Column called "Surnames" if a user's surname is for example "García", inside database I see it correctly but using datatables I see: Surname":null,

PD2: database: utf8_general_ci, column I've tested with utf8_general_ci and utf8_spanish_ci with same results

PD3: In reverse direction, typing any special char from datatables editor, I'm seeing "strange" chars on database, but correctly in datatables, for example: with Ç I'm seeing Ç in datatables but "\u00E7" in database (C/C++/Java source code)
Any sugestion? Where or how or what should I modificate?

Thanks in advance

allan

It sounds like a character encoding issue to me. We'd need a link to the page in question I think.

Before proceeding with that though, I see your trial license has expired. How have you been getting on with Editor other than this issue?

Allan

noslan

I'm still trying it, using your examples here and inside downloaded zip as base for my needs nothing else, what you mean?

noslan

I'm planning to buy it 'cos I really need it, but this issue with codification blocks me :(

allan

\u00E7 is Ç, its just a different form of displaying the same information. My guess is that your database display software just isn't decoding the UTF unicode points as HTML does for display. Nothing wrong with that - just something to be aware of!

Regarding the first point - I think we'd need a link to a test case showing the problem. Also, is your PHP database driver set up to talk to the database in UTF8?

Allan

noslan

The table is inside a wordpress databse which stores and shows Ç and Ñ and accents correctly, not sure what m I doing wrong:

The table where I store the thata is one created by me, data is stored inside this table via contact form 7, If I check the contect via phpmyadmin everything is correct, but if I check data thought "ajaxUrl" or via datatables is not.

If I store data via datatables I can see the data correctly via datatables, but if I check this data inside phpmyadmin or any other way I see "strenge" chars