Re: Case insensitivity, and option?

mlw wrote:
> ...
>select * from table where field = 'blah';
>gave the same results as:
>select * from table where field = 'BLah';
>
>I was shocked. (a) because I know a lot of my code could be easier to
>write
> ...

select * from table where field ILIKE 'blAH'; -- ;-)

is almost as easy :-)

PS: no, don't do this if you want portability. I think the charset
idea's a better one.

Ron