none none - 2 years ago 110
SQL Question

UTF8 php-ajax-jquery issue?

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.

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.

Answer Source

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

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download