Re: [PHP-DB] help! sqlserver only returns 256 from varchar types

2002-01-25 Thread Dan Brunner

Hello!!!

What is the Length of the varchar field,  in your database???


Dan


On Friday, January 25, 2002, at 01:22 PM, [EMAIL PROTECTED] wrote:

 I'm having a problem with varchar fields out of mssql which are only 
 returning value lenghts  = 256 characters.

 I know that the php.ini setting in  mssql for textlength must be set to 
 get more than 4096 chars, I've set this value higer and my TEXT types 
 return correctly,  but my varchar fields are still truncated to = 
 256. ..

 is there another setting for the php.ini for returning longer length 
 varchar type fields???

 thanks



 Kevin Won
 -
 ITG Web Developer,
 Systems Administrator
 Oregon Health Sciences University
 (503) 418-4282
 cell: (503) 913-5367
 page: x15897
 fax: (503) 494-1888





 --
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail: [EMAIL PROTECTED]
 To contact the list administrators, e-mail: [EMAIL PROTECTED]



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP-DB] help! sqlserver only returns 256 from varchar types

2002-01-25 Thread Dan Brunner

If you need something that big

Use a TEXT type instead.



Dan


On Friday, January 25, 2002, at 01:35 PM, [EMAIL PROTECTED] wrote:

 thanks for your reply. It's 5000.



 Kevin Won
 -
 ITG Web Developer,
 Systems Administrator
 Oregon Health Sciences University
 (503) 418-4282
 cell: (503) 913-5367
 page: x15897
 fax: (503) 494-1888




 Dan Brunner [EMAIL PROTECTED] 01/25/02 11:31AM 
 Hello!!!

 What is the Length of the varchar field,  in your database???


 Dan


 On Friday, January 25, 2002, at 01:22 PM, [EMAIL PROTECTED] wrote:

 I'm having a problem with varchar fields out of mssql which are only
 returning value lenghts  = 256 characters.

 I know that the php.ini setting in  mssql for textlength must be set to
 get more than 4096 chars, I've set this value higer and my TEXT types
 return correctly,  but my varchar fields are still truncated to =
 256. ..

 is there another setting for the php.ini for returning longer length
 varchar type fields???

 thanks



 Kevin Won
 -
 ITG Web Developer,
 Systems Administrator
 Oregon Health Sciences University
 (503) 418-4282
 cell: (503) 913-5367
 page: x15897
 fax: (503) 494-1888





 --
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail: [EMAIL PROTECTED]
 To contact the list administrators, e-mail: php-list-
 [EMAIL PROTECTED]





-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP-DB] help! sqlserver only returns 256 from varchar types

2002-01-25 Thread Brian Bruns

which library are you using to connect to SQL Server?  Is this php running 
on windows or are you trying from unix?



On Fri, 25 Jan 2002, Kevin Won wrote:

 I'm having a problem with varchar fields out of mssql which are only returning value 
lenghts  = 256 characters.
 
 I know that the php.ini setting in  mssql for textlength must be set to get more 
than 4096 chars, I've set this value higer and my TEXT types return correctly,  but 
my varchar fields are still truncated to = 256. .. 
 
 is there another setting for the php.ini for returning longer length varchar type 
fields???
 
 thanks
 
 
 
 Kevin Won
 -
 ITG Web Developer,
 Systems Administrator
 Oregon Health Sciences University
 (503) 418-4282
 cell: (503) 913-5367
 page: x15897
 fax: (503) 494-1888
 
 
 
 
 
 


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]