Hi there, this is my first post here.
Perhaps you already have seen and have explained this.
I had a database in SQL Server 2000, as Latin_SQL collation and had problems with my native (greek).
What I did, is after googling around, to use this :
ALTER DATABASE myDB COLLATE Greek_CI_AS
Changed from varchar to nvarchar the field,
Restarted the server
and now I see the Greek.
What bugs me now, is that every field still reports, if I click the design table option, SQL_LATIN just like before!
To finish up, I altered the database, I changed the nvarchar, I see Greek, I didn;t do migration of data or rebuild of master or anything more bizarre, and it WORKS?
When this solution blows?
(The database is in cooperation with a .net application)
Thank you in advance...