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

Comment #2 by Safiur RAHMAN:

Hi

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"]
    hTable.Update
  Endif

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.