Re: [PHP] Getting only 255 chars from SQL Server

2002-05-21 Thread Tim Greenleaf
-- > From: Michael Sims [mailto:[EMAIL PROTECTED]] > Sent: 13. toukokuuta 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 serv

RE: [PHP] Getting only 255 chars from SQL Server

2002-05-13 Thread Jon Haworth
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: http://www.goo

RE: [PHP] Getting only 255 chars from SQL Server

2002-05-13 Thread Niklas Lampén
lto:[EMAIL 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.

RE: [PHP] Getting only 255 chars from SQL Server

2002-05-13 Thread Matt Friedman
iedman Web 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 knowle

RE: [PHP] Getting only 255 chars from SQL Server

2002-05-13 Thread Niklas Lampén
EMAIL 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 leng

RE: [PHP] Getting only 255 chars from SQL Server

2002-05-13 Thread Niklas Lampén
kuuta 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

Re: [PHP] Getting only 255 chars from SQL Server

2002-05-13 Thread Michael Sims
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

[PHP] Getting only 255 chars from SQL Server

2002-05-12 Thread David McGregor
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 of the fields in the table are vchar fields of l