How to change the DB collation

Discussion in 'Databases' started by sittan, May 4, 2004.

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

    sittan

    Hello,
    I would like to know how can in use different collation in my
    database on the server.
    I need to use Hebrew_CI_AS
    collation and I don't know how can I change it in the Database.
    for now, I get all my text (Hebrew fonts) in the Database as question
    marks.
    I know that Hebrew_CI_AS collation will solve this.
    Thanks,
    Uri
     
    sittan, May 4, 2004
    #1
  2. Bruce

    Bruce DiscountASP.NET Staff

    Uri,

    try this

    ALTER DATABASE [DBName] COLLATE Hebrew_CI_AS

    See http://www.databasejournal.com/features/mssql/print.php/2013741 for more details.


    quote:Originally posted by sittan

    Hello,
    I would like to know how can in use different collation in my
    database on the server.
    I need to use Hebrew_CI_AS
    collation and I don't know how can I change it in the Database.
    for now, I get all my text (Hebrew fonts) in the Database as question
    marks.
    I know that Hebrew_CI_AS collation will solve this.
    Thanks,
    Uri
    </blockquote id="quote"></font id="quote">
     
    Bruce, May 4, 2004
    #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