[Libreoffice-bugs] [Bug 145714] in Base, the mediumblob MySQL fields are shown as Text[VARCHAR] - no mysql connector native driver support for MEDIUMBLOB datatype.

2021-11-18 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=145714

Julien Nabet  changed:

   What|Removed |Added

   Assignee|libreoffice-b...@lists.free |serval2...@yahoo.fr
   |desktop.org |
 Status|NEW |ASSIGNED
 CC||ipla...@tuta.io,
   ||lio...@mamane.lu,
   ||rob...@familiegrosskopf.de

--- Comment #5 from Julien Nabet  ---
I gave a try with:
https://gerrit.libreoffice.org/c/core/+/125472

Jean-Paul: as indicated in the patch waiting for review:
"
I let aside YEAR (see https://mariadb.com/kb/en/year-data-type/) because it
seems there's no LO Datatype which could correspond in
https://opengrok.libreoffice.org/xref/core/offapi/com/sun/star/sdbc/DataType.idl?r=2b383d19
"

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 145714] in Base, the mediumblob MySQL fields are shown as Text[VARCHAR] - no mysql connector native driver support for MEDIUMBLOB datatype.

2021-11-17 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=145714

Julien Nabet  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=14
   ||5205

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 145714] in Base, the mediumblob MySQL fields are shown as Text[VARCHAR] - no mysql connector native driver support for MEDIUMBLOB datatype.

2021-11-17 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=145714

Julien Nabet  changed:

   What|Removed |Added

 CC||serval2...@yahoo.fr
 Ever confirmed|0   |1
 Status|UNCONFIRMED |NEW

--- Comment #4 from Julien Nabet  ---
On pc Debian x86-64 with master sources updated today, I could reproduce this.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 145714] in Base, the mediumblob MySQL fields are shown as Text[VARCHAR] - no mysql connector native driver support for MEDIUMBLOB datatype.

2021-11-17 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=145714

--- Comment #3 from jn...@outlook.com ---
I did some more research on this problem. It seems that some MySQL data types
are not supported by the mysql native connector driver. 

Here is a list of some of these fields : 

MYSQL field type   Actual BASE field type   Expected BASE field type

  bit()  Date [DATE]  Binary(fix) [BIT]
  mediumblob Text [VARCHAR]   Image [MEDIUMBLOB]
  mediumtext Text [VARCHAR]   Memo [MEDIUMTEXT]
  tinyblob   Text [VARCHAR]   Image [TINYBLOB]
  tinytext   Text [VARCHAR]   Memo [TINYTEXT]
  year   Text [VARCHAR]   Date [YEAR]


The problem with the bit type is reported as bug 145205.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 145714] in Base, the mediumblob MySQL fields are shown as Text[VARCHAR] - no mysql connector native driver support for MEDIUMBLOB datatype.

2021-11-17 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=145714

jn...@outlook.com changed:

   What|Removed |Added

Summary|With the direct MySQL   |in Base, the mediumblob
   |connector in Base, the  |MySQL fields are shown as
   |mediumblob fields (images)  |Text[VARCHAR] - no mysql
   |are shown as Text[VARCHAR]. |connector native driver
   ||support for MEDIUMBLOB
   ||datatype.

-- 
You are receiving this mail because:
You are the assignee for the bug.