UTF8 php-ajax-jquery issue?

Question

I'm posting some text into my sql INSERT statements and once the text get's into the database it doesn't show as expected.

Example: This is what I get inside my database: laÅ¾ljivo. This is what I should get lažljivo (language:Croatian).

In my ajax-jquery I've put the following:

contentType: "application/x-www-form-urlencoded; charset=UTF-8"

In my .php file I've put the following:

header('Content-type: text/plain; charset=utf-8');

Keep in mind that when I insert the text directly into my db (via workbench or phpmyadmin) then the text is normal hence the problem appears to be when the text is transfered to the .php file. Apart from that, I don't get any error by the system.

@Mihai that worked, I spent 2 hours figuring what went wrong... You can post the answer if you wish to earn some more points. — EugenSunic
– EugenSunic, Commented May 5, 2016 at 12:49

Mihai · Accepted Answer · 2016-05-05 12:50:45Z

2

The header contentType is a different thing from mysql connection which also need to be set,you can even set it in your cnf file so it stays utf8

SET NAMES utf8

answered May 5, 2016 at 12:50

Mihai

26.8k8 gold badges71 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

EugenSunic Over a year ago

to achieve it: $conn->set_charset("utf8");

Collectives™ on Stack Overflow

UTF8 php-ajax-jquery issue?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related