DB Question: Path?

Get answers about the current version of MediaMonkey 5

Moderator: Gurus

crisssi
Posts: 6
Joined: Fri Apr 22, 2022 4:05 am

DB Question: Path?

Post by crisssi »

Hi, I am trying to understand the MM database, and there is one thing I don't get. In MM5 the path is shown like "C:\Users\Chris\...". But in the database table Songs, field SongPath, it looks like this: ":\Users\Chris\...", the "C" is missing. But somehow MM knows that it's "C", so where is this information stored?
Lowlander
Posts: 56465
Joined: Sat Sep 06, 2003 5:53 pm
Location: MediaMonkey 5

Re: DB Question: Path?

Post by Lowlander »

The drive is stored separately and MediaMonkey uses the driveID instead and should be in the Medias table.
crisssi
Posts: 6
Joined: Fri Apr 22, 2022 4:05 am

Re: DB Question: Path?

Post by crisssi »

Thank you! And DriveLetter in Medias is the ascii value of the drive letter minus 65. In my case 2 for C and 23 for X. I'd really like to know what's the idea behind that. Only to confuse the Russians I assume.
Peke
Posts: 17446
Joined: Tue Jun 10, 2003 7:21 pm
Location: Earth
Contact:

Re: DB Question: Path?

Post by Peke »

crisssi wrote: Thu May 12, 2022 12:46 pm Thank you! And DriveLetter in Medias is the ascii value of the drive letter minus 65. In my case 2 for C and 23 for X. I'd really like to know what's the idea behind that. Only to confuse the Russians I assume.
Reason is that ASCII value Printable Table and Uppercase letters start from 65 decimal, so 26 drive letters.
Best regards,
Peke
MediaMonkey Team lead QA/Tech Support guru
Admin of Free MediaMonkey addon Site HappyMonkeying
Image
Image
Image
How to attach PICTURE/SCREENSHOTS to forum posts
Post Reply