2002 15:32
To: [EMAIL PROTECTED]
Subject: Re: [PHP] Getting only 255 chars from SQL Server
On Sun, 12 May 2002 18:43:47 -0700, you wrote:
I have an SQL Server database running on a server on the internet. I
need to have php connecting to the db and returning values. Simple
stuff. No proble
On Sun, 12 May 2002 18:43:47 -0700, you wrote:
I have an SQL Server database running on a server on the internet. I
need to have php connecting to the db and returning values. Simple
stuff. No problem making the connection and getting data using the mssql
functions. The weird thing is that 4
15:32
To: [EMAIL PROTECTED]
Subject: Re: [PHP] Getting only 255 chars from SQL Server
On Sun, 12 May 2002 18:43:47 -0700, you wrote:
I have an SQL Server database running on a server on the internet. I
need to have php connecting to the db and returning values. Simple
stuff. No problem making
PROTECTED]
Subject: Re: [PHP] Getting only 255 chars from SQL Server
Taken from Microsoft SQL Server 2000 Reference (Transact-SQL Reference):
varchar[(n)]
Variable-length non-Unicode character data with length of n bytes. n
must be a value from 1 through 8,000. Storage size is the actual length
Applications Developer
www.SpryNewMedia.com
-Original Message-
From: Niklas Lampén [mailto:[EMAIL PROTECTED]]
Sent: Monday May 13, 2002 8:56 AM
To: Php-General
Subject: RE: [PHP] Getting only 255 chars from SQL Server
Oh, it's different in msSQL. My mistake, sorry.. :)
My knowledge is based
PROTECTED]]
Sent: 13. toukokuuta 2002 16:00
To: 'Php-General'
Subject: RE: [PHP] Getting only 255 chars from SQL Server
If you want to make sure you get the whole string and it's fairly long,
like a paragraph of characters or something, the db field should be a
text field. Varchar is definitely
Hi Niklas,
So can varchar be longer than 255 chars in MSSQL (or in any SQL)?
Yes. SQL Server can handle varchars up to 8,000 characters - I assume Oracle
and DB/2 are similar, but I don't know for sure.
Getting 255 characters back is a common problem that does have workarounds:
7 matches
Mail list logo