[Libreoffice-bugs] [Bug 131238] New: 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

            Bug ID: 131238
           Summary: 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.
           Product: LibreOffice
           Version: 6.3.4.2 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: mfpublic11 at gmail.com

Description:
Note well.  Direct entry of an emoji into a table in LibreOffice via the Winkey
period dialog, or by simply pasting it in, works. 
But, trying to enter the data via the BASIC SQL Statement command fails. 
Example code below.
Similarly, reading a record from a SQLite table that contains an emoji into a
recordset, and then writing from the recordset to another table fails.
Using an SQL substring statement to copy a portion of the record from one table
to another works.  
I therefore there is something in the LibreOffice functions to write to a
database that is not Unicode compliant.


Steps to Reproduce:
1.See attached document with sample code and screen shots and results and
tracelogs
2.
3.

Actual Results:
It maps the emoji to either question marks, or to multiple characters with
incorrect shapes.  It appears to be interpreting a multi-byte emoji character
as two single-byte characters

Expected Results:
Emoji entered into the database


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Version: 6.3.4.2 (x64)
Build ID: 60da17e045e08f1793c57c00ba83cdfce946d0aa
CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win; 
Locale: en-US (en_US); UI-Language: en-US
Calc: threaded

-- 
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/20200309/18a7665a/attachment.htm>