[GH-ISSUE #2] Files with non ASCII characters do not get saved correctly

kerem commented

2026-02-26 02:31:45 +03:00

Owner

Originally created by @juliusvdijk on GitHub (Dec 13, 2015).
Original GitHub issue: https://github.com/koel/koel/issues/2

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.

Originally created by @juliusvdijk on GitHub (Dec 13, 2015). Original GitHub issue: https://github.com/koel/koel/issues/2 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.

kerem referenced this issue

2026-02-26 02:31:45 +03:00

[GH-ISSUE #1] .env not created in installation process. #2

kerem closed this issue

2026-02-26 02:31:45 +03:00

kerem commented

2026-02-26 02:31:45 +03:00

Author

Owner

@phanan commented on GitHub (Dec 13, 2015):

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

@phanan commented on GitHub (Dec 13, 2015): Hmm. What DBMS are you using? I have quite a few Chinese songs in my MySQL and it works fine： ![image](https://cloud.githubusercontent.com/assets/8056274/11767282/6dece2e2-a1e3-11e5-8050-908d316034d4.png)

kerem commented

2026-02-26 02:31:45 +03:00

Author

Owner

@phanan commented on GitHub (Dec 13, 2015):

And

@phanan commented on GitHub (Dec 13, 2015): And ![image](https://cloud.githubusercontent.com/assets/8056274/11767319/92289a74-a1e4-11e5-9f46-99b71b5ec275.png)

kerem commented

2026-02-26 02:31:45 +03:00

Author

Owner

@juliusvdijk commented on GitHub (Dec 13, 2015):

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

@juliusvdijk commented on GitHub (Dec 13, 2015): 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

kerem commented

2026-02-26 02:31:45 +03:00

Author

Owner

@phanan commented on GitHub (Dec 13, 2015):

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

@phanan commented on GitHub (Dec 13, 2015): I don't have a Windows box here, so... can you `dd($file->getPathname())` [here](https://github.com/phanan/koel/blob/master/app/Services/Media.php#L122) and see if it's a PHP problem?

kerem commented

2026-02-26 02:31:45 +03:00

Author

Owner

@juliusvdijk commented on GitHub (Dec 13, 2015):

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)

@juliusvdijk commented on GitHub (Dec 13, 2015): 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) ```

kerem commented

2026-02-26 02:31:45 +03:00

Author

Owner

@phanan commented on GitHub (Dec 13, 2015):

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

@phanan commented on GitHub (Dec 13, 2015): Just to double-check, what encoding is there for the field/table/db?

kerem commented

2026-02-26 02:31:45 +03:00

Author

Owner

@juliusvdijk commented on GitHub (Dec 13, 2015):

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 ?.

@juliusvdijk commented on GitHub (Dec 13, 2015): ![DB collation](http://i.imgur.com/MIHSY0d.png) 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 ?.

kerem commented

2026-02-26 02:31:45 +03:00

Author

Owner

@phanan commented on GitHub (Dec 14, 2015):

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?

@phanan commented on GitHub (Dec 14, 2015): 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](https://github.com/laravel/framework/)?

kerem commented

2026-02-26 02:31:45 +03:00

Author

Owner

@juliusvdijk commented on GitHub (Dec 14, 2015):

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.

@juliusvdijk commented on GitHub (Dec 14, 2015): 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.

kerem commented

2026-02-26 02:31:45 +03:00

Author

Owner

@phanan commented on GitHub (Dec 14, 2015):

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

@phanan commented on GitHub (Dec 14, 2015): :+1: I'll go ahead and close this issue then. Feel free to open a new one if the problem persists for you.

kerem referenced this issue

2026-02-26 02:31:52 +03:00

[GH-ISSUE #39] Importing artists with a & in their name #30

kerem referenced this issue

2026-02-26 02:31:58 +03:00

[GH-ISSUE #89] Whoops, looks like something went wrong. #58

kerem referenced this issue

2026-02-26 02:32:43 +03:00

[GH-ISSUE #403] Discussion: Compilation Albums #290

kerem referenced this issue

2026-02-26 02:32:59 +03:00

[GH-ISSUE #521] Error with fresh install of v3.5.0 #369