https://bugs.documentfoundation.org/show_bug.cgi?id=159010
Bug ID: 159010
Summary: FIREBIRD: Text in queries will be followed by many
spaces
Product: LibreOffice
Version: 7.6.4.1 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Created attachment 191747
--> https://bugs.documentfoundation.org/attachment.cgi?id=191747&action=edit
Testdatabase - execute queries in Tools → SQL. Let you show the output.
Open the attached database.
Go to Tolls → SQL.
Press "Show output of "select" statements.
Run
SELECT "ID", 'Street' "S", "Street", 'PC' "P", "Postcode", "Town" FROM
"tbl_address"
You will see the folloing output:
1,Street ,Pappelallee 13a,PC ,67891,Nowhere,
Direct input for text content will be followed by Spaces, which expands the
text to 4* (2 charcters → 8 charactes with spaces …)
Run
SELECT "ID", TRIM ( BOTH FROM 'Street' ) "S", "Street", TRIM ( BOTH FROM 'PC' )
"P", "Postcode", "Town" FROM "tbl_address"
and the spaces have been gone.
The 2 queries will contain the code for this also.
Detected this problem while exporting queries into *.txt (*.xml) files.
Seems it is connected to the behavior of Firebird with character lengths. It
had been a problem some times ago. The character length for Firebird in LO had
been moved down from 32.767 bytes to 8.191 chars for UTF8 code (32.767/4 =
8.191).
Detected this here in all installed versions of LO, special LO 7.6.4.1 on
OpenSUSE Linux.
--
You are receiving this mail because:
You are the assignee for the bug.
