Alaor Barroso wrote:
It looks like PHP can't communicate with MSSQL but it
connect! Strange...
What server platform are you using? If you are on *nix you will need to
install freetds and then build php with freetds support before you can
use mssql with it. Under a windows server platform this m
Ben Ramsey wrote:
Anyone know of any kind of character limit in php or mssql (yes,
Microsoft SQL Server) for entering long text into a text column (of
around 4,055 characters in length--that's where it's cutting off)?
Have a look in php.ini - IIRC there are 2 options that affect this.
--
Stuart
That's precisely what I was looking for, Alex! I must have overlooked
it when skimming through php.ini.
Thanks!
Alex Hogan wrote:
Hi Ben,
The setting in the php.ini is;
mssql.textlimit = 4096
Reset that value to what you want. I have mine set to 400.
Valid range 0 - 2147483647
alex hog
; To: [EMAIL PROTECTED]
> Subject: [PHP] Re: php/mssql character limit?
>
> I posted this message the other day, and no one has responded. I'm
> replying to it to refresh it in the list. I guess if no one responds or
> helps me out this time, then I'll just forget ab
Message-
> > From: Ben Ramsey [mailto:[EMAIL PROTECTED]
> > Sent: lundi 8 mars 2004 17:30
> > To: [EMAIL PROTECTED]
> > Subject: [PHP] Re: php/mssql character limit?
> >
> >
> > I posted this message the other day, and no one has responded. I'm
>
Is it mY SQL or MS SQL we are talking about?
-Original Message-
From: Jason Davidson [mailto:[EMAIL PROTECTED]
Sent: lundi 8 mars 2004 17:42
To: [EMAIL PROTECTED]
Subject: RE: [PHP] Re: php/mssql character limit?
VARCHAR limit is 255 :)
mysql.com has great documentation.
Jason
vincent
>
> -Original Message-
> From: Ben Ramsey [mailto:[EMAIL PROTECTED]
> Sent: lundi 8 mars 2004 17:30
> To: [EMAIL PROTECTED]
> Subject: [PHP] Re: php/mssql character limit?
>
>
> I posted this message the other day, and no one has responded. I'm
> re
I am using a "text" column type. I had always though that the max size
for varchars was 255.
Vincent DUPONT wrote:
are you using a 'Text' or a 'varchar' column type?
I guess the max size for varchars is 4000; text should be larger
--
Regards,
Ben Ramsey
http://benramsey.com
http://www.phpco
are you using a 'Text' or a 'varchar' column type?
I guess the max size for varchars is 4000; text should be larger
vincent
-Original Message-
From: Ben Ramsey [mailto:[EMAIL PROTECTED]
Sent: lundi 8 mars 2004 17:30
To: [EMAIL PROTECTED]
Subject: [PHP] Re: php/mssql
I posted this message the other day, and no one has responded. I'm
replying to it to refresh it in the list. I guess if no one responds or
helps me out this time, then I'll just forget about it and let my client
go unhappy. ;-) Seriously, if anyone can help me out, I would be much
appreciat
I doubt msSQL differs from MySQL --
$link = mssql_connect( $host, $user, $pass ) or die( "Can't connect to the
DB!" );
mssql_select_db( $dbname, $link ) or die( "Can't select database" );
$query = "SELECT * FROM members WHERE user='$user' AND pass='$pass';";
$result = mssql_query( $query, $link
11 matches
Mail list logo
