[TYPO3-dam-devel] RFC: Bugfix 7443: db field tx_dam_mm_ref.ident to short

[Michiel Roos]

Hi,

I vote for TEXT.

http://dev.mysql.com/doc/refman/5.0/en/blob.html
BLOB columns are treated as binary strings (byte strings). TEXT  
columns are treated as non-binary strings (character strings). BLOB   
columns have no character set, and sorting and comparison are based on  
the numeric values of the bytes in column values. TEXT columns have a  
character set, and values are sorted and compared based on the  
collation of the character set.

The reason for this being 'less fuss' when setting up on postgres.  
Postgres will turn all blob* into bytea fields.

The characters that go in this field are normal alphanumeric  
characters aren't they?

On May 2, 2008, at 4:56 PM, Benjamin Mack wrote:

> Hey guys,
>
> I agree with Michael here.
>
> Question (since we had this in the core as well): Should we use TEXT  
> or
> BLOB because of the charset issues? I don't care really, as the values
> will be DB fields and (hopefully) will not contain any strange values
> that are messed up if somebody changed the DB charset &| collation.
>
> Other question: If we cast a mySQL field from varchar to text, is the
> transition smooth (are all values kept etc.)?
>
> As soon as we agreed on BLOB / TEXT, I'll create another patch, ok?
>
> BTW: This should go in 1.0 and trunk IMHO.
>
>
> -- 
> greetings,
> benni.
> -SDG-
> _______________________________________________
> Before posting to this list, please have a look to the posting rules
> on the following websites:
>
> http://typo3.org/teams/core/core-mailinglist-rules/
> http://typo3.org/development/bug-fixing/diff-and-patch/
> _______________________________________________
> TYPO3-team-dam mailing list
> TYPO3-team-dam at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-team-dam


Met vriendelijke groet,

Michiel Roos

Netcreators BV :: creation and innovation
www.netcreators.com

Interesse in werken bij Netcreators?
http://www.netcreators.com/bedrijf/vacatures/