php import utf-8 txt file to latin1 database

Question

I have an UTF-8 encoded txt file and I want to import it to latin1_general_ci table. Problem is that some characters display as ? in database and not as they supposed to.

I tried mb_convert_encoding($str, "ISO-8859-1", "UTF-8"); but that didn't do anything.

What am I doing wrong?

Answer 1

Latin1 doesn't include all Unicode characters. You can use iconv() with //TRANSLIT option to transliterate unknown characters to their closest latin1 equivalents:

iconv("UTF-8", "ISO-8859-1//TRANSLIT", $text)

Answer 2

I use utf8_decode, it works for me.