Set collation in SQL scripts - Upgrading problems

BugNET Forums

Forum Support Upgrading probl... Set collation in SQL scripts

3/27/2007 3:21 AM

	Frost
2 posts

Set collation in SQL scripts

Hello!

My server collation is Cyrillic_General_CI_AS and default database collation is Cyrillic_General_CI_AS.

Why do you use collation SQL_Latin1_General_CP1_CI_AS in scripts?

Why do not you use collation database_default?

3/27/2007 9:01 AM

	BC
40 posts

Re: Set collation in SQL scripts

I had a similar problem,
you can try to solve it using this query:

"alter database BugNET collate SQL_Latin1_General_CP1_CI_AS"

Where BugNET is the database name of the database you have used for your BugNET installation.

3/27/2007 9:42 AM

	admin
641 posts
bugnetproject.com

Re: Set collation in SQL scripts

Frost wrote

Hello!

My server collation is Cyrillic_General_CI_AS and default database collation is Cyrillic_General_CI_AS.

Why do you use collation SQL_Latin1_General_CP1_CI_AS in scripts?

Why do not you use collation database_default?

I used redgate sql compare to make the upgrade script and I guess this option was turned on. I am not too familiar with collations but I am assuming if I remove the SQL_Latin1_General_CP1_CI_AS that it will use the database default?

Davin Dubeau
BugNET - Core Developer

3/28/2007 12:37 AM

	Frost
2 posts

Re: Set collation in SQL scripts

Davin wrote
I used redgate sql compare to make the upgrade script and I guess this option was turned on. I am not too familiar with collations but I am assuming if I remove the SQL_Latin1_General_CP1_CI_AS that it will use the database default?

Yes. Do not set collation in script.

3/28/2007 3:11 AM

	BC
40 posts

Re: Set collation in SQL scripts

Davin,

in the scripts:
0.62.sqldataprovider.sql &
0.66.sqldataprovider.sql

you also have collations set,
I don't know if this is any problem?

Page 1 of 2

Forum

Support

Upgrading probl...

Set collation in SQL scripts

Forum Policy

These Discussion Forums are dedicated to the discussion of the BugNET issue tracker.

For the benefit of the community and to protect the integrity of the project, please observe the following posting guidelines:
1. No Advertising.
2. No Flaming or Trolling.
3. No Profanity, Racism, or Prejudice.
4. Site Moderators have the final word on approving/removing a thread or post or comment.
5. English language posting only, please.