Sybase Error – ‘%1’ cannot be used as the NCHAR collation: only UCA and UTF8BIN may be used

In this blog post, you’ll learn more about the Sybase Error ‘%1’ cannot be used as the NCHAR collation: only UCA and UTF8BIN may be used and the reason for receiving this error

Sybase SQL Error Message

‘%1’ cannot be used as the NCHAR collation: only UCA and UTF8BIN may be used

Reason for this Error

The specified collation cannot be used as the NCHAR collation. NCHAR always uses UTF-8, so the collation must be either UCA or UTF8BIN.