<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:serval2412@yahoo.fr" title="Julien Nabet <serval2412@yahoo.fr>"> <span class="fn">Julien Nabet</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEW "
title="NEW - MYSQL/MariaDB native connector: Column Type "TEXT" is reported as "VARCHAR""
href="https://bugs.documentfoundation.org/show_bug.cgi?id=126852">bug 126852</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>serval2412@yahoo.fr
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - MYSQL/MariaDB native connector: Column Type "TEXT" is reported as "VARCHAR""
href="https://bugs.documentfoundation.org/show_bug.cgi?id=126852#c5">Comment # 5</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - MYSQL/MariaDB native connector: Column Type "TEXT" is reported as "VARCHAR""
href="https://bugs.documentfoundation.org/show_bug.cgi?id=126852">bug 126852</a>
from <span class="vcard"><a class="email" href="mailto:serval2412@yahoo.fr" title="Julien Nabet <serval2412@yahoo.fr>"> <span class="fn">Julien Nabet</span></a>
</span></b>
<pre>Robert: I took a look at
<a href="https://chartio.com/resources/tutorials/understanding-strorage-sizes-for-mysql-text-data-types/">https://chartio.com/resources/tutorials/understanding-strorage-sizes-for-mysql-text-data-types/</a>,
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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>