For the sake of the question, let's just assume my DB is case-sensitive. FYI, I'm using Postgres 8.3.4 which is always case-sensitive (as far as I know)..
Mike On Sat, Jun 12, 2010 at 7:14 PM, Patrick Steele <[email protected]> wrote: > It depends on the server. Well, in MS SQL Server 6 and I think up to > 7 it was server-specific (you could define case sensitive or > case-insensitive). Starting with SQL 2000, it could be done on a > per-database setting. > > --- > Patrick Steele > http://weblogs.asp.net/psteele > > > > On Sat, Jun 12, 2010 at 8:41 PM, Tuna Toksoz <[email protected]> wrote: >> isn't sql case insensitie most of the time? >> Tuna Toksöz >> Eternal sunshine of the open source mind. >> >> http://devlicio.us/blogs/tuna_toksoz >> http://tunatoksoz.com >> http://twitter.com/tehlike >> >> >> >> >> On Sun, Jun 13, 2010 at 2:39 AM, Mike Christensen <[email protected]> >> wrote: >>> >>> I need to lookup a user by Alias, however I need this to be case >>> insensitive. Basically I just need to know if the row exists or not. >>> Here's what I'm doing now: >>> >>> return (User.FindFirst(new >>> NHibernate.Criterion.InsensitiveLikeExpression("Alias", alias)) != >>> null); >>> >>> However, I don't like this because it's not gonna use any indexes. >>> I've created an index on LOWER(Alias), thus I want the query generated >>> to be: >>> >>> SELECT COUNT(*) FROM Users WHERE LOWER(Alias) = 'myvalue'; --This will >>> be very very fast. >>> >>> Any ideas on how to generate this query with ActiveRecord? Thanks!! >>> >>> Mike >>> >>> -- >>> You received this message because you are subscribed to the Google Groups >>> "Castle Project Users" group. >>> To post to this group, send email to >>> [email protected]. >>> To unsubscribe from this group, send email to >>> [email protected]. >>> For more options, visit this group at >>> http://groups.google.com/group/castle-project-users?hl=en. >>> >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Castle Project Users" group. >> To post to this group, send email to [email protected]. >> To unsubscribe from this group, send email to >> [email protected]. >> For more options, visit this group at >> http://groups.google.com/group/castle-project-users?hl=en. >> > > -- > You received this message because you are subscribed to the Google Groups > "Castle Project Users" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/castle-project-users?hl=en. > > -- You received this message because you are subscribed to the Google Groups "Castle Project Users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/castle-project-users?hl=en.
