Re^5: Reading (the same) data in different ways & memory usage

(when the database it too stupid to do so itself, as the ANSI standard tells it to)

Erm. If I store the string 'fred ' into a DB, I'd expect to get that same string back. Does ANSI mandate otherwise?

Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error.

"Science is about questioning the status quo. Questioning authority".

In the absence of evidence, opinion is indistinguishable from prejudice.

Comment on Re^5: Reading (the same) data in different ways & memory usage Download Code

Replies are listed 'Best First'.
Re^6: Reading (the same) data in different ways & memory usage by Tux (Canon) on Apr 20, 2011 at 05:56 UTC
Try to read (and understand) this sheet from one of my presentations. All Orange fields do NOT meet my expectations or the standard. The page is old, but most of those still hold true. Enjoy, Have FUN! H.Merijn	[reply]
Re^7: Reading (the same) data in different ways & memory usage by BrowserUk (Patriarch) on Apr 20, 2011 at 11:40 UTC
Wow. I don't know what to say about that. I'd be interesting to see the info for the two DBs I've used most in the past. DB2 & MSSQL. I'd expect the former to do the "right thing"; and that latter to do something 'non-standard' for very well thought through but barely documented reasons. Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error. "Science is about questioning the status quo. Questioning authority". In the absence of evidence, opinion is indistinguishable from prejudice.	[reply]