[Libreoffice-bugs] [Bug 121469] FIREBIRD: Migration for table names with special characters fails
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Sat Nov 17 17:35:14 UTC 2018
https://bugs.documentfoundation.org/show_bug.cgi?id=121469
--- Comment #5 from m.a.riosv <miguelangelrv at libreoffice.org> ---
If I'm not wrong LibreOffice base always use delimiters.
Doing a test with direct SQL with a sentence like:
CREATE TABLE TESTTABLE (CUST_NO INTEGER NOT NULL, CUSTOMER VARCHAR(25) NOT
NULL, PRIMARY KEY (CUST_NO) )
works, but
CREATE TABLE Straße (CUST_NO INTEGER NOT NULL, CUSTOMER VARCHAR(25) NOT NULL,
PRIMARY KEY (CUST_NO) )
givers an error:
1: firebird_sdbc error:*Dynamic SQL Error *SQL error code = -104 *Token unknown
- line 1, column 18.
Just in the position of ß.
With CREATE TABLE "Straße" seems work.
Perhaps the issue it's the migration process not using delimiters.
--
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20181117/ba070d06/attachment.html>
More information about the Libreoffice-bugs
mailing list