MySQL - Ajax - Special characters

Get help using Construct 2

Post » Sun Jan 25, 2015 11:37 pm

Hi Guys
Maybe someone can help me

I'm retrieving some data from a MySQL server but the Ajax data loses the accentuated characters, the php queries returns everything nice (on the browser) but the ajax only gets question marks.

The sql fields are in UTF8, is there a way to format the text in the PHP or in Construct so i can have the special characters?

Thank you
Tiago
B
20
S
2
Posts: 22
Reputation: 1,889

Post » Mon Jan 26, 2015 12:30 am

C2 already supports UTF-8

I'm pretty sure your server has something wrong, make sure to double check, if not, then use php function to convert from ANSI or something else to UTF-8
B
97
S
35
G
29
Posts: 3,139
Reputation: 28,371

Post » Mon Jan 26, 2015 8:30 am

Thank you Joannesalfa
Going to delete the database and start over, maybe it will make a diference.
B
20
S
2
Posts: 22
Reputation: 1,889

Post » Mon Jan 26, 2015 11:30 pm

Make sure to set collate utf8_unicode_ci if you want more correct characters
B
97
S
35
G
29
Posts: 3,139
Reputation: 28,371


Return to How do I....?

Who is online

Users browsing this forum: No registered users and 5 guests