StrataFrame Forum » StrataFrame Database Deployment Toolkit » Database Deployment Toolkit (How do I?) » Setting Collation for a New Database Install

Setting Collation for a New Database Install

Geoff Hirst — Tue, 25 Aug 2009 11:52:23 GMT

Chaps,

Can I set the collation for a new database anywhere? If not, could this be added?

In the meantime, can I work around it by using a pre-deployment script?

thanks in advance

Geoff

RE: Setting Collation for a New Database Install

Trent L. Taylor — Tue, 25 Aug 2009 11:52:23 GMT

Database. If you have field level collation issues then you will need to write a sproc to update each individual column to get that collation back in alignment. Once this is done, then the database collation should take effect from that point forward. We actually had to do this in the field the other day to correct a database that had been changed somehow for certain fields. Once we reset the individual fields again, then we were back on track.

RE: Setting Collation for a New Database Install

ChanKK — Mon, 24 Aug 2009 20:12:05 GMT

Hi,
Would this feature auto correct the existing field collation or only as database default collation?

Thank you

RE: Setting Collation for a New Database Install

Trent L. Taylor — Mon, 11 May 2009 08:50:56 GMT

Yeah, it was "fun" to get this working! :D

I will try to do a build today and get it posted.

RE: Setting Collation for a New Database Install

Geoff Hirst — Mon, 11 May 2009 08:46:44 GMT

Trent,

Thanks man, appreciated.

I did overcome it with a script also, however I found that redeploying caused major issues, unless I manually dropped the DB before hand.

Geoff

RE: Setting Collation for a New Database Install

Trent L. Taylor — Mon, 11 May 2009 08:38:51 GMT

Actaully we ran into this just the other day ourselves and had to write a script to make sure that all databases are updated. We did this in a pre-deploymkent script to make sure that our collation. We have already added this functionality to the DDT, though, and will be in the next update we post.