|
So I was just testing some software with a client.
First actual test we did and it should work.
Except, it didn't...
We have this file definition and the file should end with EN EZ or something like that (it's not an actual file, but people keep calling it that).
The client imports the file and everything seems fine, except that it doesn't process the contents.
Check out if we're missing something in the database.
Copy the file contents and paste them in Notepad++ and notice that it's cut halfway (because EN EZ was missing).
The total length of the contents was 65,535 or 2^16 - 1, which is no coincidence.
Check the max length of a .NET string, no problem there.
It's constructed using a StringBuilder, also no problem there.
It's converted to JSON, also no problem there.
It's send to an external service using HTTP, but also no problem there.
The database field of NVARCHAR(MAX) should also be able to have more characters, so also no problem there...
The problem was the SQL Server editor, which apparently can't show (and thus copy) more than 65,535 characters 
No problems there, move along... 
The actual problem was that we had to check some checkbox in the importing application 
|
|
|
|
|
I've had this with sql results too, just couldn't work out exactly why certain results were matching a query, to the extent of converting fields to ascii codes to see if I could spot something hidden in them. Turned out the text had multiple lines and the grid view only shows the first line, the text being matched was simply further down the field
|
|
|
|
|
Classic, been there done that!
|
|
|
|
|
Yes, these are testing times 
|
|
|
|
|
...I resemble that![^]
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
well I reckon she was actually really really lucky: collapsed before she got to starborgs
this internet has become nothing but fake news.
... time to fix it, time to get back to the fax!
|
|
|
|
|
Yeah that';s pretty much me!
They call me different but the truth is they're all the same!
JaxCoder.com
|
|
|
|
|
I'd rather get hit by a bus on the way to a starbucks rather than taking a sip of the antpiss they serve there. I'm glad to be surrounded by local coffee shops that know how to brew a really good cup.
|
|
|
|
|
Rajesh R Subramanian wrote: sip of the antpiss they serve there
Don't insult ant piss. It isn't as bad as Starbucks' "coffee"... 
Freedom is the freedom to say that two plus two make four. If that is granted, all else follows.
-- 6079 Smith W.
|
|
|
|
|
My apologies.
|
|
|
|
|
Rajesh R Subramanian wrote: I'd rather get hit by a bus on the way to a starbucks rather than taking a sip of the antpiss they serve there.
Would you say the same for cat sh*t[^]?
M.D.V. 
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
Today I learned that some people consume cat sh*t.  
|
|
|
|
|
Not only consume... they pay a lot of $$$ for it.
If I am not wrong, it actually is one of the most expensive coffees worldide.
I was in Sumatra in a farm of it, and IIRC they wanted 150$ for 500gr.
In Munich you pay over 7€ (in very exclusive coffee shops) for an espresso of it.
M.D.V.
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
Wow, some people are just bloody f****** weird.
|
|
|
|
|
Christmas tip:
When you grind those special quality Christmas coffee beans to give yourself a treat: Put a couple cardamom seeds with the coffee beans in the grinder. It should be whole seeds - pre-ground cardamom looses its aroma fast, and the aroma is what you want for your coffee - you shouldn't use so much that you have a "taste" of cardamom.
Some people suggest adding a little cinnamon as well (again: for the aroma, not for the "taste"). My grinder doesn't handle cinnamon bark very well, so I add cinnamon only when making a whole pot, and can put a piece of bark to soak in the pot immediatly after brewing.
Coffee isn't Christmas Coffee unless it has a slight touch of cardamom, and a touch of cinnamon.
|
|
|
|
|
I find it odd how much people admit to being addicted to drugs and think it's a badge of honor.
Social Media - A platform that makes it easier for the crazies to find each other.
Everyone is born right handed. Only the strongest overcome it.
Fight for left-handed rights and hand equality.
|
|
|
|
|
Is a visit an expensive wig shop just too high a price toupee?
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Too funny - I am going to need an extension so I can rogaine my composure on this one.
I, for one, like Roman Numerals.
|
|
|
|
|
At first I thought, "what a brilliant observation!"
then I realised it was merely the reflection of the light from the way I had tilted my [yes, bald] head when I first read it.
this internet has become nothing but fake news.
... time to fix it, time to get back to the fax!
|
|
|
|
|
Where did you hair that? What part or comb-ination of parts are known to be perm-anent?
| 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 seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010 |
|
|
|
|
|
That can't be topped.
Freedom is the freedom to say that two plus two make four. If that is granted, all else follows.
-- 6079 Smith W.
|
|
|
|
|
Any price is too high for a merkin.
|
|
|
|
|
|
It seems that BBC blocked (no bbc.com and no bbc.co.uk) in my company firewall - the only site I can remember years back that I can't load...
But thinking of it - it is probably the best advert
"The only place where Success comes before Work is in the dictionary." Vidal Sassoon, 1928 - 2012
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
