DatabaseCollation

public final class DatabaseCollation

A Collation is a string comparison function used by SQLite.

name
Undocumented
Declaration
Swift

public final class DatabaseCollation
Show on GitHub


                    
                    
                    init(_:function:)

Returns a collation.

let collation = DatabaseCollation("localized_standard") { (string1, string2) in
    return (string1 as NSString).localizedStandardCompare(string2)
}
db.add(collation: collation)
try db.execute("CREATE TABLE files (name TEXT COLLATE localized_standard")

Declaration

Swift

public init(_ name: String, function: @escaping (String, String) -> ComparisonResult)

Parameters

`name`	The function name.
`function`	A function that compares two strings.

Show on GitHub

hashValue
The hash value.
Declaration
Swift

public var hashValue: Int
Show on GitHub
==(_:_:)
Two collations are equal if they share the same name (case insensitive)
Declaration
Swift

public static func == (lhs: DatabaseCollation, rhs: DatabaseCollation) -> Bool
Show on GitHub

unicodeCompare
A collation, or SQL string comparison function, that compares strings according to the the Swift built-in == and <= operators.

This collation is automatically added by GRDB to your database connections.

You can use it when creating database tables:
```
let collationName = DatabaseCollation.caseInsensitiveCompare.name
dbQueue.execute(
    "CREATE TABLE persons (" +
        "name TEXT COLLATE \(collationName)" +
    ")"
)
```
Declaration
Swift

public static let unicodeCompare = DatabaseCollation("swiftCompare") { (lhs, rhs) in
Show on GitHub
caseInsensitiveCompare
A collation, or SQL string comparison function, that compares strings according to the the Swift built-in caseInsensitiveCompare(_:) method.

This collation is automatically added by GRDB to your database connections.

You can use it when creating database tables:
```
let collationName = DatabaseCollation.caseInsensitiveCompare.name
dbQueue.execute(
    "CREATE TABLE persons (" +
        "name TEXT COLLATE \(collationName)" +
    ")"
)
```
Declaration
Swift

public static let caseInsensitiveCompare = DatabaseCollation("swiftCaseInsensitiveCompare") { (lhs, rhs) in
Show on GitHub
localizedCaseInsensitiveCompare
A collation, or SQL string comparison function, that compares strings according to the the Swift built-in localizedCaseInsensitiveCompare(_:) method.

This collation is automatically added by GRDB to your database connections.

You can use it when creating database tables:
```
let collationName = DatabaseCollation.localizedCaseInsensitiveCompare.name
dbQueue.execute(
    "CREATE TABLE persons (" +
        "name TEXT COLLATE \(collationName)" +
    ")"
)
```
Declaration
Swift

public static let localizedCaseInsensitiveCompare = DatabaseCollation("swiftLocalizedCaseInsensitiveCompare") { (lhs, rhs) in
Show on GitHub
localizedCompare
A collation, or SQL string comparison function, that compares strings according to the the Swift built-in localizedCompare(_:) method.

This collation is automatically added by GRDB to your database connections.

You can use it when creating database tables:
```
let collationName = DatabaseCollation.localizedCompare.name
dbQueue.execute(
    "CREATE TABLE persons (" +
        "name TEXT COLLATE \(collationName)" +
    ")"
)
```
Declaration
Swift

public static let localizedCompare = DatabaseCollation("swiftLocalizedCompare") { (lhs, rhs) in
Show on GitHub
localizedStandardCompare
A collation, or SQL string comparison function, that compares strings according to the the Swift built-in localizedStandardCompare(_:) method.

This collation is automatically added by GRDB to your database connections.

You can use it when creating database tables:
```
let collationName = DatabaseCollation.localizedStandardCompare.name
dbQueue.execute(
    "CREATE TABLE persons (" +
        "name TEXT COLLATE \(collationName)" +
    ")"
)
```
Declaration
Swift

public static let localizedStandardCompare = DatabaseCollation("swiftLocalizedStandardCompare") { (lhs, rhs) in
Show on GitHub