Click here to Skip to main content
15,915,093 members

Welcome to the Lounge

   

For discussing anything related to a software developer's life but is not for programming questions. Got a programming question?

The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.

 
GeneralRe: Those popups telling me I'm using an ad-blocker... Pin
#realJSOP18-Apr-19 1:37
professional#realJSOP18-Apr-19 1:37 
GeneralRe: Those popups telling me I'm using an ad-blocker... Pin
Mark_Wallace18-Apr-19 4:31
Mark_Wallace18-Apr-19 4:31 
GeneralRe: Those popups telling me I'm using an ad-blocker... Pin
GKP199218-Apr-19 20:44
professionalGKP199218-Apr-19 20:44 
GeneralRe: Those popups telling me I'm using an ad-blocker... Pin
Mark_Wallace18-Apr-19 4:30
Mark_Wallace18-Apr-19 4:30 
GeneralRe: Those popups telling me I'm using an ad-blocker... Pin
Dan Neely19-Apr-19 3:21
Dan Neely19-Apr-19 3:21 
GeneralMost head-slapping feature in a language Pin
Chris Maunder17-Apr-19 8:01
cofounderChris Maunder17-Apr-19 8:01 
GeneralRe: Most head-slapping feature in a language Pin
W Balboos, GHB17-Apr-19 8:55
W Balboos, GHB17-Apr-19 8:55 
GeneralRe: Most head-slapping feature in a language Pin
PIEBALDconsult17-Apr-19 9:05
mvePIEBALDconsult17-Apr-19 9:05 
Of those, I use only SQL, and it's worse than that. (Transact-SQL at least.)

Remember that RTRIM and LTRIM remove only SPACEs, not all whitespace.

Basically, LEN (and RTRIM and LTRIM) work on bytes, so it does the same things with VARBINARY as it does with VARCHAR.
So I should not have been surprised when performing LEN on a VARBINARY ignores 0x32 at the end as well. Sigh | :sigh:

modified 17-Apr-19 23:47pm.

GeneralRe: Most head-slapping feature in a language Pin
Jörgen Andersson17-Apr-19 9:52
professionalJörgen Andersson17-Apr-19 9:52 
GeneralRe: Most head-slapping feature in a language Pin
MacSpudster17-Apr-19 10:41
professionalMacSpudster17-Apr-19 10:41 
GeneralRe: Most head-slapping feature in a language Pin
MacSpudster17-Apr-19 11:14
professionalMacSpudster17-Apr-19 11:14 
GeneralRe: Most head-slapping feature in a language Pin
BryanFazekas18-Apr-19 1:06
BryanFazekas18-Apr-19 1:06 
GeneralRe: Most head-slapping feature in a language Pin
MacSpudster18-Apr-19 3:53
professionalMacSpudster18-Apr-19 3:53 
AnswerRe: Most head-slapping feature in a language Pin
megaadam17-Apr-19 11:59
professionalmegaadam17-Apr-19 11:59 
GeneralRe: Most head-slapping feature in a language Pin
Super Lloyd17-Apr-19 12:18
Super Lloyd17-Apr-19 12:18 
GeneralRe: Most head-slapping feature in a language Pin
Super Lloyd17-Apr-19 12:16
Super Lloyd17-Apr-19 12:16 
GeneralRe: Most head-slapping feature in a language Pin
Christian Graus17-Apr-19 12:37
protectorChristian Graus17-Apr-19 12:37 
GeneralRe: Most head-slapping feature in a language Pin
Super Lloyd17-Apr-19 13:18
Super Lloyd17-Apr-19 13:18 
GeneralRe: Most head-slapping feature in a language Pin
Christian Graus17-Apr-19 15:30
protectorChristian Graus17-Apr-19 15:30 
GeneralRe: Most head-slapping feature in a language Pin
#realJSOP18-Apr-19 1:39
professional#realJSOP18-Apr-19 1:39 
GeneralRe: Most head-slapping feature in a language Pin
Peter_in_278017-Apr-19 12:42
professionalPeter_in_278017-Apr-19 12:42 
GeneralRe: Most head-slapping feature in a language Pin
Super Lloyd17-Apr-19 13:19
Super Lloyd17-Apr-19 13:19 
GeneralRe: Most head-slapping feature in a language Pin
Alister Morton18-Apr-19 5:50
Alister Morton18-Apr-19 5:50 
GeneralRe: Most head-slapping feature in a language Pin
englebart18-Apr-19 7:02
professionalenglebart18-Apr-19 7:02 
GeneralRe: Most head-slapping feature in a language Pin
Christian Graus17-Apr-19 15:40
protectorChristian Graus17-Apr-19 15:40 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.