Collation Problem of the DataTierGenerator is easy to solve!

I just want to say thanks to this guy because he found a solution I just was trying to do. When you are using the DataTierGenerator for Enterprise Library 2.0 and try to connect to a SQL database that has a Collation different to “Latin1_General_CI_AS” it just can’t work. The reason is because the function “FN_LISTEXTENDEDPROPERTY” force the use of “Latin1_General_CI_AS”. To solve this problem we need to just specify the collation in our Schema queries.

If you try to read this post you will find where exactly.

About Haaron Gonzalez

Consultant devoted to design mission critical solutions for companies where collaboration and communication are their strategic investment. Recognized as a Microsoft Most Valuable Professional in ASP.NET since 2005 and SharePoint Server since 2009.
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *