When you are returning longer text from a query in PHP, like from a varchar(MAX) or such you can get weird characters at the end. The problem is that the ODBC connection, which I used to query the MS SQL database, has a default field bytes limit of 4096 chracters. This is controlled by the odbc.defaultlrl setting in the php.ini file. The solution that I found was to override this setting in the page where you need the long text with a line like this.
ini_set(‘odbc.defaultlrl’,65536);
Supposedly you can use the functionodbc_longreadlen setting, but I was not able to get it to work. You can find more info here and here. The default value for this is 4096, so 65536 may be overkill, but you can find what fits. When I tried 0, which is supposed to set it to passthrough all the text it didn’t work at all.
For the curious lrl = long read length
buy moncler sweater for women says
Its really like you read my thoughts! You could know a great deal concerning this, like you wrote the book in it or something. I do believe that you could do with some pics to drive what it’s all about home somewhat, but aside from that, it will be superb blog..
discount Ugg Cardy Boots says
Coquette Uggs Hey, nicely done! I adore whatever you write, so I will continue subsequent your blog.Go on with your style! discount Bailey Button Uggs
new stylish brand ugg green womens classic tall says
grey Classic Cardy Uggs Thank you to the good writeup. By the way, how could we communicate? grey Classic Tall Ugg Boots
cheap Peyton Hillis Jersey says
LeGarrette Blount Jerseys Thanks a lot for that great writeup. Actually, exactly how might we talk? LeRon McClain Jerseys
Peyton Manning Jersey says
Brad Smith Jerseys I,myself adore your article so much, hoping you can compose added fantastic ones Brady Quinn Jerseys
short Metallic Uggs says
Many thanks with regard to supplying individuals with an exceedingly unique chance to read content articles and blogs out of this website. It truly is very fairly sweet and filled with a lot of fun personally and my personal office friends to search your blog at the minimum three times every week to see the most recent assistance you have got. Not to mention, we are all the time happy concerning the mind-blowing inspiring ideas offered by a person. Chosen 2 factors within this posting are certainly the easiest I have ever had.
Lambo says
Big KRIT is the best rapper alive! PERIOD! lol
uggs boot clearance says
Wonderful items of your stuff, guy. I have study your own stuff in front of as well as you are equally well amazing. I like exactly what you have right here, adore what you are stating and exactly how you say this. You are making it entertaining and also you even now manage to help to keep this wise. I cannot wait to undergo additional from you. That’s truly an incredible website.
ugg bailey button black says
An impressive share, I recently given this onto a colleague who was simply performing a small analysis during this. And then he in fact bought me breakfast since I ran across it for him.. smile. So let me reword that: Thnx for the treat! But yeah Thnkx for spending any time to go over this, I find myself strongly about this and adore reading regarding this topic. If at all possible, as you grow expertise, would you mind updating your website with a lot more details? It is extremely great for me. Huge thumb up because of this short article!
Merrill says
Typically I never study post on weblogs, however I wish to say that this write-up very forced me to try and do it! Your writing style has been surprised me. Many thanks, quite awesome write-up.
kids tall uggs says
I’m therefore glad this particular internet thing works as well as your discount ugg boots classic tall post really helped me. Might take you up cheap ugg boots for sale on that home assistance a person
Ugg 5685 says
This really is all very a new comer to classic tall classic argyle knit ugg boots ugg boots clearance me personally and this post really opened my personal eye.Thank you for discussing with us your own wisdom.
ebay suspension solution says
Have eBay suspend your account? I got suspended for simply no purpose! I dropped all my income, my business was online dependent. I needed to discover a solution. By the end I am again for real.
ebay banned says
Have eBay suspend your account? I am suspended for no reason! I dropped all my revenue, my business has been online based. I had to locate a solution. At the end I am again for real.
Dexter McCluster Jerseys says
I would determine your cheap saints jerseys discount uggs blog the dreamland! While Santa knocks at our uggs for kids door just after per year, Houston Texans Jerseys you blog is open the complete year C wow!
Aaron Rodgers Jerseys says
this article cheap saints jerseys discount uggs Houston Texans Jerseys uggs for kids really helps to me personally,thank ough.
Ugg 9819 says
First off, I wish to thanks in the outstanding as well as educational entry. I will need to acknowledge which often, We havent noticed relating to this info. We have noticed quite a few brand new information with regard to cause. Many thanks a lot for giving this particular effective as well as fascinating information. We’re waiting around pertaining to other thrilling posts due to you from the closest long run.
Krakow says
I had been very pleased to access this great site.I must thanks to this superb article!! Surely delighting each part of it and i also saved as a favorite to see latest articles you publish.
womens uggs clearance says
We do not ordinarily comment however i have to state regards for your post on this 1.
ugg tall boots says
Congratulations for posting on this topic. There isn’t sufficient content published about it (not particularly good anyway). It is pleasing to determine it getting a tiny bit much more coverage. Cheers!
louis vuitton high tops says
Appreciate it for the excellent writeup. Anyhow, how might we talk?
louis vuitton kids shoes says
I have to admit your weblog is outstanding! I’ll unquestionably arrive back again again!
Louis Vuitton Watches Greenville says
thanks for your purchase and if you’ve countless websites I would be definitley interested. let me know what you believe when this gig is completed and we may definitley work out something
Kathlyn Somogye says
Hi, have you been allowing any advertising on your website? I’d love to purchase a banner for a month or two linking to my blog that is closely related. Let me know, or give me an email that I can reach you at. Thanks a lot!
Joye Azzaro says
Do you mind if I posted this post on my webpage? I would certainly give you credit and a link back to your site. Many thanks, and please let me know here!