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

[Jesse Vincent]

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

Jesse
-------------- 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