Re: varchar and text
From: JohnnyAppleseed (someone_at_microsoft.com)
Date: 02/08/05
- Next message: rodchar: "MS Access function in SQL Server?"
- Previous message: Simo Sentissi: "Business intelligence training and Cert from Microsoft"
- In reply to: Agoston Bejo: "varchar and text"
- Next in thread: Mal .mullerjannie_at_hotmail.com>: "RE: varchar and text"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 8 Feb 2005 11:36:19 -0500
You would use the Indexing Service for searching text columns.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql7/html/filedatats.asp
"Agoston Bejo" <gusz1@freemail.hu> wrote in message
news:%23DSTqWfDFHA.1668@TK2MSFTNGP10.phx.gbl...
> Hi!
> I know that varchar is only able to store string data up to 8000 bytes,
> whereas text up to 2 Gig or so.
> Somebody told me that you cannot search in text-type fields, i.e. you
cannot
> use LIKE '%abc%' and things like that. I tried it (on SQL Server 7),
> inserted some short text, and LIKE worked just fine. Does it work also
when
> some longer string inserted? Or is it only a rumor? Are there any
> disadvantages of using text-type fields instead of varchar's?
>
> Thx,
> Agoston
>
>
- Next message: rodchar: "MS Access function in SQL Server?"
- Previous message: Simo Sentissi: "Business intelligence training and Cert from Microsoft"
- In reply to: Agoston Bejo: "varchar and text"
- Next in thread: Mal .mullerjannie_at_hotmail.com>: "RE: varchar and text"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
