14,176,425 members

# Welcome to the Lounge

The Lounge is rated PG. If you're about to post something you wouldn't want your kid sister to read then don't post it. No flame wars, no abusive conduct, no programming questions and please don't post ads.

 Re: Those popups telling me I'm using an ad-blocker... GKP199217-Apr-19 15:18 GKP1992 17-Apr-19 15:18
 Re: Those popups telling me I'm using an ad-blocker... #realJSOP18-Apr-19 1:37 #realJSOP 18-Apr-19 1:37
 Re: Those popups telling me I'm using an ad-blocker... Mark_Wallace18-Apr-19 4:31 Mark_Wallace 18-Apr-19 4:31
 Re: Those popups telling me I'm using an ad-blocker... GKP199218-Apr-19 20:44 GKP1992 18-Apr-19 20:44
 Re: Those popups telling me I'm using an ad-blocker... Mark_Wallace18-Apr-19 4:30 Mark_Wallace 18-Apr-19 4:30
 Re: Those popups telling me I'm using an ad-blocker... Dan Neely19-Apr-19 3:21 Dan Neely 19-Apr-19 3:21
 Most head-slapping feature in a language Chris Maunder17-Apr-19 8:01 Chris Maunder 17-Apr-19 8:01
 Re: Most head-slapping feature in a language W∴ Balboos17-Apr-19 8:55 W∴ Balboos 17-Apr-19 8:55
Quote:
Len("hello") = Len("hello ")

I was thinking how char vs. varchar are treated in SQL and messed around trying to get the LEN('HELLO ') != LEN('HELLO')

It's like an incorrect passing/appenidng/using VARCHAR(MAXLEN): if it passes through anything not of MAXLEN it's truncated (to 8K or, to 'HELLO').

Lesson learned, although I've not declared an actual char field [ >char(2) ] in years, and even that, only rarely.
Ravings en masse^
"The difference between genius and stupidity is that genius has its limits." - Albert Einstein
"If you are searching for perfection in others, then you seek disappointment. If you are seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010

 Re: Most head-slapping feature in a language PIEBALDconsult17-Apr-19 9:05 PIEBALDconsult 17-Apr-19 9:05
 Re: Most head-slapping feature in a language MacSpudster17-Apr-19 10:41 MacSpudster 17-Apr-19 10:41
 Re: Most head-slapping feature in a language MacSpudster17-Apr-19 11:14 MacSpudster 17-Apr-19 11:14
 Re: Most head-slapping feature in a language BryanFazekas18-Apr-19 1:06 BryanFazekas 18-Apr-19 1:06
 Re: Most head-slapping feature in a language MacSpudster18-Apr-19 3:53 MacSpudster 18-Apr-19 3:53
 Re: Most head-slapping feature in a language Super Lloyd17-Apr-19 12:18 Super Lloyd 17-Apr-19 12:18
 Re: Most head-slapping feature in a language Super Lloyd17-Apr-19 12:16 Super Lloyd 17-Apr-19 12:16
 Re: Most head-slapping feature in a language Christian Graus17-Apr-19 12:37 Christian Graus 17-Apr-19 12:37
 Re: Most head-slapping feature in a language Super Lloyd17-Apr-19 13:18 Super Lloyd 17-Apr-19 13:18
 Re: Most head-slapping feature in a language Christian Graus17-Apr-19 15:30 Christian Graus 17-Apr-19 15:30
 Re: Most head-slapping feature in a language #realJSOP18-Apr-19 1:39 #realJSOP 18-Apr-19 1:39
 Re: Most head-slapping feature in a language Peter_in_278017-Apr-19 12:42 Peter_in_2780 17-Apr-19 12:42
 Re: Most head-slapping feature in a language Super Lloyd17-Apr-19 13:19 Super Lloyd 17-Apr-19 13:19
 Re: Most head-slapping feature in a language Alister Morton18-Apr-19 5:50 Alister Morton 18-Apr-19 5:50
 Re: Most head-slapping feature in a language englebart18-Apr-19 7:02 englebart 18-Apr-19 7:02
 Last Visit: 25-May-19 15:55     Last Update: 25-May-19 15:55 Refresh « Prev1...164165166167168169170171172173 Next »