On Monday 26 June 2006 11:40, Julien Cigar wrote:
> Hello,
>
> I'm busy to upgrade the backup machine :
> kernel: 2.4.27 -> 2.6.15
> bacula: 1.36.3 -> 1.38.9
> database: sqlite 2 -> postgresql 8.1.4 (with the database in unicode utf-8)
> locales: iso8859-15 -> utf-8
>
> Everything works fine, except that I get those messages when running a job
> :
>
> 26-Jun 11:25 phoenix-dir: canis-job.2006-06-26_11.21.41 Fatal error:
> sql_create.c:851 sql_create.c:851 insert INSERT INTO Filename (Name)
> VALUES ('R�gles_encod_exemples.doc') failed:
> ERROR: invalid byte sequence for encoding "UTF8": 0xe8676c
>
> 26-Jun 11:25 phoenix-dir: canis-job.2006-06-26_11.21.41 Fatal error:
> sql_create.c:853 Create db Filename record INSERT INTO Filename (Name)
> VALUES ('R�gles_encod_exemples.doc') failed. ERR=ERROR: invalid byte
> sequence for encoding "UTF8": 0xe8676c
>
> 26-Jun 11:25 phoenix-dir: canis-job.2006-06-26_11.21.41 Fatal error:
> catreq.c:367 Attribute create error. sql_create.c:853 Create db Filename
> record INSERT INTO Filename (Name) VALUES ('R�gles_encod_exemples.doc')
> failed. ERR=ERROR: invalid byte sequence for encoding "UTF8": 0xe8676c
These are quite fatal errors and need to be corrected ... as I am sure you are
aware.
>
> (...)
>
> Does bacula support UTF-8 ?
Yes, but there are problems with PostgreSQL. I assume that these problems are
due to the fact that users can create or have created non-UTF-8 filenames,
but I am not sure.
Please look at the top of the file create_postgresql_database as released for
version 1.38.10 (it may also be in 1.38.9). It will explain some of the
problems and possible solutions. Since you probably created the database
under 1.36.3, it probably did not have the encoding set to avoid these
problems. Please also check the datestyle as it also occassionally gives
problems if you have something different specified.
Note, Bacula consoles display/input characters correctly (WYSIWYG) *only* if
everything is UTF-8 (on *nix machines). Windows is a whole different story.
--
Best regards,
Kern
(">
/\
V_V
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Bacula-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-users
