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

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

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

Hi,

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



Thank you

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.