[Typo3-dev] DBAL

[Dominic Brander]

Martin T. Kutschker wrote:

> 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.

CHAR/VARCHAR can be binary. but TEXT can't! that's why you have to use 
BLOB which is in fact only a binary TEXT field...

> 
> "Standard text fields" are not case-insensitive in all RDBMS. At least 
> it used to be so in Oracle - years ago...
> 
> Masi
> 
> _______________________________________________
> Typo3-dev mailing list
> Typo3-dev at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-dev
> 

-- 
dominic
________________________________________________________________________
dominic brander - snowflake productions gmbh
http://www.snowflake.ch