topic Re: Messed up international characters on PDF transformation in Alfresco Archive

Messed up international characters on PDF transformation

sansancasd — Mon, 28 Aug 2006 23:12:58 GMT

Hey.I followed the Alfresco tutorial. On the rule that transforms PDFs to text files, The resultant text file had messed up characters. The original PDF file has Portuguese characters, with accents, cedillas, etc. Is there anything to fix this?I can name a space with Portuguese characters and they

Re: Messed up international characters on PDF transformation

kevinr — Tue, 29 Aug 2006 09:26:30 GMT

The transformations are performed using OpenOffice server - it is possible that it does not support the character transformations. You database will probably work best in UTF-8 format - but saying that, if you are able to create space names ok then it may not be that.

Thanks,

Kevin

Re: Messed up international characters on PDF transformation

sansancasd — Tue, 29 Aug 2006 14:13:56 GMT

Ah, i thought it wasn't open office, because on the tutorial, it says that even without OO, the PDF to text transformation will be available. But i'll investigate OO then.

BTW, is there a easy way to migrate the alfresco database from latin1_swedish_ci to UTF-8? Mysql noob here

Thanks for the reply Kevin.

Re: Messed up international characters on PDF transformation

kevinr — Tue, 29 Aug 2006 21:17:16 GMT

Ah you may well be correct - most of the transformations (certainly the interesting ones like Word->PDF) are performed by OpenOffice, but the one you mention may well be using PDFBox, an open source library we use for some PDF manipulation.

Thanks,

Kevin

Re: Messed up international characters on PDF transformation

sansancasd — Wed, 30 Aug 2006 13:54:30 GMT

Kevin, i changed OO language settings, and a new text file still showed messed up characters. So must be PDFbox indeed. Any ideas about how to fix it? Does PDFbox have any settings or something? The tomcat, java, jars world is a new world for me

Re: Messed up international characters on PDF transformation

kevinr — Tue, 05 Sep 2006 13:58:29 GMT

I'm not sure any settings can be changed on PDFBox - i'll take a look.

Cheers,

Kevin