PHP / MSSQL

[Mark Knochen]

Hallo,

i have a MS SQL Database with some tables with textfields.
in the textfields are long strings ... but i cant get the full string
from the table ... i get only ca. 8000 chars ...

Mark

[rlee0001]

Hmm, have you tried it with a PostgreSQL database? That might work.

[Mark Knochen]

rlee0001 wrote:

Hmm, have you tried it with a PostgreSQL database? That might work.

I have tried it with MySQL - it works.

But i have to use for this one Project an MSSQL Server.

What can i do?

Mark

[David Haynes]

Mark Knochen wrote:

Hallo,

i have a MS SQL Database with some tables with textfields.
in the textfields are long strings ... but i cant get the full string
from the table ... i get only ca. 8000 chars ...

Mark

MSSQL has an 8000 character limit for varchar.
NOTE: the driver used by PHP only supports 255 characters in a varchar.

text (the data type not the type of data) has a limit of 2^31-1 bytes.

So, you need to store the value as text not varchar. You can probably
use CONVERT to move from varchar to text.

-david-

[David Haynes]

Mark Knochen wrote:

Hallo,

i have a MS SQL Database with some tables with textfields.
in the textfields are long strings ... but i cant get the full string
from the table ... i get only ca. 8000 chars ...

Mark

Another thing...
Since text is stored using a different mechanism than varchar (i.e. in a
different location) saving and retrieving text may be a slower operation.

-david-

[Tjoumaidis Tassos]

Mark Knochen wrote:

Hallo,

i have a MS SQL Database with some tables with textfields.
in the textfields are long strings ... but i cant get the full string
from the table ... i get only ca. 8000 chars ...

Mark

Try to change the following values in the php.ini

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

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

[Chung Leong]

Tjoumaidis Tassos wrote:

Mark Knochen wrote:

Hallo,

i have a MS SQL Database with some tables with textfields.
in the textfields are long strings ... but i cant get the full string
from the table ... i get only ca. 8000 chars ...

Mark

Try to change the following values in the php.ini

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

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

Setting these two using ini_set() prior to making the connection also
works.

[Mark Knochen]

>>; Valid range 0 - 2147483647. Default = 4096.

mssql.textlimit = 4096

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

Setting these two using ini_set() prior to making the connection also
works.

The CREATE TABLE was:

CREATE TABLE modul (
ID int NOT NULL IDENTITY ,
"text" text NOT NULL default '',
PRIMARY KEY (ID)
);

I set these settings:

ini_set("mssql.textlimit",409600);
ini_set("mssql.textsize",409600);

But nothing works.

I cant get the full text from the table ...

Mark