locked
SQL server not reading arabic RRS feed

  • 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

    Friday, May 28, 2010 9:00 PM

Answers

  • 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
    • Proposed as answer by Olaf HelperMVP Saturday, May 29, 2010 5:50 AM
    • Marked as answer by edhickey Thursday, June 3, 2010 12:24 AM
    Saturday, May 29, 2010 12:51 AM

All replies

  • 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
    • Proposed as answer by Olaf HelperMVP Saturday, May 29, 2010 5:50 AM
    • Marked as answer by edhickey Thursday, June 3, 2010 12:24 AM
    Saturday, May 29, 2010 12:51 AM
  • yes it's working

    thank you sooo much :)

    regards

    Saturday, May 29, 2010 4:32 AM