"format" field in table "date_format_locale" should be case sensitive

Hi, thanks for your continued work on this, however, I tried this patch and Drupal still fails on install with WSOD. The reason I was going fort this option was to try and solve a SQL error with views archive... that's how I found my way to this post.

I ran the update for this and received this error:

PDOException: SQLSTATE[42000]: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Cannot resolve the collation conflict between "Latin1_General_CS_AI" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.: SELECT df.dfid, df.format, df.type, df.locked, dfl.[language] FROM date_formats df LEFT JOIN date_format_locale dfl ON df.format = dfl.format AND df.type = dfl.type ORDER BY df.type, df.format; Array ( ) in _system_date_formats_build() (line 3798 of C:\inetpub\wwwroot\intranet.drupal\modules\system\system.module).

I take my last statement back. You need to run the update with SQLSRV version 1, then you can use SQLSRV version 2. I got ahead of myself :D

I can confirm this patch solved my issues. It seems like a harmless straight forward approach as well.

I'm getting the following error after after going through the Drupal setup:
"SQLSTATE[42000]: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Cannot resolve the collation conflict between "Latin1_General_CS_AI" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation."

OS: Windows Server 2008 R2
DB server: SQL Server 2014
PHP version: 5.4.12
Drupal version: 7.38
Drupal 7 driver for SQL Server and SQL Azure version: 7.x-2.0-beta5

I ran across this site because before setting up Drupal via SQL Server, it says:
"To install this version of the MS SQL Server driver make sure you have this patch in core: https://www.drupal.org/node/2376239"

The problem is that I don't know how to apply the fix to the file:
\modules\system\system.install

Using Notepad++ to edit the system.install file... Can someone explain how to edit on the file?

original system.install file: https://www.dropbox.com/s/i7ksolt4jooce7u/system%20-%20original.install?...
modified system.install file: https://www.dropbox.com/s/eam563904su1w47/system.install?dl=0

Is the modified system.install file correct? All I added was the following to the end of the file:
+ * Convert the 'format' column in {date_format_locale} to case sensitive varchar.
+ */
+function system_update_7080() {
+ $spec = array(
+ 'description' => 'The date format string.',
+ 'type' => 'varchar',
+ 'length' => 100,
+ 'not null' => TRUE,
+ 'binary' => TRUE,
+ );
+ db_change_field('date_format_locale', 'format', 'format', $spec);
+}
+
+/**

Well the best way to apply a patch is using git with documentation found here: https://www.drupal.org/patch/apply

But if you want to just past it in. Make sure to remove the + signs at the beginning of each line. Those are additions by the patch saying they are new lines.

Based on your modified install you did it correctly. Just make sure to run the install after you are using the patched file.

Thanks dobe!

Unfortunately I'm not familiar with git to apply patches :(

I've removed the + signs (forgot to mention that they were removed)

The only thing left is based on the patch:
https://www.drupal.org/files/issues/2376239-format-case-sensitive.patch

It shows another + which I haven't included:
+ 'binary' => TRUE,

I'm not sure where to add this to the system.install file. Would you know where I need to add it to?

Based on your modified version on dropbox. Your almost there! Two things that will cause this to freak out. That is your $spec variable. needs to be a variable. Right now you have it as just spec. The array variable is $spec. Which is getting passed to the db_change_field function.

Also when looking at the "patch" file you can see right where you need to put that other 'binary' => TRUE,

Look at where it says: @@ -800,6 +800,7 @@ function system_schema() { look at the surrounding text around the added line as well. That should give you a pretty good hint of where to put it.

That means at around line 800 in your file or within the "system_schema() function is where you will find the array to add it.

function system_update_7080() {
$spec = array(
'description' => 'The date format string.',
'type' => 'varchar',
'length' => 100,
'not null' => TRUE,
'binary' => TRUE,
);
db_change_field('date_format_locale', 'format', 'format', spec); <----- spec should be $spec
}

I have added the file so you can just download it. But feel like I should let you know some tricks.

Thanks dobe! It's now working :)

For those that don't use or don't know how to use git for patching and using Drupal 7.38..
Edit system.install file from root drupal folder /modules/system

1. Insert an empty line after 802 and paste:

'binary' => TRUE,

2. Insert an empty line after 3161 and paste:

* Convert the 'format' column in {date_format_locale} to case sensitive varchar.
*/
function system_update_7080() {
$spec = array(
'description' => 'The date format string.',
'type' => 'varchar',
'length' => 100,
'not null' => TRUE,
'binary' => TRUE,
);
db_change_field('date_format_locale', 'format', 'format', $spec);
}

/**

Committed to 7.x - thanks!

Likely caused because your using 7.x-2.x of sqlsrv before updating? Could be wrong but I remember having similar issues in #5.

Thanks David. I tested your script and it works great. The order shouldn't matter but I ran your script against my instance, did the latest update to 7.41 (from 7.39), updated the sqlsrv module manually, and then updated my modules. Everything running smoothly.

I patched the file, but then where will I place the paid php mssql? Since there is no driver folder? (Does it just go in the inlcudes/database/sqlsrv?) Or do I link the file with the patch?