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

[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.