CharacterSet mismatch

windows-1252' is not a database character set it is a Windows browser and html character set.

Semantics. Is all I know is that with PHP 5.x and the mssql driver I used to be able to specify 'windows-1252' as the database character set in the configuration for the database with CodeIgniter. Now (with PHP 7.x and sqlsrv driver) the database configuration for CodeIgniter no longer accepts (throws a database exception) 'windows-1252' as an option. Specifying 'windows-1252' as the database charset configuration worked before. For CodeIgniter with a sqlsrv driver this isn't a valid option.

If we want to migrate to PHP 7.x with CodeIgniter I am only asking what the database configuration charset should be to mimic the "old" behavior (with PHP 5.x and mssql driver)?

Pretty sure I wrote a reply yesterday ... maybe I forgot to actually hit the Post button.

Read this: https://blogs.msdn.microsoft.com/brian_s...racterset/
SQLSRV_ENC_CHAR is also the default in CI if you don't specify a charset in the config.