Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread Useful Script for Altering Table Column Collations
Fri, Jun 26 2015 8:11 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

A customer just asked about this, and I thought it would be useful to share.
It's a script that changes all of the collations in a database from ANSI to
ANSI_CI.  The key here is the CreateSQL system information column, which
makes this type of thing possible.

Tim Young
Elevate Software
www.elevatesoft.com



Attachments: changecollationscript.SQL
Fri, Jun 26 2015 3:13 PMPermanent Link

Alex Albergo

Hawkeye Technology LLC

When clicking on the link I get the following error:

Internal database error:

Invalid attachment encoding

You may retry this operation by using the Back button in your web browser to return the previous page.
Wed, Jul 8 2015 12:32 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Alex,

<< When clicking on the link I get the following error: >>

Sorry about that.  Here's an updated attachment that will work.

Meanwhile, I need to fix this issue - the encoding used was quoted
printable, which should be acceptable.

Thanks,

Tim Young
Elevate Software
www.elevatesoft.com



Attachments: changecollation.zip
Image