MySQL Forums
Forum List  »  PHP

Re: Number on a varchar column
Posted by: Peter Brawley
Date: December 21, 2017 02:34PM

MySQL often accepts values like '123xl' as numerics, taking the value of numeric digits up to but not including the first non-numeric char.

If PHP's default behaviour doesn't match results of the above (there's no reason it ought to), you'll need to help it along.

Options: ReplyQuote

Written By
December 21, 2017 11:26AM
December 21, 2017 11:37AM
Re: Number on a varchar column
December 21, 2017 02:34PM
December 21, 2017 04:00PM
December 22, 2017 03:32PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.