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

2002-05-21 Thread Tim Greenleaf
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

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 4

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

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

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

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

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

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

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

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

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: