Hi all!
Is there any data type that allows more than 255 characters using SQL
Server 6.5? If not ... could you tell me how to do it?
Thanks in advance,
Xavi.
Sent via Deja.com http://www.deja.com/
Before you buy.
by Xavier Aspa » Wed, 20 Oct 1999 04:00:00
Is there any data type that allows more than 255 characters using SQL
Server 6.5? If not ... could you tell me how to do it?
Thanks in advance,
Xavi.
Sent via Deja.com http://www.deja.com/
Before you buy.
by Russell Brid » Wed, 20 Oct 1999 04:00:00
by BPMargoli » Wed, 20 Oct 1999 04:00:00
As Russell has replied, SQL Server has a limit of 255 on CHAR datatypes,
however you can use TEXT datatypes so store more than 255 bytes.
As you may know, SQL Server 7.0 has expanded the limit on the CHAR datatype
to 8000 bytes, so if you need a compelling reason to upgrade to SQL Server
7.0, this may be it.
Quote:> Hi all!
> Is there any data type that allows more than 255 characters using SQL
> Server 6.5? If not ... could you tell me how to do it?
> Thanks in advance,
> Xavi.
> Sent via Deja.com http://www.deja.com/
> Before you buy.
1. migrating sql databases sever 6.5 from sql server 6.5 to another sql server 6.5
Hi, i got some sql database installed on a sql server 6.5 with win NT 4.0
server
i'm doing a parrallel installation of the winNT server on a new machine,
evrey thing is doing fine except the fact that ho do i do to
migrating sql sever 6.5 from sql server 6.5 to another sql server 6.5
that's the big problem
thanks
for your help
A.T
3. Need help storing large text and images into SQL Server 6.5
5. Implementing Large DB on SQL Server 6.5/7.0
6. last time a table was update
7. Ned help storing large text and images into SQL Server 6.5
8. Which of the following is NOT a common characteristic of EQUIJOIN and NATURAL JOIN?
9. SQL Server 6.5 Error -- TDS Buffer Length Too Large
10. Need help storing large text and images into SQL Server 6.5
11. Trying to fetch large text/memofields from SQL server 6.5 using ASP fails
12. different behaviour of string concatenation in SQL-server 7.0 com pared to 6.5
13. SQL Server 6.5 string length