Click here to Skip to main content
14,215,857 members

Welcome to the Lounge

   

For discussing anything related to a software developer's life. Technical discussions are encouraged, but click here to ask your programming questions.

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.
 
GeneralRe: Those popups telling me I'm using an ad-blocker... Pin
#realJSOP18-Apr-19 1:37
mve#realJSOP18-Apr-19 1:37 
GeneralRe: Those popups telling me I'm using an ad-blocker... Pin
Mark_Wallace18-Apr-19 4:31
memberMark_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
memberMark_Wallace18-Apr-19 4:30 
GeneralRe: Those popups telling me I'm using an ad-blocker... Pin
Dan Neely19-Apr-19 3:21
memberDan Neely19-Apr-19 3:21 
GeneralMost head-slapping feature in a language Pin
Chris Maunder17-Apr-19 8:01
adminChris Maunder17-Apr-19 8:01 
GeneralRe: Most head-slapping feature in a language Pin
W Balboos17-Apr-19 8:55
mveW Balboos17-Apr-19 8:55 
GeneralRe: Most head-slapping feature in a language Pin
PIEBALDconsult17-Apr-19 9:05
protectorPIEBALDconsult17-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
protectorJö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
memberBryanFazekas18-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
memberSuper Lloyd17-Apr-19 12:18 
GeneralRe: Most head-slapping feature in a language Pin
Super Lloyd17-Apr-19 12:16
memberSuper 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
memberSuper 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
mve#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
memberSuper Lloyd17-Apr-19 13:19 
GeneralRe: Most head-slapping feature in a language Pin
Alister Morton18-Apr-19 5:50
memberAlister Morton18-Apr-19 5:50 
GeneralRe: Most head-slapping feature in a language Pin
englebart18-Apr-19 7:02
memberenglebart18-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.


Advertise | Privacy | Cookies | Terms of Service
Web01 | 2.8.190619.2 | Last Updated 24 Jun 2019
Copyright © CodeProject, 1999-2019
All Rights Reserved.
Layout: fixed | fluid