Re: Text fields

2004-01-10 Thread Roger Baklund
* Segis-Eresmas > I have a table with a Text field (with texts) and Fulltext index. When > I search a word (...) f.e. 'with match...against...', How can i do it to > see the line and the line number of the text in that text-field? There is no such functionality in mysql, you would have to impleme

Re: Text fields

2003-08-28 Thread Ed Leafe
On Thursday, August 28, 2003, at 07:09 AM, Sreesekhar Palaparthy wrote: I wud like to rephrase my problemactually i want some method to insert large text/binary text values into BLOB fields in chunks , instead of inserting the values at once in entireity. So for that , i want to know h

Re: RE: Text fields

2003-08-28 Thread Sreesekhar Palaparthy
I wud like to rephrase my problemactually i want some method to insert large text/binary text values into BLOB fields in chunks , instead of inserting the values at once in entireity. So for that , i want to know how do i append text to a field. (I can tune server parameter max_allow_pa

RE: Text fields

2003-08-28 Thread Rob
For arbitrary sizes of text, try the MEDIUMTEXT or LONGTEXT column types. Data is then stored as a BLOB. Check out the docs at http://www.mysql.com/doc/en/BLOB.html -Original Message- From: Sreesekhar Palaparthy [mailto:[EMAIL PROTECTED] Sent: Thursday, August 28, 2003 9:28 AM To: [EMAIL

re: Text fields & Full text search

2003-02-27 Thread Victoria Reznichenko
On Thursday 27 February 2003 13:45, Hugo Wetterberg wrote: > Does anyone know how to use text fields (BLOB) in the full text search? You can create a fulltext index only on the VARCHAR and TEXT columns, but not on the BLOB. How to use fulltext index with TEXT columns look at: http:/

Re: Text fields & Full text search

2003-02-27 Thread Stanimir Dzharkalov
- Original Message - From: "Hugo Wetterberg" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, February 27, 2003 1:45 PM Subject: Text fields & Full text search > Does anyone know how to use text fields (BLOB) in the full text search? > Hugo You may create a fulltext indexes