[Libreoffice-bugs] [Bug 131238] LibreOffice BASE fails Unicode compliance when BASIC SQL update statements contain multi-byte characters, such as emoji. For example 😂 will appear as either a question mark, or as two different characters.

[bugzilla-daemon at bugs.documentfoundation.org]

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

Max Fritzler <mfpublic11 at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEEDINFO                    |UNCONFIRMED
     Ever confirmed|1                           |0

--- Comment #11 from Max Fritzler <mfpublic11 at gmail.com> ---
I was requested to test the test macro in HSQL format.  I uploaded two test
databases, one in HSQL and one in Firebird.  The macro works as expected in
both those formats, but fails for SQLite.  Evidently, the processing of an SQL
string as shown below is done differently based on the attached database.  Whis
is not really a surprise.  Here's the statement that succeeds in embedded
databases, but fails with SQLite
Dim oStatement As Object
oStatement = ThisComponent.CurrentController.ActiveConnection.createStatement()
      sql = "INSERT INTO TestEmoji (author, comment) VALUES ('test author',
'❤❤SWIFTIE❤❤')"
result = oStatement.execute(sql)

-- 
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/b742b4bc/attachment.htm>