Trailing spaces are dropped in varchar fields, I believe. Here's the reference:
VARCHAR values are not padded when they are stored. Handling of trailing spaces is version-dependent. As of MySQL 5.0.3, trailing spaces are retained when values are stored and retrieved, in conformance with standard SQL. Before MySQL 5.0.3, trailing spaces are removed from values when they are stored into a VARCHAR column; this means that the spaces also are absent from retrieved values. From: http://dev.mysql.com/doc/refman/5.0/en/char.html On Oct 25, 1:44 pm, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > Here's my problem. In my database firstname and lastname are required > fields. If you enter a space in the field, it will let you submit it > (expected), but when you go to edit the field the space is gone (not so > expected). This is causing me some problems and I'm not sure if it's > something I can fix with a few lines of code or if this is a bug I > should report. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php -~----------~----~----~----~------~----~------~--~---