Not able to insert few characters in mysql

Question

Am doing a CSV import in laravel, For a few languages, it is not possible to import. The error which I got was

Incorrect string value: '\xFCr M\xE4n...' for column 'product_name_german' at row 1

when i print the line it shows like below text (with a starting character "b") :

b"Laufschuhe für Männer Artikel 001"

Actual text which i give was

Laufschuhe f�r M�nner Artikel 001

The CSV file is utf-8 bom encoded type

Obligatory read: https://www.joelonsoftware.com/2003/10/08/the-absolute-minimum-every-software-developer-absolutely-positively-must-know-about-unicode-and-character-sets-no-excuses/ — Loek, Feb 28 '19 at 11:45
Possible duplicate of [UTF8 mysql encoded database, but not showing special characters in PHP](https://stackoverflow.com/questions/19281747/utf8-mysql-encoded-database-but-not-showing-special-characters-in-php) — MimoudiX, Feb 28 '19 at 12:01

score 1 · Answer 1 · answered Feb 28 '19 at 12:02

Firstly be sure you have this meta in html tag

<meta charset="UTF-8">

You can check also with this line in php, above you mysql extraction

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

If you store your special character in database as html code like this ' which is ' when you extract try to use this php function

htmlspecialchars_decode($your_text_from_db);

Hamza Dastgir · Answer 2 · 2019-02-28T12:18:27.727

0

I think u havent changed charset to utf8, try this : hope it helps #sayNoToWar

$statSQL= 'SET CHARACTER SET utf8'; 

mysqli_query($your_db,$sSQL) 
or die ('charset in DB didn\'t change');

edited Feb 28 '19 at 12:18

answered Feb 28 '19 at 11:58

Hamza Dastgir

2 Answers2