Bug 120125 - Migration from HSQLDB to Firebird - table/field names with non-ASCII characters get replaced by additional characters in place of the non-ASCII character
Summary: Migration from HSQLDB to Firebird - table/field names with non-ASCII characte...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
6.1.1.2 release
Hardware: All macOS (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-09-26 10:10 UTC by Tim
Modified: 2018-09-26 13:24 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Tim 2018-09-26 10:10:22 UTC 
Description:
Field Names with accent (Spanish) change the letter with accent for several letters.

Also in Query when its boolean, the condition would be -1 or <> -1 and for Firebird is TRUE o FALSE.

Steps to Reproduce:
1.Would you like to migrate to Firebird now?
2.
3.

Actual Results:
Open a Form

Expected Results:
Error in ejecutivo Forms


Reproducible: Always


User Profile Reset: No



Additional Info:
Comment 1 Alex Thurgood 2018-09-26 10:34:27 UTC 
@Tim : please provide us with a test ODB file so that we can try and reproduce this.

Additionally, there appear to be 2 separate problems here. Please only focus on one, change the title accordingly, and open a separate bug report for the "boolean value in a query" issue.
Comment 2 Drew Jensen 2018-09-26 10:46:30 UTC 
First the non-ascii characters. That was an issue and was supposedly fixed.
https://bugs.documentfoundation.org/show_bug.cgi?id=117115

For the Booean question. HSQL didn't support boolean directly therefore the -1 or NOT -1, but Firebird does have an actual boolean type and migration assistant uses that for the migrated table. IIRC
Comment 3 Drew Jensen 2018-09-26 10:46:31 UTC Comment hidden (obsolete)
Comment 4 Alex Thurgood 2018-09-26 11:41:03 UTC 
@Drew : thanks, I see the fix for bug 117115 was only pushed to master and not backported to 6.1.x - as support for the migration and embedded Firebird is only experimental at the moment, I guess that is understandable.

Let's set this to WFM then.
Comment 5 Tim 2018-09-26 13:24:31 UTC 
Ok. Thanks.