RE: [PHP] PROBLEMS WHEN EXTRACING DATA FROM MSSQL DATABASE WITH PHP

From: Larry Brown (larry.brown_at_dimensionnetworks.com)
Date: 12/23/03 

To: "Dale Hersh" <dalehersh@hotmail.com>, "PHP List" <php-general@lists.php.net>
Date: Mon, 22 Dec 2003 18:59:27 -0500

Is your field too small? MySQL doesn't complain when you give it a string
longer than it can accept based on the field's size. It just cuts off what
doesn't fit :-)

-----Original Message-----
From: Dale Hersh [mailto:dalehersh@hotmail.com]
Sent: Monday, December 22, 2003 6:50 PM
To: php-general@lists.php.net
Subject: [PHP] PROBLEMS WHEN EXTRACING DATA FROM MSSQL DATABASE WITH PHP

I am having a really unusual problem. In my database, I currently have
string such as:

"I went to the store and bought some food. I then decided to go to the
movies and I saw
Bad Boy II."

When I extract the data out of the database, the data always seems to get
cutoff. In other words, I will only get the follow:
"I went to the store and bought some food. I then decided to go to the
movies and"

Is there some type of variable I need to set in the php.in that control how
long of a string you can have. It only seems to happen when I am storing
long strings in my database.

I am using a mssql database. I don't think it is a database issue because I
am able to update the database just fine. When I check the database it
contains all of the text. When I try to extract the data using php,
everything seems to get cut off.

Any ideas?

Thanks,
Dale 

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Relevant Pages

  • Split Single Address Field into Component Parts
    ... would make a copy of the database before making any ... would subtract that part of the string from the working ... I ran an update query to extract the portion of the ...
    (microsoft.public.access.queries)
  • Re: A little advice
    ... I didnt even know about the eval function. ... website with a database, and to have it go buy-bye, would be muchos bad. ... > I am *VERY* glad that php does not automaticly recognize and execute php ... >> using that string as an arathmatic formula, ...
    (alt.php)
  • Re: A little Rolodex [revised]
    ... including alpha sort and searching for any embedded string, ... In this application, a database is a directory, ... you may optionally provide any alternate UCASE program, ... NN -> first store NN as key length ...
    (comp.sys.hp48)
  • Re: return multiple rows from sql statement
    ... strings from input values is almost certainly a safe path to SQL ... Also, being a MySQL function, it knows what MySQL needs or uses. ... All characters that are entered in the fields make their way into the database unaltered. ... The insert of what surprisinlgly was NOT a syntax error, but a string called "mysql_insert_id" into an integer field resulted in the value zero being put in. ...
    (comp.lang.php)
  • Re: Code to delete/unlink Linked tables
    ... Public intLinkODBCTables As Variant, intLinkDB2Tables As Variant ... Public strLinkBackendDB As String, strLinkDSNname As String, strLinkLibName ... ' MsgBox "This database is in MDE format...I will delete/recreate ODBC ... Public Sub fncLinkDB2Table() ...
    (microsoft.public.access.modulesdaovba)