[Gambas-bugtracker] Bug #2647: gb.db.mysql

[bugtracker at gambaswiki.org]

http://gambaswiki.org/bugtracker/edit?object=BUG.2647&from=L21haW4-

Charlie REINL reported a new bug.

Summary
-------

gb.db.mysql

Type             : Bug
Priority         : Medium
Gambas version   : Unknown
Product          : Unknown


Description
-----------

something strange, the Gambas driver for mysql gb.db.mysql 
it returns the string "null" for empty fields, if the field was created with 'db.String,25', but null for fields created with 'db.String,0'.
Ex:
with hTable
....
       .Fields.Add("invoiceNo", db.String, 0)
       .Fields.Add("tax_invoiceNr", db.String, 25)
...
      .Update      
End With

MySql shows that:

CREATE TABLE `crm_jobs` (
....
  `invoiceNr` text,
  `tax_invoiceNr` varchar(25) DEFAULT NULL,
....
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


System information
------------------

[System]
Gambas=3.17.90 3ea84d119 (master)
OperatingSystem=Linux
Kernel=5.4.0-131-generic
Architecture=x86_64
Distribution=Ubuntu 20.04.5 LTS
Desktop=MATE
Font=Ubuntu,11
Scale=8
Theme=menta
Language=de_DE.UTF-8
Memory=5911M

[Libraries]
Cairo=libcairo.so.2.11600.0
Curl=libcurl.so.4.6.0
DBus=libdbus-1.so.3.19.11
GDK2=libgdk-x11-2.0.so.0.2400.32
GDK3=libgdk-3.so.0.2404.16
GStreamer=libgstreamer-1.0.so.0.1603.0
GTK+2=libgtk-x11-2.0.so.0.2400.32
GTK+3=libgtk-3.so.0.2404.16
OpenGL=libGL.so.1.7.0
Poppler=libpoppler.so.73.0.0
Poppler=libpoppler.so.97.0.0
QT5=libQt5Core.so.5.12.8
SDL=libSDL-1.2.so.0.11.4
SQLite=libsqlite3.so.0.8.6

[Environment]
CLUTTER_IM_MODULE=ibus
COMPIZ_CONFIG_PROFILE=mate
DBUS_SESSION_BUS_ADDRESS=unix:path=/run/user/1000/bus
DESKTOP_SESSION=mate
DISPLAY=:0
EDITOR=pluma
GB_GUI=gb.gtk3
GDMSESSION=mate
GDM_LANG=de_DE
GIO_LAUNCHED_DESKTOP_FILE=<home>/Schreibtisch/gambas3.desktop
GIO_LAUNCHED_DESKTOP_FILE_PID=3416
GPG_AGENT_INFO=/run/user/1000/gnupg/S.gpg-agent:0:1
GTK_IM_MODULE=ibus
GTK_MODULES=appmenu-gtk-module:gail:atk-bridge:canberra-gtk-module
GTK_OVERLAY_SCROLLING=0
HOME=<home>
INSIDE_CAJA_PYTHON=
LANG=de_DE.UTF-8
LANGUAGE=de_DE.UTF-8
LC_ALL=de_DE.UTF-8
LOGNAME=<user>
MATE_DESKTOP_SESSION_ID=this-is-deprecated
PATH=<home>/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games:/snap/bin
PWD=<home>
QT4_IM_MODULE=ibus
QT_ACCESSIBILITY=1
QT_AUTO_SCREEN_SCALE_FACTOR=0
QT_IM_MODULE=ibus
QT_LOGGING_RULES=*.debug=false
QT_QPA_PLATFORMTHEME=gtk2
QT_SCALE_FACTOR=1
SESSION_MANAGER=local/<hostname>:@/tmp/.ICE-unix/2163,unix/<hostname>:/tmp/.ICE-unix/2163
SHELL=/bin/bash
SHLVL=0
SSH_AGENT_PID=2350
SSH_AUTH_SOCK=/run/user/1000/keyring/ssh
TZ=:/etc/localtime
UBUNTU_MENUPROXY=1
USER=<user>
XAUTHORITY=<home>/.Xauthority
XDG_CONFIG_DIRS=/etc/xdg/xdg-mate:/etc/xdg
XDG_CURRENT_DESKTOP=MATE
XDG_DATA_DIRS=/usr/share/mate:/usr/share/mate:<home>/.local/share/flatpak/exports/share:/var/lib/flatpak/exports/share:/usr/local/share:/usr/share:/var/lib/snapd/desktop
XDG_GREETER_DATA_DIR=/var/lib/lightdm-data/<user>
XDG_RUNTIME_DIR=/run/user/1000
XDG_SEAT=seat0
XDG_SEAT_PATH=/org/freedesktop/DisplayManager/Seat0
XDG_SESSION_CLASS=user
XDG_SESSION_DESKTOP=mate
XDG_SESSION_ID=c2
XDG_SESSION_PATH=/org/freedesktop/DisplayManager/Session0
XDG_SESSION_TYPE=x11
XDG_VTNR=7
XMODIFIERS=@im=ibus