Hello Experts,


I have a problem. I have a sql database that is with collation of latin (particularly, SQL_Latin1_General_CP1_CI_AS) but I want to have greek language in the database. trying to change the collation to Greek_BIN, the SQL query (ALTER DATABASE <databasename> COLLATE Greek_BIN) returned error.

Trying to change only in a table the collation to -> windows collation "Greek", it was acceptable but when I try to change the content of a column to greek or to insert new Greek data..... it converts it to latin again!

Any suggestions???????????????