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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
