MySQL Forums
Forum List  »  PHP

Number on a varchar column
Posted by: Daniel Kolbach
Date: December 21, 2017 11:26AM

I'm developing an application in Laravel that received a dump of information periodically. One of the columns, called size is set to a varchar(45), normally has values such as 44XL, 3W45#, a mix of numbers and letters. The data set that i have for coincidence has only the number 44 for that column. PHP/Laravel/Mysql is treating that column as a number, therefore my select statement doesn't work as is looking for a where size='44'.
Has anyone encountered this problem?

Options: ReplyQuote

Written By
Number on a varchar column
December 21, 2017 11:26AM
December 21, 2017 11:37AM
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.