MySQL text type field

2002-03-07 Thread Alexander Petrov
Hi there, I am interested if there any URL I can read more about text type fields in MySQL. I had an argument with a friend who said that if I use text type in a table it will make the system to work to slow. But I realy needed this text field because I wanted to store text more than 256 symbols.

Re: MySQL text type field

2002-03-07 Thread DL Neil
Hi Alexander, I am interested if there any URL I can read more about text type fields in MySQL. I had an argument with a friend who said that if I use text type in a table it will make the system to work to slow. But I realy needed this text field because I wanted to store text more than

Re: MySQL text type field

2002-03-07 Thread Alexander Petrov
On Thu, 7 Mar 2002 12:03:05 - DL Neil [EMAIL PROTECTED] wrote: Hi Alexander, I am interested if there any URL I can read more about text type fields in MySQL. I had an argument with a friend who said that if I use text type in a table it will make the system to work to slow.

Re: MySQL text type field

2002-03-07 Thread Alexander Petrov
Alexander, go ahead and use those fields of type TEXT. Retrieval works like a charm. Building the index on large tables may be slow, but the manual gives some tricks how to speed things up. As soon as you have VARCHAR fields you are into variable record lengths anyway. And you can even