Gambas Documentation - /comp/gb.mysql/_mysql/collation

/comp/gb.mysql/_mysql/collation

# _MySQL.Collation (gb.mysql)

Property Collation As String

Returns or sets the Collation used by the MySQL class.

The default Collation is utf8_general_ci

### Examples

    Dim hCon As New Connection

    With hCon
      .Type = "mysql"
      .Port = "3306"
      .Host = "localhost"
      .User = "root"
      .Password = "mypass"
      .Name = "Gambas"
      .Open()
    End With

    hCon.MySQL.Collation = "utf8_general_ci"

    Print hCon.MySQL.Collation

See your information_schema.COLLATIONS for all aviable collation.

Charset & Collations for more details.

See this example.