Apache OpenOffice (AOO) Bugzilla – Issue 26931
OOo Contact connection to Evolution is loosing accented characters
Last modified: 2017-05-20 10:45:02 UTC
I've created new data source in OOo, which is of contact type with evolution as source. Accented characters in evolution database don't survive - i.e. "á" is converted to "/303/241", "Ã" is converted to "/303/255". I would guess it has something to do with Evolution (1.4.5) storing information in UTF-8, but not sure.
hi, I can reproduce this. msc -> windly: the evolution-addressbook-export export the values correct, so I believe it's the OOo driver. Bye Marc
Cah you please attachment the exported file?
Created attachment 14143 [details] Output of: evolution-addressbook-export --format=csv --output=addresses.csv
I've attached some output where the characters appear as well. It looks like the main problem is that UTF-8 gets escaped during export, there are two character expected in name "á" and "ý".
I've used perl oneliner to unescape output and it works OK - output is an unicode text, import as such to OOo works OK. evolution-addressbook-export --format=csv | perl -pe 's/\\([0-7]{1,3})/chr oct "$1"/ge' Would it be possible to unescape automatically during import?
This was already mentioned in bug 20958 I believe that octal-escaping utf-8-encoded unicode is wrong, so I wrote a patch for evolution last October to not do that. At that time I was thinking that http://bugzilla.ximian.com/show_bug.cgi?id=49519 might be handled reasonably fast. Unfortunately it wasn't. At this point of the evolution 1.4 product lifetime (and as the db connection for evolution 1.5/2.0 is almost done AFAIK), it's probably better to add the unescaping code on the OOo side.
working transfer
targeting
Reset the assignee to the default "issues@openoffice.apache.org".