[Libreoffice-bugs] [Bug 131238] SQLite/ODBC: LibreOffice fails Unicode compliance whith multi-byte characters, such as emoji, for example 😂

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=131238

Robert Großkopf <robert at familiegrosskopf.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|LibreOffice BASE fails      |SQLite/ODBC: LibreOffice
                   |Unicode compliance when     |fails Unicode compliance
                   |BASIC SQL update statements |whith multi-byte
                   |contain multi-byte          |characters, such as emoji,
                   |characters, such as emoji.  |for example 😂
                   |For example 😂 will appear   |
                   |as either a question mark,  |
                   |or as two different         |
                   |characters.                 |

--- Comment #15 from Robert Großkopf <robert at familiegrosskopf.de> ---
(In reply to Max Fritzler from comment #14)
> What JDBC driver are you using to connect to BASE?  I'll give that a try.
> 
> I saw correct behavior using JDBC driver from  Taro L. Saito, availble here
> https://github.com/xerial/sqlite-jdbc.  However, this driver produced
> immediate cursor problems the moment I opened a table in the UI, a problem
> noticed by Ratslinger on ask libreoffice.org.  So I had to abandon the JDBC
> driver.

I tested MariaDB with this connections. 

SQLITE-connection with JDBC doesn't work (SQLite only supports
TYPE_FORWARD_ONLY Cursors).

Seems to me we are looking for a special Windows-bug here.

I will change the titel to set this to SQLite and ODBC

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200310/61ced055/attachment-0001.htm>