Incorrect string value

That error would point me towards the utf8mb4_unicode_ci. When you import the CSV manually, are you setting the same character set?

You need to ensure the file you are importing is actually in UTF-8 format, and not ANSI for instance, as it will cause the error described.

@rin4ik The CSV itself is saved in UTF-8 format :) so that should be good on that part.

@ejdelmonico The row collition is set to utf8mb4_unicode_ci, so all I do manually is (in short)

insert into description values ("description here")

and that works perfectly, just not when doing it with Laravel :)

My query in Laravel:

$query = Products::where('sku_id', '=', $items['sku_id'])->update([
                                   'fk_id' => $items['fk_id'],
                                   'status' => $items['status'],
                                   'brand' => $brandid,
                                   'article_number' => $items['article_number'],
                                   'color' => $items['color'],
                                   'size' => $items['size'],
                                   'article_name' => $items['article_name'],
                                   'description' => preg_replace("/[^a-zA-Z0-9%\/\s]/", "", $items['description']),
                                   'material' => preg_replace("/[^a-zA-Z0-9%\/\s]/", "", $items['material']),
                                   'category' => $items['category'],
                                   'washing_instructions' => preg_replace("/[^a-zA-Z0-9%\/\s]/", "", $items['washing_instructions']),
                                   'color_id' => $items['color_id'],
                                   'photo_1' => $items['photo_1'],
                                   'photo_2' => $items['photo_2'],
                                   'photo_3' => $items['photo_3'],
                                   'photo_4' => $items['photo_4'],
                                   'photo_5' => $items['photo_5'],
                                   'photo_main' => $items['photo_main'],
                                   'weight' => $items['weight'],
                                   'price' => $items['price'] * 1,
                                ]);

That error is usually because unicode processing so that is why I mentioned about you must have database charset set to utf8mb4 and collation to utf8mb4_unicode_ci in both cases. Mysql version should be current.

Ah good point @ejdelmonico , can you tell me how I can do that? all I know is that I set my table on utf8mb4_unicode_ci and that in database.php my charset is utf7mb4 and collation utf8mb4_unicode_ci :)

I just tried turning "strict" off (setting it to false). Maybe this will provide a solution as well :) Will let you know the outcome!

https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-conversion.html

basically, run this SQL statement:

ALTER DATABASE
    database_name
    CHARACTER SET = utf8mb4
    COLLATE = utf8mb4_unicode_ci;

OR

ALTER TABLE
    table_name
    CONVERT TO CHARACTER SET utf8mb4
    COLLATE utf8mb4_unicode_ci;

OR

ALTER TABLE
    table_name
    CHANGE column_name column_name
    VARCHAR(191)
    CHARACTER SET utf8mb4
    COLLATE utf8mb4_unicode_ci;

'strict' => false

in my database.php fixed the issue as well. Honestly, probably not the best way to solve an issue like this but it worked lol.

@ejdelmonico thanks for the SQL command, Ill try running it later tonight and see if I can turn the strict method back on :)

I had the same problem.

Error:

General error: 1366 Incorrect string value: '\xE9phane' for column 'name' at row 1 (SQL: update `users` set `edu_id` = [email protected], `name` = Stéphane, `surname` = Dubois,
...

Code that produces the error:

$user = User::updateOrCreate(
    ['id' => env('mail')],
    [
        'edu_id' => env('uniqueID'),
        'name' => env('givenName'),
        'surname' => env('surname'),
        'id' => env('mail'),
    ]
);

Error appends when a user with accents in its name (Stéphane) tries to log in.

I suspected a problem with inputs : env('givenName')

Code that corrected the problem:

$user = User::updateOrCreate(
    ['id' => env('mail')],
    [
        'edu_id' => utf8_encode(env('uniqueID')),
        'name' => utf8_encode(env('givenName')),
        'surname' => utf8_encode(env('surname')),
        'id' => utf8_encode(env('mail')),
    ]
);