[Libreoffice-bugs] [Bug 43543] ODBC - unicode column names

bugzilla-daemon at freedesktop.org bugzilla-daemon at freedesktop.org
Sat May 5 10:45:17 CEST 2012


https://bugs.freedesktop.org/show_bug.cgi?id=43543

--- Comment #2 from andy-scull at yandex.ru 2012-05-05 01:45:17 PDT ---
Created attachment 61071
  --> https://bugs.freedesktop.org/attachment.cgi?id=61071
test case

Here you go. One notice - I use japanese letters.
Inside are .db3 sqlite base and .odb I saved after connecting and changing
encoding inside it to utf-8.
Odbc settings were all default, I didn't see any encoding options in there so I
left them as is. Driver version is 0.94 64bit
(http://www.ch-werner.de/sqliteodbc)

Second column in table contains a string copied from japanese google (as far as
I remember).
Tables:
When viewing table data it shows as ???.
When editing table it correctly show japanese characters.

Queries: It shows ??? if I add all columns to query (*) in constructor.
If I add that column separately, it shows quoted(") japanese string.

Just to remind - there's no problems editing table, the only place it shows ???
is in column names in table/query view.

It seems to be related to system's non-unicode settings.
My comp. has russian codepage, and having these problems. I've tried
linking/opening the same database on another computer (win2008r2) with japanese
codepage and it seems to be working OK.
p.s. as I said, msaccess did not have this problem in the first place, it
correctly connects and shows everything with any system codepage

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.



More information about the Libreoffice-bugs mailing list