i just figure it out, when using mssql DB with PHP, and try to insert large text, you need to modify the PHP.ini file as: ; Valid range 0 - 2147483647. Default = 4096. mssql.textlimit = *4096 ---> increase this values* ; Valid range 0 - 2147483647. Default = 4096. mssql.textsize = *4096 ---> increase this values* ** On Tue, Feb 17, 2009 at 10:16 AM, Hari KT <kthari85@xxxxxxxxxxx> wrote: > use addslashes() function . > > before u insert any to db. > > Hari K T > > http://www.harikt.com/ > http://ijust4u.blogspot.com/ > > --- On Mon, 16/2/09, abhishek jain <ejaincom@xxxxxxxxx<ejaincom%40yahoo.com>> > wrote: > From: abhishek jain <ejaincom@xxxxxxxxx <ejaincom%40yahoo.com>> > Subject: Re: Insert problem > To: php-objects@xxxxxxxxxxxxxxx <php-objects%40yahoogroups.com> > Date: Monday, 16 February, 2009, 9:08 PM > > > can you pl. check, it is a update query or an insert query, > > Further pl. let us know the o/p of the variable or the query. -- > > Regards, > > Abhishek jain > > ____________ _________ _________ __ > > From: Mohammad Al-Naji <mnaji.qx@gmail. com> > > To: php-objects@ yahoogroups. com > > Sent: Sunday, February 15, 2009 2:49:22 PM > > Subject: Re: Insert problem > > its text, i just found that it's inserted correctly in DB but PHP cannot > > read it all, it reads it truncated... > > On Sun, Feb 15, 2009 at 9:13 AM, abhishek jain <ejaincom@yahoo. com> > wrote: > > > is BodyEn varchar and not text > > > > > > Pl. dump your table schema. > > > -- > > > Regards, > > > Abhishek jain > > > > > > ____________ _________ _________ __ > > > From: Mohammad Al-Naji <mnaji.qx@gmail. com <mnaji.qx%40gmail. com>> > > > To: php-objects@ yahoogroups. com <php-objects% 40yahoogroups. com> > > > Sent: Sunday, February 15, 2009 12:29:14 PM > > > Subject: Insert problem > > > > > > I'm trying to insert the following statement into MSSQL DB, the field > type > > > is text but is not inserted completely, it's truncated. can anyone help? > > > > > > statement > > > > > > UPDATE Table > > > SET BodyEn = '<p align="left" > > > class="header_ black"><strong> Terms of Use </strong> </p> > > > <p align="left" > company test Telecom and related > > > companies ("company Telecom"), ("company International) > > > provides access to and allows use of this site (www.company- > > > test.com) > > > subject to the following terms:<br /> > > > 1. By using www.company- test.com you agree to > > > be legally bound by these terms, which shall take effect immediately on > > > your first use of www.company- test.com. If you do not agree to be > legally > > > bound by all the following terms, please do not access and/or use > > > www.company- test.com. <br <http://www.company- test.com. %3cbr/> /> > > > <br /> > > > 2. company test Telecom may change these terms > > > at any time by posting changes online. Please review these terms > regularly > > > to ensure you are aware of any changes made by company test Telecom. Your > > > continued use of www.company- test.com after changes are posted means > you > > > agree to be legally bound by these terms as updated and/or amended. </p> > > > <p align="left" class="header_ black"><strong> Use of > > > www.company- test.com< /strong <http://www.company- test.com% > 3c/strong>> > > > </p> > > > > > > <p align="left" > 3. You may not copy, reproduce, > > > modify, transfer, distribute, republish, download, post, broadcast, > > > transmit, make available to the public, or otherwise use the content on > > > this site (content includes but is not limited to text, layout, > > > information, communications, software, sounds, names images, pictures, > > > logos, icons, apparatus, product or process) in any form or by any means > > > (including but not limited to electronic, mechanical photocopying or > > > recording) except for your own personal, non-commercial use. You also > agree > > > not to adapt, alter or create a derivative work from any > > > www.company- test.com content. Any other use of www.company- > test.comcontent > > > requires the prior written permission of company test Telecom. <br /> > > > You understand and agree that you are responsible > > > for any content that you post or transmit on or through this site. You > > > agree not to cause, nor knowingly allow others to cause, any nuisance, > > > annoyance, or inconvenience, whether to company test Telecom or users of > > > www.company- test.com by any means.<br /> > > > 4. You agree to use www.company- test.com only for > > > lawful purposes, in a manner consistent with all applicable laws and > > > regulations and in a way that does not infringe the rights of, restrict > or > > > inhibit anyone else"s use and enjoyment of www.company- test.com. > > > Specifically, you will not use www.company- test.com to post, transmit, > > > distribute, link to or solicit content that (a) violates or infringes any > > > laws, regulatory requirements or codes (b) infringes or violates any > > > copyright, trademark or any other intellectual property, personal or > > > proprietary rights of any person, or violates any obligation of > confidence > > > or any other proprietary right; (c) contains any obscene, offensive, > > > defamatory or otherwise actionable material; (d) disrupts the normal flow > > > of dialogue within companytelecomtest. com; (e) undermines the security > or > > > integrity of companytelecomtest. com, including without limitation by > > > importing any viruses, Trojan horses, time bombs or other disabling > devices > > > intended to detrimentally interfere, damage, surreptitiously intercept or > > > expropriate such equipment, systems or networks; (f) contains any errors, > > > whether technical or otherwise; or (g) contains any material in any form > > > that would otherwise render company test Telecom liable or expose company > > > test Telecom to any proceedings whatsoever.< br /> > > > 5. You may not use any robot, spider, or other > > > automatic or manual device or process to monitor or copy our web pages or > > > any portion of the content contained herein without the express prior > > > written permission of company test Telecom.<br /> > > > 6. You may not use any device, software or > > > routine to interfere or attempt to interfere with the proper working of > > > www.company- test.com, or to impose an unreasonable or > disproportionately > > > large load on the servers serving > > > www.company- test.com. <br<http://www.company- test.com. %3cbr/>/> > > > > > > 7. company test Telecom shall have the right (but > > > not the obligation) in its sole discretion to monitor, refuse or remove > any > > > content that is available via www.company- test.com. Without limiting > the > > > foregoing, company test Telecom shall have the right to remove any > content > > > that violates these terms or is otherwise objectionable. </p> > > > <p align="left" class="header_ black"><strong> Content > > > Posted or Submitted to company test Telecom</strong> </p> > > > <p align="left" > 8. company test Telecom freely > > > welcomes the submission of comments, information, or feedback through > > > www.company- test.com, by all means and in any media now known or > > > hereafter > > > developed. By submitting information through this site you agree that the > > > information shall not be considered confidential and shall become the > > > property of company test Telecom, including an assignment of all rights > and > > > titles to such information. Where assignment is not possible, company > test > > > Telecom shall have the unrestricted right to use such information, with > > > right to reproduce, distribute, transmit, create derivative works of, > > > publicly display and publicly perform any materials and other information > > > (including, without limitation, ideas contained therein for new or > improved > > > products and services) you submit to www.company- test.com, for any > > > purpose > > > and without compensation to you. You also grant to company the right > > > (though you acknowledge and agree that company test Telecom shall not be > so > > > obliged) to use your name in connection with the submitted materials and > > > other information as well as in connection with all advertising, > marketing > > > and promotional material related thereto. You agree that you shall have > no > > > recourse against company test Telecom for any alleged or actual > > > infringement or misappropriation of any proprietary right in your > > > communications to us. <br /> > > > 9. Except for any personal, individually > > > identifying information which we have agreed to keep confidential, any > > > feedback, data, answers, questions, comments, suggestions, plans, ideas > or > > > the like that you send to us via www.company- test.com, via e-mail or > > > otherwise, will be treated as being non-confidential and non-proprietary. > > > We assume no obligation to protect such information from disclosure and > > > will be free to reproduce, use, and distribute the information to others > > > without restriction. We will also be free to use any ideas, concepts, > > > know-how or techniques contained in information that you send us for any > > > purpose whatsoever including but not limited to developing, manufacturing > > > and marketing products and services incorporating such information. </p> > > > <p align="left" > > > class="header_ black"> <strong>Postings by Third > > > Parties and Hyperlinks to Third Party Websites</strong> </p> > > > <p align="left" > 10. www.company- test.com contains > > > hyperlinks to other websites which are neither maintained nor controlled > by > > > company test Telecom, or may contain content posted on or via > > > www.company- test.com by third parties. company test Telecom shall not > be > > > responsible for any errors or omissions in any content in > > > www.company- test.com, or the content, products or services of any > > > hyperlinked website or any hyperlink contained in a hyperlinked web site, > > > nor for the privacy and security practices employed by these other > > > websites, and shall not be liable for any loss or damage of any kind > > > incurred as a result of the use of any content posted or contained in > > > e-mails or otherwise transmitted or displayed via www.company- test.com, > > > or > > > arising from access to those websites. Use of www.company- test.com and > > > any > > > hyperlinks and access to such hyperlinked websites are entirely at your > own > > > risk.<br /> > > > 11. You acknowledge that company test Telecom has > > > no control over and excludes all liability for any material on the > Internet > > > which can be accessed by using www.company- test.com. Neither can we be > > > deemed to have endorsed the content.</p> > > > <p align="left" > > > class="header_ black"><strong> Hyperlinks from Third Party > > > Websites</strong> > > > </p> > > > <p align="left" > 12. You agree that caching, > > > deep-linking, hyper linking to, and framing of www.company- test.com or > > > any > > > of the contents are strictly prohibited.< br /> > > > 13. company test Telecom reserves all rights to > > > disable any links to, or frames of any site containing inappropriate, > > > profane, defamatory, infringing, obscene, indecent or unlawful topics, > > > names, material or information, or material or information that violates > > > any written law, any applicable intellectual property, proprietary, > privacy > > > or publicity rights.</p> > > > <p align="left" > > > class="header_ black"><strong> Disclaimers and Limitation of > > > Liability</strong> </p> > > > <p align="left" > 14. You assume total responsibility > > > and risk for your use of www.company- test.com and the Internet. Neither > > > company test Telecom nor any content provider makes any express or > implied > > > warranties, representations or endorsements whatsoever with regard to > > > www.company- test.com, any content or any merchandise, information or > > > service provided through www.company- test.com or on the Internet</p> ' > > > WHERE (ID = 41) > > > > > > -- > > > Kind Regards, > > > Mohammad Al-Naji > > > > > > [Non-text portions of this message have been removed] > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > -- > > Kind Regards, > > Mohammad Al-Naji > > [Non-text portions of this message have been removed] > > [Non-text portions of this message have been removed] > > > > > > > > > > > > Bring your gang together. Do your thing. Find your favourite Yahoo! group > at http://in.promos.yahoo.com/groups/ > > [Non-text portions of this message have been removed] > > > -- Kind Regards, Mohammad Al-Naji [Non-text portions of this message have been removed]
