[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
https://bugs.documentfoundation.org/show_bug.cgi?id=131238 --- Comment #14 from Max Fritzler --- 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. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[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
https://bugs.documentfoundation.org/show_bug.cgi?id=131238 --- Comment #13 from Robert Großkopf --- Have tested the same now in SQLITE. Connected to a SQLITE-database trough ODBC. Opened a table and added an emoji. Saved the row. Refreshed the row. Emoji has been saved. The same result I got when executing the Basic-Macro. So I couldn't see any buggy behavior here. Tested under OpenSUSE 15.1 64bit rpm Linux, LO 6.4.2.1, also LO 6.3.5.2 SQLITE 3.28.0 sqliteodbc 0.9995 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[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
https://bugs.documentfoundation.org/show_bug.cgi?id=131238 --- Comment #12 from Robert Großkopf --- While reading your description, pasting of data into a table works, but "When I did Data / Refresh in LibreOffice I saw the same thing: " (2 ?? instead of the emoji). So it seems it has nothing to do with the Basic-macro. Then I tested the same with a MariaDB, connected with the direct driver, connected with ODBC and connected with JDBC to Base. All these drivers will give the same result. The data will be saved and could be seen well after refreshing the table. I will have a look at SQLITE now. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[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
https://bugs.documentfoundation.org/show_bug.cgi?id=131238
Max Fritzler changed:
What|Removed |Added
Status|NEEDINFO|UNCONFIRMED
Ever confirmed|1 |0
--- Comment #11 from Max Fritzler ---
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.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[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
https://bugs.documentfoundation.org/show_bug.cgi?id=131238 --- Comment #10 from Max Fritzler --- Created attachment 158560 --> https://bugs.documentfoundation.org/attachment.cgi?id=158560=edit test database in HSQL format I was requested to check the test macro in HSQL format. This is the test db in embedded HSQL format. While i was at it, I tested it in embedded Firebird format, and uploaed that in a separate attachment. The macro works as expected with embedded HSQL or embedded Firebird, which shows the problem is apparently isolated to cases using the SQLite back end. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[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
https://bugs.documentfoundation.org/show_bug.cgi?id=131238 --- Comment #9 from Max Fritzler --- Created attachment 158559 --> https://bugs.documentfoundation.org/attachment.cgi?id=158559=edit TestDB for embedded Firebird I was requested to check the test macro in HSQL format. While i was at it, I tested it in embedded Firebird format. This is the test db in embedded Firebird format. The macro works as expected there, which shows the problem is apparently isolated to cases using the SQLite back end. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[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
https://bugs.documentfoundation.org/show_bug.cgi?id=131238 Robert Großkopf changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO Ever confirmed|0 |1 --- Comment #8 from Robert Großkopf --- I have tested only this: Pasted the emoji to an internal HSQLDB. No problem occured. Could also refresh the table - no problem. There are so many things reported here, which could be a part of the bug. Could you please test your BASIC macro with the internal HSQLDB? -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[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
https://bugs.documentfoundation.org/show_bug.cgi?id=131238 Max Fritzler changed: What|Removed |Added Attachment #158512|0 |1 is obsolete|| --- Comment #7 from Max Fritzler --- Comment on attachment 158512 --> https://bugs.documentfoundation.org/attachment.cgi?id=158512 Sample BASE db with code to demonstrate the bug. Sorry, uploaded the wrong version. I've uploaded a correct version in another attahment with the irrelevent junk stripped out of this one. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[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
https://bugs.documentfoundation.org/show_bug.cgi?id=131238 --- Comment #6 from Max Fritzler --- Created attachment 158528 --> https://bugs.documentfoundation.org/attachment.cgi?id=158528=edit The correct TestEmoji for use with testing. Please discard the other one. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[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
https://bugs.documentfoundation.org/show_bug.cgi?id=131238 --- Comment #5 from Max Fritzler --- Created attachment 158514 --> https://bugs.documentfoundation.org/attachment.cgi?id=158514=edit SQL trace log from direct update, which works correctly -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[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
https://bugs.documentfoundation.org/show_bug.cgi?id=131238 --- Comment #4 from Max Fritzler --- Created attachment 158513 --> https://bugs.documentfoundation.org/attachment.cgi?id=158513=edit SQL trace log from function that produces the error -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[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
https://bugs.documentfoundation.org/show_bug.cgi?id=131238 --- Comment #3 from Max Fritzler --- Created attachment 158512 --> https://bugs.documentfoundation.org/attachment.cgi?id=158512=edit Sample BASE db with code to demonstrate the bug. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[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
https://bugs.documentfoundation.org/show_bug.cgi?id=131238 --- Comment #2 from Max Fritzler --- Created attachment 158511 --> https://bugs.documentfoundation.org/attachment.cgi?id=158511=edit sample SQLITE Db containing a few records for the test code -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[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
https://bugs.documentfoundation.org/show_bug.cgi?id=131238 Max Fritzler changed: What|Removed |Added CC||mfpubli...@gmail.com --- Comment #1 from Max Fritzler --- Created attachment 158510 --> https://bugs.documentfoundation.org/attachment.cgi?id=158510=edit detailed steps to reproduce Several pages of screenshots showing how to reproduce the problem, includes sample test code listing. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
