Re: Unique Case Sensitivity

2008-07-16 Thread Jeff FW
Check out: http://dev.mysql.com/doc/refman/5.0/en/case-sensitivity.html However, instead of dealing with it that way, you could also use this: http://www.djangoproject.com/documentation/db-api/#iexact -Jeff On Jul 16, 5:54 am, "Peter Melvyn" <[EMAIL PROTECTED]> wrote: > On Wed, Jul 16, 2008 at

Re: Unique Case Sensitivity

2008-07-16 Thread Peter Melvyn
On Wed, Jul 16, 2008 at 3:06 AM, Russell Keith-Magee <[EMAIL PROTECTED]> wrote: > I strongly suspect that the problem here is MySQL - in particular, the > collation on your text field. There are certain default setups for > MySQL which will result in all text fields being case insensitive. > This

Re: Unique Case Sensitivity

2008-07-15 Thread Russell Keith-Magee
On Wed, Jul 16, 2008 at 8:59 AM, Chris <[EMAIL PROTECTED]> wrote: > > I've run into a strange situation. I have a MySQL database with a > table called Feature, with a unique column called text. > > Given some text, I want to save a new record if hasn't been entered, > or retrieve the existing reco

Unique Case Sensitivity

2008-07-15 Thread Chris
I've run into a strange situation. I have a MySQL database with a table called Feature, with a unique column called text. Given some text, I want to save a new record if hasn't been entered, or retrieve the existing record if it already exists. Oddly enough, this code fails if the current text ha