ColdFusion Or MS-SQL Returning [Empty String] Value For NTEXT
Oh MicroSoft, why must you be the bane of my existence? Seriously, if it's not your buggy web browsers, then it's using another one of your products. And this time it's MS-SQL. Ok, in all seriousness, I'm really not 100% sure if this is MicroSoft's fault or perhaps Adobe's ColdFusion. But either way this one through me for a loop. (And on a side note, why does it seem like this crap always happens on a Monday)
If you have been forced to use MS-SQL on one of your projects. And perhaps you've been banging your head up against your computer monitor for the past three hour, because you've been trying to pull data from an
NTEXT column and it keeps coming back as an
[empty string], then boy do I have a solution for you.