On Tuesday 15 August 2006 12:45, Torsten Leidig wrote:
> Thanks for the helpful comments. I changed the field size to 1000, which
> resulted in type TEXT and the index won't work (for InnoDB). So I
> dropped the index and activated a FULLTEXT index for value_xsd. This
> seems to work. However, search doesn' work for larger values, which
> might be due to the HTTP query request string.
The main reason for the given limitation is the problem with the index, whi=
we really need for acceptable search performance. So the limitation will=20
persist in future releases (though I might add some check that reports the=
problem). I still wonder why the search (the simple one or <ask>?) does not=
work, but I guess this is a minor issue that could be fixed. We will rewrit=
the simple semantic search for the next version anyway.
> S Page schrieb:
> > Torsten Leidig wrote:
> >> Hower, if I look at the RDF export, the attribute text is truncated
> >> to 256 characters. Is this a bug in RDF export or a limitation in the
> >> length of an attribute of type String?
> > I think the latter. SMW stores the string attribute value in the
> > database field smw_attributes.value_xsd, which is varchar(255). I
> > found I could only store 255 plain ASCII characters. I think 255 is
> > also the length of a page title in MediaWiki, though if you try to
> > edit a page with a long title you get a "Bad title" error. Maybe the
> > SMW string datatype should display an error.
> > There are other bugs resulting from this, e.g. the fact box's quick
> > search won't find the page's long attributes -- it searches for LIKE
> > the long text in the page, but the attributes table has the truncated
> > text.
> >> Is there a workaround?
> > The table definition is in SMW_Storage.php's smwfMakeSemanticTables(),
> > or you could attempt to ALTER the underlying table by executing SQL. I
> > don't know what other code knows about or depends on the length limit.
> > Hope this helps. I added a mention of this limit in
> > http://wiki.ontoworld.org/wiki/Type:String.
> > --
> > =3DS
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job
> easier Download IBM WebSphere Application Server v.1.0.1 based on Apache
> Semediawiki-user mailing list
Institute AIFB, University of Karlsruhe, D-76128 Karlsruhe
mak@... phone +49 (0)721 608 7362
http://www.aifb.uni-karlsruhe.de/WBS/ fax +49 (0)721 693 717