MySQL - Ajax - Special characters

Post reply

❤Follow Topic(2)

0 favourites

From the Asset Store

$10 USD

50% off

A collection of various soldier character sprites for creating a 2D platformer or sidescroller game

pzUH

- tcarita
- - Joined 23 Jul, 2012
  - 9 topics • 23 posts
- 1
- 25 Jan, 2015
- Quote
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
Try Construct 3

Develop games in your browser. Powerful, performant & highly capable.
Try Now Construct 3 users don't see these ads
- Joannesalfa
- - Joined 8 May, 2011
  - 319 topics • 3,129 posts
- 1
- 26 Jan, 2015
- Quote
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
- tcarita
- - Joined 23 Jul, 2012
  - 9 topics • 23 posts
- 1
- 26 Jan, 2015
- Quote
Thank you Joannesalfa

Going to delete the database and start over, maybe it will make a diference.
- Joannesalfa
- - Joined 8 May, 2011
  - 319 topics • 3,129 posts
- 1
- 26 Jan, 2015
- Quote
Make sure to set collate utf8_unicode_ci if you want more correct characters