Issues with non-ascii and special characters during import

[gsofficework]

Hi,

I am using Laravel Excel 3.1 in my application.

I have an issue when I import CSV that contains NON-ASCII values or special characters.

1. Below settings in config/excel.csv

'csv' => [
    ...
    ...
    ...
    'input_encoding'   => 'ISO-8859-1',
],

With the above settings, value changed during import:
- Actual values = Genç
- Changed value = Genç

---

2. Below settings in config/excel.csv

'csv' => [
    ...
    ...
    ...
    'input_encoding'   => 'UTF-8',
],

With the above settings, I get the blank value instead of the actual value = Mounir Oulla‹.

---

Please can you help me that import allows all ASCII and non-ASCII values with special characters?

[patrickbrouwers]

Try checking what the encoding of your file is file {yourfile}.csv

[gsofficework]

Thank you for your quick response.

I tried to check the encoding of the file using a bit of code, but I don't think it's a flexible solution as I applied below because It gives me false for a few of the files.

$fileContent = file_get_contents($file);
$encoding = mb_detect_encoding($fileContent, mb_detect_order(), true);

---

I believe, If I could detect encoding or change 'input_encoding' dynamically in Laravel Excel 3.1 version, it would solve my issue.

Please can you share a solution if you have one for the same?

Thanks