jmjyiannis
Member
- Joined
- Jun 27, 2004
- Messages
- 16
- Programming Experience
- Beginner
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???????????????
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???????????????
