[prev in list] [next in list] [prev in thread] [next in thread]
List: lon-capa-cvs
Subject: [LON-CAPA-cvs] cvs: loncom /interface loncoursedata.pm
From: matthew <lon-capa-cvs () mail ! lon-capa ! org>
Date: 2004-04-30 14:36:52
Message-ID: cvsmatthew1083335812 () cvsserver
[Download RAW message or body]
matthew Fri Apr 30 10:36:52 2004 EDT
Modified files:
/loncom/interface loncoursedata.pm
Log:
Bug 2954: MySQL CHAR/VARCHAR are case insensitive by default, so use
'BINARY' to make them behave the way we expect.
Index: loncom/interface/loncoursedata.pm
diff -u loncom/interface/loncoursedata.pm:1.131 loncom/interface/loncoursedata.pm:1.132
--- loncom/interface/loncoursedata.pm:1.131 Tue Apr 6 15:02:00 2004
+++ loncom/interface/loncoursedata.pm Fri Apr 30 10:36:52 2004
@@ -1,6 +1,6 @@
# The LearningOnline Network with CAPA
#
-# $Id: loncoursedata.pm,v 1.131 2004/04/06 19:02:00 matthew Exp $
+# $Id: loncoursedata.pm,v 1.132 2004/04/30 14:36:52 matthew Exp $
#
# Copyright Michigan State University Board of Trustees
#
@@ -580,7 +580,7 @@
restrictions => 'NOT NULL',
auto_inc => 'yes', },
{ name => 'part',
- type => 'VARCHAR(100)',
+ type => 'VARCHAR(100) BINARY',
restrictions => 'NOT NULL'},
],
'PRIMARY KEY' => ['part (100)'],
@@ -595,16 +595,16 @@
restrictions => 'NOT NULL',
auto_inc => 'yes', },
{ name => 'student',
- type => 'VARCHAR(100)',
+ type => 'VARCHAR(100) BINARY',
restrictions => 'NOT NULL UNIQUE'},
{ name => 'section',
- type => 'VARCHAR(100)',
+ type => 'VARCHAR(100) BINARY',
restrictions => 'NOT NULL'},
{ name => 'status',
- type => 'VARCHAR(15)',
+ type => 'VARCHAR(15) BINARY',
restrictions => 'NOT NULL'},
{ name => 'classification',
- type => 'varchar(100)', },
+ type => 'VARCHAR(100) BINARY', },
{ name => 'updatetime',
type => 'INT UNSIGNED'},
{ name => 'fullupdatetime',
@@ -629,7 +629,7 @@
type => 'MEDIUMINT UNSIGNED',
restrictions => 'NOT NULL' },
{ name => 'part',
- type => 'VARCHAR(100)',
+ type => 'VARCHAR(100) BINARY',
restrictions => 'NOT NULL'},
{ name => 'solved',
type => 'TINYTEXT' },
@@ -709,7 +709,7 @@
{ name => 'awarddetail',
type => 'TINYTEXT' },
# { name => 'message',
-# type => 'CHAR' },
+# type => 'CHAR BINARY'},
{ name => 'response_specific',
type => 'TINYTEXT' },
{ name => 'response_specific_value',
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic