Files with non ASCII characters do not get saved correctly

[juliusvdijk]

In my library there is a file "Major Lazer & DJ Snake - Lean On (feat. MØ) (Official Music Video).mp3" which is unplayable because the file path is stored as "Major Lazer & DJ Snake - Lean On (feat. M?) (Official Music Video).mp3".

I am able to store the Ø character in the song table which also fixes the playback issue.

This issue is happening with all non ASCII characters.

[phanan]

Hmm. What DBMS are you using? I have quite a few Chinese songs in my MySQL and it works fine：

[phanan]

And

[juliusvdijk]

I am using MySQL on Windows using XAMPP.

In the console I am able to view the correct path so for some reason it just does not want to save in the right encoding. I tried to convert the encoding with mb_convert_encoding but that did not work.

However the title field gets saved succesfully...
Title: Major Lazer (Feat. MØ & DJ Snake) - Lean On (Claes Lanng Tropical Mix)
Path: .......\Major Lazer - Lean On (feat. M? & DJ Snake).mp3

[phanan]

I don't have a Windows box here, so... can you dd($file->getPathname()) here and see if it's a PHP problem?

[juliusvdijk]

I've added this code:

        if ($syncCommand) {
            $syncCommand->info($file->getPathname());
        }

I ran php artisan koel:sync --verbose and got this output.

.........\\Major Lazer - Lean On (feat. MØ & DJ Snake).mp3
Major Lazer - Lean On (feat. MØ & DJ Snake).mp3 has no changes – ignoring

In the database it is stored as:

.........\\Major Lazer - Lean On (feat. M? & DJ Snake).mp3
Major Lazer (Feat. MØ & DJ Snake) - Lean On (Claes Lanng Tropical Mix)

[phanan]

Just to double-check, what encoding is there for the field/table/db?

[juliusvdijk]

The weirdest thing is that it saves the title from the ID3 tags correctly but not the path.

I overrode the updateOrCreate and the value of the path is still correct, I have no clue why that character gets converted to a ?.

[phanan]

I don't know honestly. Once you enter updateOrCreate(), it's the framework (Laravel) job. From what I know, there's no configuration that may affect this. Maybe open an issue here?

[juliusvdijk]

It seems to be an issue related to my PHP environment, I'll try running it in a virtual Linux environment to check if that fixes it.

[phanan]

👍 I'll go ahead and close this issue then. Feel free to open a new one if the problem persists for you.