Comments on SQL Server, PHP and Truncating Text - ILoveJackDaniels.com

Comment on SQL Server, PHP and Truncating Text

Comment by Ruben Zevallos Jr. ( http://www.direito2.com.br )

I´m getting another problem... the VarChar fields with more than 255 chars cannot be used... so... this very usefull feature are not avaliable...

Comment on SQL Server, PHP and Truncating Text

Comment by Anonymous ( http:// )

The problem I'm experiencing is that the odbc_fetch_array (using sql server) is truncating the COLUMN name to 31 characters. Has anyone ever experienced this?

Comment on SQL Server, PHP and Truncating Text

Comment by Zaps ( http://finance.clockstrikesgold.com )

What about truncating the displayed value but keeping the full value intact in the DB?

Thanks & I love JD too!

Comment on SQL Server, PHP and Truncating Text

Comment by Eli Burmin ( http:// )

had an issue where mssql.text* settings were ignored by php. explicitly setting the values with ini_set() worked fine.

Comment on SQL Server, PHP and Truncating Text

Comment by The R ( http:// )

I found this didn't make a difference with my ms sql database. Neither did changing to datatypes to text as this gave issues with other pages that were trying to update the same tables.

I managed to eliminate the 255 limit by setting up an odbc connection to the database.
First you have to set up an odbc connection to the database on the server that the db exists on, I did this using IIS. In this example the odbc when set up was given the name: odbcname.
Once you have created this on the server you need the following code(tweak to suit) in the php page/s. (All other code, for example layout and display, obviously remain the same.)

#connect to db
$conn = odbc_connect('odbcname','username','password');
if(!$conn) {exit("Err:Conn"); }

#Query
$sql = "select * from table";

#execute
$result = odbc_exec($conn, $sql);
if( !$result )
{
exit ("Could not execute Query");
}

#data retrieve
$rowodbc = odbc_fetch_array($result);

#create variables from data
$variable =. $rowodbc["column_name"];

#close connection
odbc_close( $conn );

P.S I only had to change the connection type from mssql to odbc on pages that were trying to retrieve more than 255 characters, both types will work along side each other.

Hope this helps

Comment on SQL Server, PHP and Truncating Text

Comment by JJ ( http:// )

You must edit C:\WINDOWS\php.ini and uncomment the following two lines:
; Valid range 0 - 2147483647. Default = 4096.
;mssql.textlimit = 2147483647
; Valid range 0 - 2147483647. Default = 4096.
;mssql.textsize = 2147483647

and change them to:

; Valid range 0 - 2147483647. Default = 4096.
mssql.textlimit = 2147483647

; Valid range 0 - 2147483647. Default = 4096.
mssql.textsize = 2147483647

Comment on SQL Server, PHP and Truncating Text

Comment by JORGE OROZCO ( http:// )

manicka if u dont have a text field instead u have a varchar the limit that u still have is 255, attemp to do a cast.
myvarchar varchar(4000)

$sql="select cast (myvarcharfield as text) from mytable";
mssql_queyr($sql);

Comment on SQL Server, PHP and Truncating Text

Comment by manicka prakash ( )

after that also i was not increasing the limit . then what can i do to increase the limit from 4 kb