https://bugs.freedesktop.org/show_bug.cgi?id=43543
Bug #: 43543
Summary: ODBC - unicode column names
Classification: Unclassified
Product: LibreOffice
Version: LibO 3.4.4 release
Platform: x86-64 (AMD64)
OS/Version: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Database
AssignedTo: [email protected]
ReportedBy: [email protected]
The main problem is with sqlite3's ODBC driver.
I have a .db3 database where column names contain non-ascii characters. Here's
the tests I conducted (on two Win7x64 computers)
In LibreOffice Base:
1. When connecting to .db3 through ODBC and opening the table, non-ascii column
names are shown as ????. In 'Edit' it shows correct column names (I had to set
UTF-8 encoding for that but it worked only for edit mode)
2. When connecting to .accdb version of the same database (through ODBC) column
names are ????, and Edit shows ???? too. I did not tinker with connection's
settings in this test.
3. When connecting to .accdb directly without ODBC, column names are shown
correctly.
4. In MSAccess 2010, connecting to .db3 through ODBC driver, column names are
shown correctly everywhere.
Basically, MSAccess works fine with sqlite's ODBC driver while Base cannot SHOW
non-unicode column names in table view. Almost the same happens with MSAccess's
ODBC driver. Judging from my tests, I believe something's wrong with Base's
handling of ODBC data. From 1 - it does get correct field names (shows them in
edit mode), it just cannot show them in table mode.
I did not run anymore tests.
If the problem is in ODBC (it happens with both msaccess and sqlite drivers),
please provide some technical info I could send to their authors.
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
