I Change the language for the database in Sql Server 2008 ( To Arabic_CI_AS )via the optional tab in database proprieties .
but when i Insert new record( have Arabic Text) in any table the text change to ???? .
thanks for any body help me .
Mycrofts answer (the one on the same question) is still correct[^].
PIEBalds argument is also a good one; write a small console-app and fetch the data using .NET, as older apps might have trouble and try and assign a codepage to it.
It'd be helpful if you at least stated whether you tried their answers. If they failed, I'd like to know "how" - did you get an error message? A different result than expected?
"Arabic_CI_AS" is not a language, but a collation. It's a relic from past times, and the UTF-datatypes (the ones starting with an N) can store any character that you put in there.
Nvm, it's a crosspost, reposted on the same day. This is why crossposting is so confusing and annoying.