Mysql utf8 macedonian text

Question

I just tried to insert some macedonian text which i got from my translator via email (gmail in german if that matters) into my utf8_general_ci mysql database but I couldn't figure out how to do it correctly.

Original text: "Ве молиме внесете"

attempt: just copy and paste the text, result: "??? ?????? ???????"
attempt: use php's iconv("ISO-8859-5", "UTF-8", $macedoniantext) and then copy and paste it, result: "?ааЕ аМаОаЛаИаМаЕ аВаНаЕбаЕбаЕ"

Both didn't work at all. Whats the right way to do it?

P.S.: There must be some way to do it because there are already some macedonian texts in the database which are also displayed correctly on the website

what do you mean by it didn't work at all? what exactly happened — kfirba, Aug 09 '14 at 22:43
[utf-8 all the way through](http://stackoverflow.com/questions/279170/utf-8-all-the-way-through) — Mark Baker, Aug 09 '14 at 22:52
I got a php function which returns the translation from the database and it works on other places on the website thats why I don't want to change any charset or something.. the question is just how to insert the new translation correctly — Rico Ocepek, Aug 09 '14 at 22:55
When you say copy and paste, where do you paste? An app of your own or some other client? — Joni, Aug 11 '14 at 07:42

score 0 · Answer 1 · answered Mar 07 '20 at 02:53

0

Database should be UTF8 format. when output is using echo utf8_encode($text);

answered Mar 07 '20 at 02:53

Hero Oo

30
1
8

Mysql utf8 macedonian text

1 Answers1