https://bugs.documentfoundation.org/show_bug.cgi?id=144147
Bug ID: 144147 Summary: Strange characters appearing in a LibreOffice Base Query Result (using a Firebird embebbed database) Product: LibreOffice Version: 7.2.0.4 release Hardware: x86-64 (AMD64) OS: Windows (All) Status: UNCONFIRMED Severity: normal Priority: medium Component: Base Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: heitorhed...@gmail.com Description: I am trying to use the LIST function to produce a list of all rows in a column of a table called artist. So I made the following query: SELECT LIST (“artist_name”) FROM “artist” It returns the concatenated rows but also a lot of strange squares. I've posted a help request in the community with a screenshot and some more details. Link to the thread: https://ask.libreoffice.org/t/trouble-with-the-list-aggregate-function-firebird/67430) Steps to Reproduce: 1.Created a table called "artist" with a INT primary key and a VARCHAR column called "artist_name". 2.Tried to query using the command SELECT LIST (“artist_name”) FROM “artist” Actual Results: I got the result "Stan Lee□□□□□□□□,□□□□□□□□□□□□□□□Jack Kirby□□□□□□,□□□□□□□□□□□□□□□Dick Ayers□□□□□□" Expected Results: I should have received the result "Stan Lee, Jack Kirby, Dick Ayers" Reproducible: Always User Profile Reset: Yes Additional Info: Version: 7.2.0.4 (x64) / LibreOffice Community Build ID: 9a9c6381e3f7a62afc1329bd359cc48accb6435b CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win Locale: en-US (pt_BR); UI: pt-BR Calc: CL -- You are receiving this mail because: You are the assignee for the bug.