"CharacterSet" => SQLSRV_ENC_CHAR on Linux

[gruyoman]

In the Windows server "CharacterSet" => SQLSRV_ENC_CHAR is the default setting.
In Linux SQLSRV_ENC_CHAR exists or not? Even when I set it, it uses UTF-8.

Thanks

[Hadis-Knj]

@gruyoman SQLSRV_ENC_CHAR in linux only works with ASCII characters, and you should set the character set to utf-8 for non-ASCII characters. please see https://github.com/Microsoft/msphpsql#limitations

[Hadis-Knj]

@gruyoman is there anything else that we can help you in?

[gruyoman]

I've seen that in linux SQLSRV_ENC_CHAR behaves exactly like UTF-8. That means that SQLSRV_ENC_CHAR actually doesn't exist. The problem is that there isn't compatibility between windows and linux web application with SQLSRV_ENC_CHAR.
However I have one question: to use unicode chars i have to use N' prefix for nchar, nvarchar and ntext value. Is there any possibility to set something in php or apache to skip N' prefix because we have multidatabase application.
Thank you

[lilgreenbird]

hi @gruyoman, that is not possible and as @Hadis-Fard mentioned above it's a limitation in the Linux driver. I have created a feature request for this we will look into supporting this in future releases.

[gruyoman]

Ok, thank you