problem with Arabic language , when save identities

[alireza-ba]

hi
when i save identities in arabic language The system shows me in display name "? ? ? ? ? ? ?"
like this :


i use sql server 2008 r2
whats problem?
thanks

[JohnDoh]

In the mssql.initial.sql all the text fields are set to Latin1_General_CI_AI, I don't use mssql so may be that is correct but I would expect it to be UTF8 like in mysql. May be try changing the character set in your db then create a new identity and see if it solves the problem.

[alireza-ba]

thanks for reply

can i use  ini_set('mssql.charset', 'UTF-8'); for mssql?

[JohnDoh]

i don't know about that option. I meant the encoding of the tables/fields in the database itself. in mysql its called the Collation.

[alireza-ba]

i change roundcube database  to mysql so It works well

thanks for your help