Since Plex won’t read embedded mp4 metadata, is it possible to have a script that would force Plex Server to copy whatever the given title of a movie is to the sort movie field? As it is, Plex skips English articles that begin a title. It does not skip articles in any other language so Das Boot is sorted as Das Boot in the D’s if you give it the German title and The Boot is sorted under B’s as just Boot if you give it the English title. This is illogical, inconsistent and annoying. So, is there a way to force the Sort fields to always mirror what they are sorting?
+1 same problem!
Anybody have a solution?
You could try to use a DB-Editor and copy the name-column to the sort-column.
Should work. It will be helpful doing it for big librarys for the first time. After that you can do it manually for new items.
Database is located at (Linux Debian):
/var/lib/plexmediaserver/Library/Application Support/Plex Media Server/Plug-in Support/Databases/com.plexapp.plugins.library.db
And the tables you have to edit are metadata-items or media_items
(I’m not sure which one was correct.)
Just take a look, you’ll see the right one!
Best wishes:
Jonas
Edit 1:
Using a script doing exactly what I said above could handle it. Maybe in a cronjob or whatever.
! Sorry for bad english: I’m a german
Thank you, Jonas. I’ll play around with this & see if I can get working. & your English is perfectly coherent.
One note by the side. Only edit ONE of these tables!
And please make a backup first!
I did it a few month ago and it worked well (edited some dates …)
You have to shut down plex first and edit the database with plex or root-user.
Forthermore, later you have to fix the database maybe with “Optimize Database” in PMS.
PS: Thanks 
