bareos-dbcopy and encoding

[Wijnand van der Giessen]

I'm using bareos 19.2.7 on openSUSE leap 15.2 and have used the bareos-dbcopy command to convert my bareos mySQL database into postgresql.

The whole process went fine without any issues.

But when I did some checks inside of the pgSQL db I encountered the following error

select * from file;

ERROR:  invalid byte sequence for encoding "UTF8": 0xab ← same error as before

all the other tables do give me the expected result.

I presume this is from the fact that my bareos mySQL db is having a character set of UTF8mb4.

I'm not sure how to overcome above error as it seems there has not been a conversion from UTF8 on mySQL to the SQL_ASCII encoding that pgSQL is expected to use for bareos

I have done test backups and restores and they are working fine.

Can someone advice me what the best approach is before I actually move my bareos from mySQL to pgSQL.