Cli

3.0.0

src/MySql/Get-Collation.psm1

                                using namespace System.Collections.Generic

<#

.SYNOPSIS

    Gets the list of all collations.

.PARAMETER Connection

    The database connection.

.OUTPUTS

    The list of all collations.

#>

function Get-Collation {

    [OutputType([string[]])]

    param ([Parameter(Mandatory, Position = 0)] [ValidateNotNull()] [MySqlConnection] $Connection)

    $list = [List[string]]::new()

    $reader = [MySqlCommand]::new("SHOW COLLATION", $Connection).ExecuteReader()

    while ($reader.Read()) { $list.Add($reader["Collation"]) }

    $reader.Close()

    $list.ToArray()

}