List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:February 4 2000 4:44am
Subject:Re: making REPLACE case insensitive
View as plain text  
At 8:05 PM -0800 2000-02-03, Mark Maggelet wrote:
>No, it's not. Unless it's a 3.23 feature, a TEXT can't even have an index.


Yes.  As of, uh, 3.23.2 I think, both TEXT and BLOB fields can be
indexed.  The restriction is that you *must* specify a prefix length
for the key.  E.g.,  CREATE TABLE t (t TEXT NOT NULL, UNIQUE KEY (t(10)))

>
>***********************************************
>
>On 2/3/00 at 9:46 PM Paul DuBois wrote:
>
>>At 6:59 PM -0800 2000-02-03, Mark Maggelet wrote:
>>>the column is a TEXT which is case-insensitive for sorting and comparison,
>>>but REPLACE seems to match things case-sensitively.
>>
>>
>>That will happen if your TEXT column is not a PRIMARY KEY or UNIQUE
>>index.  Is it?
>>
>>
>>>
>>>***********************************************
>>>
>>>On 2/3/00 at 6:11 PM Paul DuBois wrote:
>>>
>>>>At 4:02 PM -0800 2000-02-03, Mark Maggelet wrote:
>>>>>hi there,
>>>>>Can someone suggest a way to make Replace() be case insensitive?
>>>>
>>>>
>>>>Make your columns case insensitive.
>>>>
>
>  >>>--
>  >>  >Paul DuBois, paul@stripped


-- 
Paul DuBois, paul@stripped
Thread
making REPLACE case insensitiveMark Maggelet4 Feb
  • Re: making REPLACE case insensitivePaul DuBois4 Feb
    • Re: making REPLACE case insensitiveMark Maggelet4 Feb
      • Re: making REPLACE case insensitivePaul DuBois4 Feb
        • Re: making REPLACE case insensitiveMark Maggelet4 Feb
          • Re: making REPLACE case insensitivePaul DuBois4 Feb