Diacritic

[Dr_Anthony]

maybe your sql database was installed without UTF-8 support ? and that is why it is not storing the diacrits fmor the filename in the db ?

can you try to edit the db directly, using HeidiSQL, copy the filename from disk, and overwrite the value in the db, and see if the diacrits are saved?

if yes, then there is a programming problem / bug in RadioDJ, which Marius needs to be informed of.
if no, then google if there is a way to change the UTF-8 value in your database, or if you need to do a reinstall of the db, and then re-import all music, etc.

Thanks for suggestions. Just installed HeidiSQL and opened my DB. You mean UTF8 in the collumn Title? As you can see in the screen all the Varchar collumns are UTF8 (I think so...).

https://pasteboard.co/KhwAVJC.jpg

[stevewa]

looks good, now try to update the value inside Heidi using the diacritics....

[Dr_Anthony]

looks good, now try to update the value inside Heidi using the diacritics....

Can you please tell me how? 

[stevewa]

in Heidi dql, table "songs", go to top tab "data"
use filters to seachr for the file you want to rename in db
example: path like '%beastie%'
apply filter, it should show you a bunch of tracks which filename contains "beastie"  change to whatever you need

once you find the track to rename, dobule click column named "path"  ...  (3 dots) edit in popup editor click green checkmark when done editing

now that row will show red triangle to indicate value has edit state. click green checkmark in top toolback (post changes) to save .

then look at that data to see if it contains you diacrits which match the filename etc.

[Dr_Anthony]

in Heidi dql, table "songs", go to top tab "data"
use filters to seachr for the file you want to rename in db
example: path like '%beastie%'
apply filter, it should show you a bunch of tracks which filename contains "beastie"  change to whatever you need

once you find the track to rename, dobule click column named "path"  ...  (3 dots) edit in popup editor click green checkmark when done editing

now that row will show red triangle to indicate value has edit state. click green checkmark in top toolback (post changes) to save .

then look at that data to see if it contains you diacrits which match the filename etc.

It works. Thanks! Anyway if I want to play the repaired tracks, gotta anable them in the Track Manager. Plus if the track is played, RDJ doesnt remember the track image, so guess I will have to import it to the each track again... (but fortunatelly RDJ remembers all the CUE points of each repaired track...)

[Dr_Anthony]

It works. Thanks! Anyway if I want to play the repaired tracks, gotta anable them in the Track Manager. Plus if the track is played, RDJ doesnt remember the track image, so guess I will have to import it to the each track again... (but fortunatelly RDJ remembers all the CUE points of each repaired track...)

I did it. Repaired all the wrong names in DB. It took more than 3 hours, but it works now. Just found out these Czech diacritics do not work:

č, ě, ř, ů, ť, ď, ň,

And these two special characters:

Λ, ϟ (use it in Axwell Λ Ingrosso and ACϟDC)

[stevewa]

good.
please clarify...

do those Czech diacritics fail when manually entering them into the database using HeidiSQL? or when entering using RadioDJ?
or do they fail when they are in the database, and RadioDJ reads the track from the database, and RDJ says it can't find the track?

What is the value of the image in the database compared to the value on your hard drive? Edit it directly in the DB to see if RDJ finds it and displays it correctly.

[Dr_Anthony]

good.
please clarify...

do those Czech diacritics fail when manually entering them into the database using HeidiSQL? or when entering using RadioDJ?
or do they fail when they are in the database, and RadioDJ reads the track from the database, and RDJ says it can't find the track?

What is the value of the image in the database compared to the value on your hard drive? Edit it directly in the DB to see if RDJ finds it and displays it correctly.

Well, If I insert the track with Czech diacritis manually into RDJ DB, it works. But a month ago I had to uninstall RDJ and its DB (due to Windows Update). So after that I installed RDJ and restored DB and then 226 tracks with those Czech diacritics letters didn't work, so had to repair them with HeidiSQL (as you advised me).