Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 297662 - app-office/mdbtools doesn't support utf-8
Summary: app-office/mdbtools doesn't support utf-8
Status: RESOLVED FIXED
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: New packages (show other bugs)
Hardware: AMD64 Linux
: High major (vote)
Assignee: Hans de Graaff
URL: http://sourceforge.net/tracker/index....
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-12-20 16:05 UTC by oc666
Modified: 2010-01-03 14:51 UTC (History)
0 users

See Also:
Package list:
Runtime testing required: ---


Attachments
Utf-8 patch for mdbtools (haveiconv_fix.patch,660 bytes, patch)
2009-12-28 18:24 UTC, oc666
Details | Diff

Note You need to log in before you can comment on or make changes to this bug.
Description oc666 2009-12-20 16:05:29 UTC
When using mbdtools with files that contain unicode (non-latin) letters, the output is questions mark (?). All the latin letter remain fine.

Reproducible: Always

Steps to Reproduce:
1. install app-office/mdbtools-0.6_pre2
2. run mdb-export -I your_file.mdb your_table > mdb.dump


Actual Results:  
mdb.dump contain question marks instead of non-latin symbols

Expected Results:  
need to support non-latin (unicode) letters and symbols.

maybe because mdb files contain ucs2 format (?)

patch included in the url.
Comment 1 oc666 2009-12-27 12:51:31 UTC
I just re-emerge the package and it's working fine with unicode data (Hebrew verified).
I've another problem - when some data contain two hyphens it return NULL value instead of the data. See also:
https://sourceforge.net/tracker/?func=detail&aid=1602076&group_id=2294&atid=102294
Comment 2 Hans de Graaff gentoo-dev Security 2009-12-27 16:13:43 UTC
(In reply to comment #1)
> I just re-emerge the package and it's working fine with unicode data (Hebrew
> verified).

So it is working now anyway? Or did you re-emerge with the patch mentioned in the URL applied?
Comment 3 oc666 2009-12-27 16:21:29 UTC
No. i did it one with the patch. Then I re-emerge it with the regular package from the portage and it still work fine.
But on other server it still show me question marks when I'm exporting. Don't know why.

BT"W, could the maintainer update the package to the current CVS?
Comment 4 Hans de Graaff gentoo-dev Security 2009-12-27 16:35:07 UTC
(In reply to comment #3)

> BT"W, could the maintainer update the package to the current CVS?

This is already the case, as far as I can tell. See the comment in /usr/portage/app-office/mdbtools/ChangeLog

Comment 5 oc666 2009-12-27 17:54:52 UTC
I don't get what the changelog try to "tell" me.
I've this bug now:
https://sourceforge.net/tracker/?func=detail&aid=1602076&group_id=2294&atid=102294
It doesn't happend on ubuntu package:
http://packages.ubuntu.com/search?keywords=mdbtools&searchon=names&suite=karmic&section=all

I really don't know why, but I consider to install deb package on Gentoo for that.
Comment 6 oc666 2009-12-27 18:10:31 UTC
Also, on fedora have the same CVS date as ubuntu package:
http://koji.fedoraproject.org/koji/buildinfo?buildID=119654
Comment 7 oc666 2009-12-27 23:36:50 UTC
Sorry for the confusing but the bug exists after applying the patch.
I just remove all mdbtools (CVS and portage package) and install it from cvs with the patch describe in the link above. I get output of some data as NULL instead of some unicode text. I notice that this data contain two hyphens.

I check the package on ubuntu and the bug isn't exists there.
Comment 8 oc666 2009-12-28 18:24:05 UTC
Created attachment 214464 [details, diff]
Utf-8 patch for mdbtools

testing on mdbtools-0.6_pre2
Comment 9 oc666 2009-12-28 18:29:12 UTC
I just try the haveiconv_fix.patch and it's working. Fixed the problem.
The original patch doe's *not* needed (utf8.patch).

Maintainer: Need to add this patch to portage package.
Comment 10 Hans de Graaff gentoo-dev Security 2010-01-03 14:51:19 UTC
Thanks for looking into this. I've added mdbtools-0.6pre2-r1 with it applied.