How to change the DB collation

[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

[bruce]

Uri,

try this

ALTER DATABASE [DBName] COLLATE Hebrew_CI_AS

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


[b]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">