MySQL russian text error

Question

I have a problem with inserting proper data into my DB with php... I am trying insert some data with this code:

$query1 = "insert into `exercises`(`exercise_name`) values ('".$txtEName."');";
        $query2 = "insert into `exercises_type`(`type_name`) values ('".$txtEType."');";

        mysqli_query($connnect, $query1);   
        mysqli_query($connnect, $query2);

all data is russian text... all data is saving into the DB, but, in DB it looks like this

so what I am doing wrong?

What is the charset/collation of the columns? – Explosion Pills Sep 21 '13 at 15:15 — Explosion Pills, Sep 21 '13 at 15:15
@Explosion Pills it is - utf8_unicode_ci – vladimir Sep 21 '13 at 15:18 — vladimir, Sep 21 '13 at 15:18

score -1 · Answer 1 · answered Sep 21 '13 at 15:18

-1

You can check for correct charset/collation. As this may help you to insert correct data in you table. also you can use character encoding for values your are getting by $_POST.

This link may help you

answered Sep 21 '13 at 15:18

Rohit Choudhary

2,253
1
23
34

MySQL russian text error

1 Answers1