mssql-ts-ffi

Appearance

mssql-ts-ffi / utf8Column

Function: utf8Column() ​

utf8Column(name, typeDef, collation?): string

Defined in: collation.ts:34

Generate a column definition with UTF-8 collation.

Parameters ​

name ​

string

typeDef ​

string

collation? ​

string = UTF8_COLLATIONS.CI_AS

Returns ​

string

Example ​

ts
await cn.execute(`
  CREATE TABLE Posts (
    ${mssql.utf8Column("Title", "varchar(200)")},
    ${mssql.utf8Column("Body", "varchar(max)")},
    ${mssql.utf8Column("Slug", "varchar(100)", mssql.UTF8_COLLATIONS.BIN2)}
  )
`);