I have a problem with collation of database

Discussion in 'Databases' started by malbar99, May 16, 2006.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. malbar99

    malbar99

    I have a problem with my SQL2000 ,
    In one of my site pages I use a form with textarea to post data into my db.
    The Arabic char's is not posted correctly into my db.
    I read some article about the collation of database.
    Can you tell me what is the existing collation setting, and if I can change my self to be
    SQL_Latin1_General_CP1256_CI_AS
     
    malbar99, May 16, 2006
    #1
  2. Bruce

    Bruce DiscountASP.NET Staff

    You should be able to change the collation setting on your DB. There should be some post in this forum about this topic.

    Also make sure you are using nvarchar as the data type rather than varchar if you need to store UTF8 char.

    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
    Bruce, May 16, 2006
    #2
  3. malbar99

    malbar99

    Thanks,
    I think the problem was in field type I was use text type but I change it with ntext.
    it is working fine now ![​IMG]
     
    malbar99, May 17, 2006
    #3
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page