[soci-users] UTF-8 Unicode with ODBC / SQL Server

[Andrew Grafham]

Hi,

Is there any way of using SOCI to insert UTF-8 data into an nvarchar column
in SQL server using the ODBC backend? I've found that with Postgresql I can
use "set client_encoding to 'UTF8'", and in MySQL I can use "Set NAMES
utf8mb4" and then that seems to work using a std::string that contains UTF8
encoded data. But there doesn't seem to be any similar option in SQL Server
that I can find.

Thanks

Andy