https://bugs.documentfoundation.org/show_bug.cgi?id=104904
Bug ID: 104904
Summary: Firebird: Function LEFT gives wrong count with special
characters
Product: LibreOffice
Version: 5.4.0.0.alpha0+ Master
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Created attachment 129916
--> https://bugs.documentfoundation.org/attachment.cgi?id=129916&action=edit
Open query "Left" - shows wrong number of characters for fields with special
characters.
Open the attached database.
Open the query "Left".
The content of the field "Name" is set to LEFT("Name",3)
Shows only the first two characters, if the "Name" has special characters at
the beginning of "Name".
SELECT "Name", LEFT("Name", 3) FROM "Table"
gives
Bülgin | Bü
Gloria | Glo
Örtchen | Ör
Works right with HSQLDB, wrong with Firebird.
Tested with
Version: 5.4.0.0.alpha0+
Build ID: 2a4cd80abcf9e515d1ce3b3a944b573bdc42bff2
CPU Threads: 4; OS Version: Linux 4.1; UI Render: default; VCL: kde4;
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time:
2016-12-22_00:18:04
Locale: de-DE (de_DE.UTF-8); Calc: group
--
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
