sql2000 colleation

Discussion in 'Databases' started by malbar99, Nov 18, 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

    Hi,
    I have a sql2000 db on the internet, when I try to take a backup in my local machine I face a problem.
    my problem that the result table contains and readied Arabic chars like this one ?C?? C????? .
    which is not the correct and can not be reading.
    I try to change the collation.
    In source it was SQL (sql_latin1_General_CP1256_CS_AS)
    Also I try to make a backup and restore it in my local machine.
    but nothnig been changed
    The internet server is not Arabic, while my local machine has wind2003 server Arabic support
    Can any super hero [​IMG] help me solving this problem?
     
    malbar99, Nov 18, 2006
    #1
  2. JorgeR

    JorgeR DiscountASP.NET Staff

    malbar99


    first, make sure that all transactions are close and set the database into single user mode:


    Alter database <database name> set single_user with ROLLBACk IMMEDIATE;


    Next, you will need to change the collation of the database: Alter <database name> COLLATE <collation name> ;


    change back to multiuser - Alter database <database name> set Multi_User







    junior

    DiscountASP.NET

    www.DiscountASP.NET
     
    JorgeR, Nov 21, 2006
    #2
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