RE: Turkish_CI_AS database trying to open a table

Tech-Archive recommends: Fix windows errors by optimizing your registry



It turns out that somewhere in the table there was a collumn that had a Null
collation.
When that was fixed, I was able to get the results I wanted ... :)

"Constantinos Petridis" wrote:

> I have an SQL server 2000 setup with english local and I have created a
> database with the Turkish_CI_AS local.
> Using the SQL Query Analyser I am able to use the database.
> When I am trying to do the same using the .NET Framework 1.0, I get the
> following error:
> The Collation specified by SQL Server is not supported.
>
> The same error is produced when I try to drag 'n drop a table, from that
> database, to my form designer in Visual Studio 2002.
>
> Does the .NET Framework supports the specified local? If not is there a list
> of not supported locals (using the SQLClient) that SQL Server 2000 supports?
>
> Is there a workaround for this problem?
.



Relevant Pages

  • Turkish character problem in SQL Server 2000
    ... I'm trying to migrate a Sybase SQL Anywhere database to SQL server 2000. ... have a problem when I choose "Turkish_CI_AS" as the database collation: ... When I use lowercase Ithere's no error. ...
    (microsoft.public.sqlserver.programming)
  • Re: Different collations in a database
    ... The SQL Server itself is correctly setup to use Finnish_Swedish_CI_AS, ... the fields back to database default. ... database with the correct collation. ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • RE: Advice on Create a SQL Server
    ... Use the default collation. ... Mode" - it depends on how you will be connecting to your database. ... domain, and running on a windows domain account, it is better to run under ... to SQL Server using a username/password. ...
    (microsoft.public.sqlserver.setup)
  • Re: SharePoint Collation
    ... my SharePoint farm config database and I can create it using ... and when I tried recreating it with the collation for SharePoint ... CREATE DATABASE failed. ... Is SQL Server throwing this error to stop me from shooting myself in the ...
    (microsoft.public.sqlserver.server)
  • Re: Database collation error after moving to a remote sql server
    ... > I've recently my SMS 2003 database to a remote sql server (it was ... > Server]Cannot resolve collation conflict for equal to operation. ... The char, varchar, text, nchar, nvarchar, or ntext system data types, ...
    (microsoft.public.sms.setup)