Re: index a mysql database -blob field

2010-01-30 Thread luciusvorenus
dex.ANALYZED));""" >> >> but how can i index a blob? >> >> the field txt is a blob ... with rs.geBlob(txt) ? >> >> thank u >> >> thank >> > > ----- > To unsub

Re: index a mysql database -blob field

2010-01-30 Thread luciusvorenus
.Store.NO, >> Field.Index.ANALYZED));""" >> >> but how can i index a blob? >> >> the field txt is a blob ... with rs.geBlob(txt) ? >> >> thank u >> >> thank >> > > --------- > To unsubscribe, e-mail: java-user-unsubscr...@lucene.

Re: index a mysql database -blob field

2010-01-29 Thread Chris Lu
For blob, it is not so simple since BLOB could contain different file types, like HTML, pdf, word, zip file type. So besides getting results out via resultSet.getBlob() function, you will need to convert the binary stream into simple text strings. DBSight free version already can read the blog

Re: index a mysql database -blob field

2010-01-29 Thread Ian Lea
Search google for converting mysql BLOBs to text. Or look at the ResultSet stream methods in conjunction with the Field constructors that take Readers. Maybe something like new Field(txt, new InputStreamReader(rs.getBinaryStream(txt)) -- Ian. On Fri, Jan 29, 2010 at 6:10 PM, luciusvorenus w

index a mysql database -blob field

2010-01-29 Thread luciusvorenus
helo One more question to blob : ""d.add(new Field("txt", rs.getString("subject"), Field.Store.NO, Field.Index.ANALYZED));""" but how can i index a blob? the field txt is a blob ... with rs.geBlob(txt) ? thank u thank -- View this message in