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

bugtracker at gambaswiki.org bugtracker at gambaswiki.org
Sat Aug 6 20:23:41 CEST 2022


Comment #2 by Safiur RAHMAN:


when i make a table in mysql in the following way:

$con = OpenConnection("mysql", "localhost", "gbapp", "root", "ubuntu")

  If Not $con.Tables.Exist("tbltest") Then
    hTable = $con.Tables.Add("tbltest")
    hTable.Fields.Add("flid", db.Serial)
    hTable.Fields.Add("fldparent", db.String, 255)
    hTable.Fields.Add("fldchild", db.String, 60000)
    hTable.PrimaryKey = ["flid"]

I get fldchild field as MediumText. It should be VARCHAR (60000) or Text if exceeds

Attached a project


Attachment: dbapp.zip

Safiur RAHMAN changed the state of the bug to: Accepted.

More information about the Bugtracker mailing list