[Gambas-bugtracker] Bug #2608: Field length VARCHAR(60000) is taken as MEDIUMTEXT

[bugtracker at gambaswiki.org]

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

Safiur RAHMAN reported a new bug.

Summary
-------

Field length VARCHAR(60000) is taken as MEDIUMTEXT

Type             : Bug
Priority         : High
Gambas version   : Master
Product          : Database component


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

When creating database table with large field length eg. VARCHAR(60000) is taken by gambas as MEDIUMTEXT. However, MySQL VARCHAR is the variable-length string whose length can be up to 65,535
https://dev.mysql.com/doc/refman/8.0/en/char.html


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

[System]
Gambas=3.17.3
OperatingSystem=Linux
Kernel=5.15.0-43-generic
Architecture=x86_64
Distribution=Ubuntu 20.04.4 LTS
Desktop=UBUNTU
Font=Ubuntu,11
Scale=8
Theme=yaru-light
Language=en_US.UTF-8
Memory=3807M

[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.97.0.0
QT5=libQt5Core.so.5.12.8
SDL=libSDL-1.2.so.0.11.4
SQLite=libsqlite3.so.0.8.6

[Environment]
DBUS_SESSION_BUS_ADDRESS=unix:path=/run/user/1000/bus
DESKTOP_SESSION=<user>
DISPLAY=:0
GB_GUI=gb.gtk3
GDMSESSION=<user>
GIO_LAUNCHED_DESKTOP_FILE=/usr/share/applications/gambas3.desktop
GIO_LAUNCHED_DESKTOP_FILE_PID=47812
GJS_DEBUG_OUTPUT=stderr
GJS_DEBUG_TOPICS=JS ERROR;JS LOG
GNOME_DESKTOP_SESSION_ID=this-is-deprecated
GNOME_SHELL_SESSION_MODE=<user>
GPG_AGENT_INFO=/run/user/1000/gnupg/S.gpg-agent:0:1
GTK_MODULES=gail:atk-bridge
HOME=<home>
IM_CONFIG_PHASE=1
INVOCATION_ID=a4f09a52301c46128a3af5845ded3e4f
JOURNAL_STREAM=8:48792
LANG=en_US.UTF-8
LC_ADDRESS=bho_NP
LC_ALL=en_US.UTF-8
LC_IDENTIFICATION=bho_NP
LC_MEASUREMENT=bho_NP
LC_MONETARY=bho_NP
LC_NAME=bho_NP
LC_NUMERIC=bho_NP
LC_PAPER=bho_NP
LC_TELEPHONE=bho_NP
LC_TIME=bho_NP
LOGNAME=<user>
MANAGERPID=2262
PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games:/snap/bin
PWD=<home>
QT_ACCESSIBILITY=1
QT_IM_MODULE=ibus
QT_LOGGING_RULES=*.debug=false
SESSION_MANAGER=local/<hostname>:@/tmp/.ICE-unix/2481,unix/<hostname>:/tmp/.ICE-unix/2481
SHELL=/bin/bash
SHLVL=0
SSH_AGENT_PID=2442
SSH_AUTH_SOCK=/run/user/1000/keyring/ssh
TZ=:/etc/localtime
USER=<user>
USERNAME=<user>
WINDOWPATH=2
XAUTHORITY=/run/user/1000/gdm/Xauthority
XDG_CONFIG_DIRS=/etc/xdg/xdg-<user>:/etc/xdg
XDG_CURRENT_DESKTOP=<user>:GNOME
XDG_DATA_DIRS=/usr/share/<user>:/usr/local/share/:/usr/share/:/var/lib/snapd/desktop
XDG_MENU_PREFIX=gnome-
XDG_RUNTIME_DIR=/run/user/1000
XDG_SESSION_CLASS=user
XDG_SESSION_DESKTOP=<user>
XDG_SESSION_TYPE=x11
XMODIFIERS=@im=ibus
_=/usr/bin/dbus-update-activation-environment