Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 COLLATE problem

Author  Topic 

jauch
Starting Member

8 Posts

Posted - 2008-02-08 : 11:10:58
Hi!

I have an application that access an SQL Server database with collate Turkish_CI_AS.

The application work fine (I have special attention with the 'i'/'I' problem).

We sended our application to some partners, that have the collate of their server as Turkish_CI_AI.

One of the database are alread with this collate, and one is create during installation, with the Turkish_CI_AS collate.

And they get some wird problems, like the message "Item cannot be found in collection corresponding to the requested name or ordinal".

Can someone bring me some "light" please? :)
I'm using SQL Server 2000, some stored procedures and an Delphi 7.0 application.

Thanks in advance and sorry for be so newbe ;)!

jauch
Starting Member

8 Posts

Posted - 2008-02-08 : 11:54:08
One correction...

The database created during the installation use the DEFAULT DATABASE COLLATE.

Son... Any Ideas?

Thanks!
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-02-08 : 21:30:59
Why don't just ask him at home?
Go to Top of Page

jauch
Starting Member

8 Posts

Posted - 2008-02-09 : 10:38:11
Sorry...

I don´t understand... Ask who?

Thanks.
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-02-09 : 12:58:41
Your son.
Go to Top of Page

jauch
Starting Member

8 Posts

Posted - 2008-02-10 : 14:23:43
:)

I mean "so".

Sorry for my poor english and thanks for your very useful help.
Go to Top of Page

jauch
Starting Member

8 Posts

Posted - 2008-02-12 : 11:37:50
Well, the problem was solved.

We ask our partners to install a Service Pack more newer and all is workin well.

They were using SP2, and apparently, SP2 for SQL Server 2000 has some bugs that do this weird behaviour.

Thanks.
Go to Top of Page
   

- Advertisement -