SQL server not reading arabic

Question

Hi,

My problem in SQL server 2008

I've database that has many tables

when I try in input Arabic data in some table, after I click 'Enter' I see the data like this: '?????????'

It meens the is't support arabic

if you can help me please

thanks

Answer 1

Arabic is supported.

a) use datatypes that supports unicode e.g. nvarchar or nchar  or nvarchar(max)

b) when you insert data make sure it is preceded with N (National Character)

The following works in SQL 2008

create table test (data nvarchar(100) )
GO

insert into test (data) values (N'مرحبا')
Go

select * from test

Answer 2

yes it's working

thank you sooo much :)

regards