Should we trim value in textbox before saving into database [closed]

Question

Suppose that there are textbox First name and Last Name. Should we trim it before entering it into database For example

First name "John      " -> trim to "John"

Last name  "Lennon  " -> trim to "Lennon"

I am not convinced this is really UX? The answer is yes, but not for UX reasons.
@SarawutPositwinyu - not really. The answer is probably "yes", but there may be cases where you don't want to trim.
@SarawutPositwinyu StackOverflow would be better IMO. But it might depend why you are asking.
This is off-topic for UX.SE and isn't detailed enough to be migrated over to StackOverflow so it's been closed off here.

JonW · Accepted Answer · 2012-05-17 08:58:37Z

up vote 1 down vote accepted

Absolutely...always trim data before storing it. (P.S. This question really belongs on StackOverflow rather than here)

edited May 17 '12 at 8:58

JonW♦
11.4k63172

answered May 17 '12 at 8:24

techtheatre
1913

closed as off topic by Schroedingers Cat, Roger Attrill, ChrisF, JonW♦ May 17 '12 at 8:57