> Looks like this is version dependant. > MySQL Version 5.1 says: > "VARCHAR values are not padded when they are stored. Trailing spaces > are retained when values are stored and retrieved, in > conformance with standard SQL"
> Version 4.1 says: > "VARCHAR values are not padded when they are stored. Trailing spaces > in MySQL version up to and including 4.1 are removed from values > when stored in a VARCHAR column; this also means that the spaces > are absent from retrieved values. " So maybe you would need: $add_a_trailing_space_to_spam_subject_tag_and_spam_subject_tag2_for_the_older_non-standard-SQL-compliant_versions_of_MySQL :) Gary V ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click _______________________________________________ AMaViS-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
