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

Julien Nabet <serval2...@yahoo.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |serval2...@yahoo.fr

--- Comment #5 from Julien Nabet <serval2...@yahoo.fr> ---
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

Reply via email to