AW: [PHP-DB] mySQL 'Like'-Query (BLOB) always case sensitive

Cool! Thanks, that works perfect! Have fun, Joe -----Ursprungliche Nachricht----- Von: Jurian [mailto:jurphp@unbounded.com] Gesendet: Freitag, 5. Januar 2001 16:01 An: JMaier@maiersoft.de Betreff: Re: [PHP-DB] mySQL 'Like'-Query (BLOB) always case sensitive Convert the field from blob to text (or mediumtext). The blob fields are case sensitive, the text fields are the same size, but case insensitive :-) Hope this helps. Jurian At 15:38 1/5/2001, you wrote: >Hi all, > >i'd like to know, whether it's possible to perform a case-INsensitive >"like"-query against a mySQL-BLOB field. > >E.g.: > >This one IS case-sensitive (myBlob being of BLOB-type): >"select myBlob from MyTable where myBlob like '%bad%'" > >but this one's NOT case-sensitive (myVarChar being of VARCHAR-type): >"select myVarChar from MyTable where myVarChar like '%good%'" > >I do want to build a fulltext-search-engine and cannot use the >MATCH-features of the latest mySQL engine. > > >Any ideas? > >Thanks, >Joe > > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net >For additional commands, e-mail: php-db-help@lists.php.net >To contact the list administrators, e-mail: php-list-admin@lists.php.net