[Libreoffice-bugs] [Bug 127040] HSQLDB to Firebird automated migration failure when record size exceeds 64k

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=127040

--- Comment #30 from Julien Nabet <serval2412 at yahoo.fr> ---
(In reply to Alex Thurgood from comment #29)
> (In reply to Julien Nabet from comment #28)
> 
> Nice testing work thanks ! :)
> 
> Looks like we're stuck then. 
> 
> Any tables that have SUM(VARCHAR(N)) > 64K will fail with default UTF-8
> encoding, and even if we could use ISO8859_1, it would fail to pick up
> non-ASCII data and probably then fail elsewhere (truncation ?).

Probably yes and if we'd use ISO8859_1 (which only needs 1 byte per character),
we may store 4x than UTF8 but we'll be still constrained to 64k whereas in
HSQLDB, I quote http://hsqldb.sourceforge.net/web/hsqlFAQ.html:
"There is no imposed limitation. Number of columns, tables, indexes, size of
columns and so on is limited only by the memory. For example, a user reported
using a SELECT statement with 41 LEFT OUTER JOIN clauses on a huge database for
a data mining application. "

That's why I had set NOTOURBUG.

-- 
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/20190912/f2d21f35/attachment.html>