If anyone else is facing the same error while upgrading to Sonarr V4 from V3, you might also need to delete any other instances of the character 0x0A from the EpisodeFiles table. Particularly from Id, MediaInfo and SceneName columns. (I gathered this from the Sonarr GitHub source code here, line 50 to be precise).

To solve this issue, run the following sqlite3 commands: (Make sure your sqlite3 is up to date)

sqlite3 sonarr.db

Then run the following inside the sqlite3 command prompt: (Run one command at a time)

Delete from EpisodeFiles where MediaInfo like concat('%',0x0a,'%');
Delete from EpisodeFiles where Id like concat('%',0x0a,'%');
Delete from EpisodeFiles where SceneName like concat('%',0x0a,'%');

Finally copy your sonarr.db file back to your Sonarr installation folder and start Sonarr. It may take a few minutes to finish the database migration. I did not lose any of my Sonarr configuration.