[Sqlalchemy-tickets] Issue #4154: [MSSQL] Incorrect syntax near 'SQL_Latin1_General_CP1_CI_AS' (zzzeek/sqlalchemy)

[Jan K. <iss...@bi...>]

New issue 4154: [MSSQL] Incorrect syntax near 'SQL_Latin1_General_CP1_CI_AS'
https://bitbucket.org/zzzeek/sqlalchemy/issues/4154/mssql-incorrect-syntax-near

Jan Koprowski:

Code:

```
#!python

@compiles(case_insensitive, 'mssql')
def compile_mssql_case_insensitive(element: case_insensitive, compiler: SQLCompiler, **kw: str) -> str:
    return compiler.process(collate(element.clause, 'SQL_Latin1_General_CP1_CI_AS'))
```
Version 1.1.4 produce query:
```
#!sql

[...] COLLATE SQL_Latin1_General_CP1_CI_AS
```

Version 1.2.0 produce query:
```
#!sql

[...] COLLATE [SQL_Latin1_General_CP1_CI_AS]
```

which cause:
**[S0001][102] Incorrect syntax near 'SQL_Latin1_General_CP1_CI_AS'**

error