Change the language for Sql Server 2008
-
Dear All 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 . T.h :rose:
Thaer
-
Dear All 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 . T.h :rose:
Thaer
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.Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] They hate us for our freedom![^]
-
Dear All 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 . T.h :rose:
Thaer
Open your Phpmyadmin and you can find the language change option there.......