I am having problems with ISO-latin-1 characters in filenames on Linux
using a PostgreSQL Bacula catalog (Fedora Core 4 using PostgreSQL
version 8.0.3 and bacula-postgresql-1.36.3).
It looks like PostgreSQL is expecting its client (i.e. the Bacula
Director) to be talking UNICODE, whereas the Director is just talking
raw 8-bit characters (i.e. ISO-Latin-1). Thus I am seeing error
messages like:
05-Sep 21:43 fm-dir: BackupDaedalus.2005-09-05_18.34.09 Fatal error:
sql_create.c:658 sql_create.c:658 query SELECT FilenameId FROM Filename WHERE
Name='chloë-holt' failed:
ERROR: invalid byte sequence for encoding "UNICODE": 0xeb2d68
and
05-Sep 22:18 fm-dir: sql_create.c:658 SELECT FilenameId FROM Filename WHERE
Name='Ðxx'
05-Sep 22:18 fm-dir: BackupDaedalus.2005-09-05_18.34.09 Fatal error:
sql_create.c:683 sql_create.c:683 insert INSERT INTO Filename (Name) VALUES
('Ðxx') failed:
ERROR: invalid byte sequence for encoding "UNICODE": 0xd078
I have seen this before and for my interactive psql access I have a
$HOME/.psqlrc with:
set client_encoding = 'ISO-latin-1';
However setting this in /root/.psqlrc didn't seem to make any difference.
Anyone seen this and got a work-around?
Andrew
--
Andrew Ford, Director Pauntley Prints / Ford & Mason Ltd
[EMAIL PROTECTED] South Wing Compton House
pauntley-prints.co.uk Compton Green, Redmarley Tel: +44 1531 829900
ford-mason.co.uk Gloucester GL19 3JB Fax: +44 1531 829901
refcards.com cronolog.org Great Britain Mobile: +44 7785 258278
-------------------------------------------------------
SF.Net email is Sponsored by the Better Software Conference & EXPO
September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices
Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA
Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf
_______________________________________________
Bacula-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-users
