>>>>> On Mon, 19 Nov 2018 01:24:18 +0200, George Anchev via Bacula-users said: > > On Fri, 16 Nov 2018 12:50:12 +0200 George Anchev wrote: > > > https://www.bacula.org/9.2.x-manuals/en/main/Installing_Configuring_Post.html > > Can anyone please explain why SQL_ASCII is strongly > recommended? Won't that be a problem for unicode file > names?
The problem is that many commonly used filesystems do not have "unicode file names" -- they allow an arbitrary sequence of 8-bit bytes. Some programs interpret these bytes as UTF-8 encoded unicode (or something else) according to the locale, but Bacula passes them to the database as-is. If you specify something like UTF8 in PostgreSQL, it will signal an error if you back up a file whose name is not a valid sequence of bytes for UTF-8 (e.g. the single byte 0xA1). SQL_ASCII actually means "any sequence of 8-bit bytes" in PostgreSQL, so you will not get an error from any file names, which is probably what you want for a backup program. __Martin _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
