[Libreoffice-bugs] [Bug 126852] MYSQL/MariaDB native connector: Column Type "TEXT" is reported as "VARCHAR"
https://bugs.documentfoundation.org/show_bug.cgi?id=126852 --- Comment #7 from Julien Nabet --- Robert: Thank you for your feedback. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 126852] MYSQL/MariaDB native connector: Column Type "TEXT" is reported as "VARCHAR"
https://bugs.documentfoundation.org/show_bug.cgi?id=126852 Robert Großkopf changed: What|Removed |Added Status|NEW |RESOLVED Resolution|--- |FIXED --- Comment #6 from Robert Großkopf --- (In reply to Julien Nabet from comment #5) > Robert: I took a look at > https://chartio.com/resources/tutorials/understanding-strorage-sizes-for- > mysql-text-data-types/, are you sure it should be "MEMO TEXT" and not "MEMO > TINYTEXT" ? The original MySQL/MariaDB datatype is TEXT. If you open the tableeditor in Base you see Memo[TEXT]. "Memo" is only a description in Base, has nothing to do with MySQL/MariaDB. TEXT is the type an it will have a maximum of 65525 characters. TINYTEXT has a maximum of 255 characters. This bug has been fixed now. The code for creating a table is misleading. Must be CREATE TABLE strtest (d TEXT); without a defined length. This will work right now with LO 6.3.4.1, fails with LO 6.2.6.2. I will set this one to RESOLVED FIXED -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 126852] MYSQL/MariaDB native connector: Column Type "TEXT" is reported as "VARCHAR"
https://bugs.documentfoundation.org/show_bug.cgi?id=126852
Julien Nabet changed:
What|Removed |Added
CC||serval2...@yahoo.fr
--- Comment #5 from Julien Nabet ---
Robert: I took a look at
https://chartio.com/resources/tutorials/understanding-strorage-sizes-for-mysql-text-data-types/,
are you sure it should be "MEMO TEXT" and not "MEMO TINYTEXT" ?
Indeed, with this patch:
diff --git a/connectivity/source/drivers/mysqlc/mysqlc_general.cxx
b/connectivity/source/drivers/mysqlc/mysqlc_general.cxx
index 4c7c8465c798..5345bb418908 100644
--- a/connectivity/source/drivers/mysqlc/mysqlc_general.cxx
+++ b/connectivity/source/drivers/mysqlc/mysqlc_general.cxx
@@ -189,7 +189,10 @@ sal_Int32 mysqlStrToOOOType(const OUString& sType)
return css::sdbc::DataType::TINYINT;
if (sType.equalsIgnoreAsciiCase("smallint") ||
sType.equalsIgnoreAsciiCase("mediumint"))
return css::sdbc::DataType::SMALLINT;
-if (sType.equalsIgnoreAsciiCase("longtext"))
+if (sType.equalsIgnoreAsciiCase("longtext")
+ || sType.equalsIgnoreAsciiCase("tinytext")
+ || sType.equalsIgnoreAsciiCase("mediumtext")
+ )
return css::sdbc::DataType::LONGVARCHAR;
if (sType.equalsIgnoreAsciiCase("int"))
return css::sdbc::DataType::INTEGER;
I retrieved "MEMO TINYTEXT" but I must recognize I'm not "fluent" about Mysql
types.
--
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 126852] MYSQL/MariaDB native connector: Column Type "TEXT" is reported as "VARCHAR"
https://bugs.documentfoundation.org/show_bug.cgi?id=126852 Commit Notification changed: What|Removed |Added Whiteboard|target:6.4.0|target:6.4.0 target:6.3.3 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 126852] MYSQL/MariaDB native connector: Column Type "TEXT" is reported as "VARCHAR"
https://bugs.documentfoundation.org/show_bug.cgi?id=126852 --- Comment #4 from Commit Notification --- Tamas Bunth committed a patch related to this issue. It has been pushed to "libreoffice-6-3": https://git.libreoffice.org/core/commit/882cfc31f88cf62b46c29b737c24afd11b6d560c tdf#126852 Bind TEXT mysql type to Clob It will be available in 6.3.3. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 126852] MYSQL/MariaDB native connector: Column Type "TEXT" is reported as "VARCHAR"
https://bugs.documentfoundation.org/show_bug.cgi?id=126852 Commit Notification changed: What|Removed |Added Whiteboard||target:6.4.0 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 126852] MYSQL/MariaDB native connector: Column Type "TEXT" is reported as "VARCHAR"
https://bugs.documentfoundation.org/show_bug.cgi?id=126852 --- Comment #3 from Commit Notification --- Tamas Bunth committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/+/47a62ede2403772b8743bfcfa0b6dd4be17fec9c%5E%21 tdf#126852 Bind TEXT mysql type to Clob It will be available in 6.4.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 126852] MYSQL/MariaDB native connector: Column Type "TEXT" is reported as "VARCHAR"
https://bugs.documentfoundation.org/show_bug.cgi?id=126852 Alex Thurgood changed: What|Removed |Added Version|6.4.0.0.alpha0+ Master |6.2.5.2 release -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 126852] MYSQL/MariaDB native connector: Column Type "TEXT" is reported as "VARCHAR"
https://bugs.documentfoundation.org/show_bug.cgi?id=126852 --- Comment #2 from Alex Thurgood --- I connected to a mysql server instance instead of MariaDB, but the result is the same. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 126852] MYSQL/MariaDB native connector: Column Type "TEXT" is reported as "VARCHAR"
https://bugs.documentfoundation.org/show_bug.cgi?id=126852 Alex Thurgood changed: What|Removed |Added Ever confirmed|0 |1 Status|UNCONFIRMED |NEW --- Comment #1 from Alex Thurgood --- Confirming with Version: 6.2.5.2 Build ID: 1ec314fa52f458adc18c4f025c545a4e8b22c159 Threads CPU : 4; OS : Mac OS X 10.14.6; UI Render : par défaut; VCL: osx; Locale : fr-FR (fr_FR.UTF-8); Langue IHM : fr-FR Calc: threaded -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 126852] MYSQL/MariaDB native connector: Column Type "TEXT" is reported as "VARCHAR"
https://bugs.documentfoundation.org/show_bug.cgi?id=126852 Robert Großkopf changed: What|Removed |Added Blocks||119927 See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=12 ||6799 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=119927 [Bug 119927] [META] MariaDB C API -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
