<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:mfpublic11@gmail.com" title="Max Fritzler <mfpublic11@gmail.com>"> <span class="fn">Max Fritzler</span></a>
</span> changed
<a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - 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."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=131238">bug 131238</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>NEEDINFO
</td>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<td style="text-align:right;">Ever confirmed</td>
<td>1
</td>
<td>
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - 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."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=131238#c11">Comment # 11</a>
on <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - 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."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=131238">bug 131238</a>
from <span class="vcard"><a class="email" href="mailto:mfpublic11@gmail.com" title="Max Fritzler <mfpublic11@gmail.com>"> <span class="fn">Max Fritzler</span></a>
</span></b>
<pre>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)</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>