[Typo3-dev] DBAL

[Martin T. Kutschker]

Dominic Brander wrote:
> 
> 
> Kasper Skårhøj wrote:
> 
>> I use blob fields when data needs to be searched case sensitive. I
>> remember reading on mysql.com (long ago) that the difference between
>> text and blob types is this; That blob fields are searched case
>> sensitively. This is of course important when you want to select for a
>> value in a string which must be matched on the case. That is what we
>> want with all fields containing a list of file names for instance.
>>
>> However I'm not sure if this is still up-to-date knowledge.
> 
> it is still the same nowadays ;-)

Yes. But additionaly you can mark CHAR/VARCHAR/TEXT as BINARY. So it's 
case-insensitive as well. You can also force case-sensitivity in the query.

"Standard text fields" are not case-insensitive in all RDBMS. At least 
it used to be so in Oracle - years ago...

Masi