SQL Memo datatype

#1

Hi,

In SQL Server 6.5 we have a datatype Memo, do we have the same datatype in
SQL Server 2000?
Thanks for help.

Jason

#2

The closest eqivalent would be TEXT. But if your maximum data size is
smaller than 8000 characters, I recommend instead using VARCHAR.

--
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--

"Jason Huang" <JasonHuang8888 (AT) hotmail (DOT) com> wrote

Quote:

Hi,

In SQL Server 6.5 we have a datatype Memo, do we have the same datatype in
SQL Server 2000?
Thanks for help.

Jason

#3

Quote:

In SQL Server 6.5 we have a datatype Memo

There's no such datatype in 6.5. So either you have a user defined datatype that you named "Memo",
or you are confusing your 6.5 installation with some other DBMS.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/

"Jason Huang" <JasonHuang8888 (AT) hotmail (DOT) com> wrote

Quote:

Hi,

In SQL Server 6.5 we have a datatype Memo, do we have the same datatype in SQL Server 2000?
Thanks for help.

Jason

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SQL Memo datatype

microsoft.public.sqlserver.server microsoft.public.sqlserver.server

SQL Memo datatype - 12-30-2005 , 09:12 PM

Re: SQL Memo datatype - 12-30-2005 , 09:25 PM

Re: SQL Memo datatype - 12-31-2005 , 01:22 AM