Home > comp > gb.db.mysql > _mysql > collation 
  [3.0]
 fr de es it nl pl pt pt_BR mk sq ca ar fa vi ja ru zh zh_TW eo
Previous  Next  Edit  Rename  Undo  Refresh  Search  Administration  
Documentation
History
 
Collation
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.