SQL_Latin1_General_CP850_CI_AS about tiberius HOT 2 CLOSED

As a work around, you can change the COLLATE in your query. As far as I understand the source code, this error arises when the encoding is not supported by Rust (not by tiberius). Also, instead of an error, we might be able to map to another encoding that would work?

SELECT
Name COLLATE SQL_Latin1_General_CP1_CI_AS AS Name,
Address COLLATE SQL_Latin1_General_CP1_CI_AS AS Address,
ZipCode COLLATE SQL_Latin1_General_CP1_CI_AS AS ZipCode,
City COLLATE SQL_Latin1_General_CP1_CI_AS AS City,
Country COLLATE SQL_Latin1_General_CP1_CI_AS AS Country,
...
FROM Partners
ORDER BY Balance DESC;

from tiberius.

To be honest, I solved the problem by not using tiberius and went back to SQLx 0.6.3, which still has MS-SQL-Support. The underlying database is a mess and I don't blame tiberius for this.

from tiberius.