Results 1 to 3 of 3

Thread: non unicode strings

  1. #1

    Thread Starter
    Junior Member
    Join Date
    Sep 2008
    Posts
    21

    non unicode strings

    Hi

    I am using SQL server 2005 and I want to save into my table arabic strings.
    I have created a field of type nvarchar(100),the save was successful but the arabic string appear like ?????????? ?????.

    What should I do to enable saving arabic strings into my database

    thanks

  2. #2
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,974

    Re: non unicode strings

    Based on previous experience, I expect that they are actually being saved properly, but just aren't being displayed properly.

    If you are checking in the SQL Server tools (like Management Studio), there is likely to be a setting somewhere which allows you to change the font/language settings/etc, which will show it properly. If you are using your own program, we'll need more details to work out what the issue(s) might be.

  3. #3
    Super Moderator FunkyDexter's Avatar
    Join Date
    Apr 2005
    Location
    An obscure body in the SK system. The inhabitants call it Earth
    Posts
    7,957

    Re: non unicode strings

    If it is your own program you're using, what version of VB is it? The VB6 controls don't support unicode (though the underlying string values do).
    The best argument against democracy is a five minute conversation with the average voter - Winston Churchill

    Hadoop actually sounds more like the way they greet each other in Yorkshire - Inferrd

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width