Turkish Language support for MSSQL?

I post some data through ASP to MSSQL server in Turkish language. Although I've correct codepage settings, MSSQL returns with non turkish characters like [ ý -> i, þ -> s ..]
Is it possible to add Turkish Language Support for MSSQL?

Thanks in advance.

[hohios]

The problem is with the "COLLATION" setting of each database.
Matrix can change that setting of your database, but need to post a ticket to them.

The sql command is "ALTER DATABASE name_of_database COLLATE TURKISH_CI_AS"
To be capable of using "ALTER" command, you must have "db_owner" permissions. H-sphere doesn't allow this cause then you can change the MB size of the database.

But Psoft must find a workaround because, everytime we (or customer of ours) create an mssql database, must put a ticket requesting the change of collation setting. That means a time delay (see US-Turkish time difference, etc)

hi hohios, thank you for your time

i have read your topic about this event before, now i'm waiting response from the ticket support, cause they sad, they have a problem with my database.

ALTER DATABASE *** COLLATE TURKISH_CI_AS
"But its giving an error. not sure if its because you have numbers in youyr DB name or not. "

i also asked, if we have to create ticket and let set the language anytime when we create new db's.. i think this is big delay problem too..

[admin]

If you want something made in to the CP for this i would say head over to psoft.net and see if they can add it in soon.. It would save me a lot of time as well..