Category Archives: Uncategorized

SQL Cannot resolve the collation conflict between “xxx” and “xxx” in the equal to operation – Use COLLATE DATABASE_DEFAULT

When joining 2 tables from different databases, the following error might occur: Cannot resolve the collation conflict between “SQL_Latin1_General_CP1_CI_AS” and “Danish_Norwegian_CI_AS” in the equal to operation. This can happen when the 2 databases is created with different collations (language settings). … Continue reading

Posted in Uncategorized | Leave a comment

Using Notepad++ to mask email address for GDPR reasons

With the new GDPR rules enforced in Europe, shipping log files containing personal information (including email addresses) to 3rd parties are a no-go. Unless you have a signed controller/processor agreement of course, which no one has, as this gives them legal … Continue reading

Posted in Uncategorized | Tagged , , , , | Leave a comment

showModalDialog returnValue is undefined in Google Chrome

For some reason, when using a Javascript showModalDialog from an ASP.NET project, Google Chrome will return an empty (“undefined”) returnValue. This error has been known by the Google Chromium team since 2010, and they have yet to fix it. Fortunately … Continue reading

Posted in Uncategorized | Tagged , , , | 4 Comments