Paperless NGX: Conversion between UTF8 and SQL_ASCII is not supported

Maybe it will help some of you, but I just had an error updating 2.8.0 on my bare metal Paperless NGX instance. When trying to migrate the changes, the following error occured: Conversion between UTF8 and SQL_ASCII is not supported In fact, my Postgres database was set to SQL_ASCII instead of UTF-8, so it helped to rebuild the database. Make sure to backup/snapshot everything in case something goes wrong, I managed to kill my instance while fiddling around with this ๐Ÿ˜„...

May 8, 2024