[jifty-devel] Jifty::DBI case sensitivity?

Jesse Vincent jesse at bestpractical.com
Fri Sep 8 14:29:30 EDT 2006

On Aug 8, 2006, at 9:00 PM, Todd Chapman wrote:

> If I want to specify a column as case-insensitive in
> my schema, how do I specify that? I have stored e-mail
> addresses in mixed case but would need to to retrieve
> them from user input, lowercased if necessary.
> I don't think I should have to care what DB I am using.

Indeed you should not.

> Am I on the wrong track?

You're not. I think we want to add an "is case sensitive" attribute  
to jifty model columns. We probably also want a model-wide default.

> Is my desire to be case preserving bad?

No. it's good. We've been faking it when we've needed it. and that  
keeps biting us just a little bit.

> -Todd

-------------- next part --------------
A non-text attachment was scrubbed...
Name: PGP.sig
Type: application/pgp-signature
Size: 186 bytes
Desc: This is a digitally signed message part
Url : http://lists.bestpractical.com/pipermail/jifty-devel/attachments/20060908/ceb8fbd8/PGP-0001.pgp

More information about the jifty-devel mailing list