Join devRant
Do all the things like
++ or -- rants, post your own rants, comment on others' rants and build your customized dev avatar
Sign Up
Pipeless API
From the creators of devRant, Pipeless lets you power real-time personalized recommendations and activity feeds using a simple API
Learn More
-
@bittersweet Of course it has, however some people seem loving varchar soooo much 😪
-
@xonya I had a colleague once who varcharred all the things 🤦♂️ maybe he built this
-
@xonya Ah like the "true" string.
-
@karma nchar is even more fun 😋
-
@ralnivar ima troll ppl with that next project
Related Rants
Oh sh*t
I'm moving some old data into a new database.
It contains some dates that *should* be in ISO 8601...
This is some of the trash that I found:
01/01/70
2010-11-05T08:06:48T08:06:03.7
2007-09-13T
Moreover, it has a column which *should* contains numbers, instead it has been defined using varchar, so it contains also some wonderful 'NaN' values.
I really would like to beat the person who set up all this stuff without some basic validation policies.
rant
database
validation
tons of crap
fml