Re: sort orderings
Re: sort orderings
- Subject: Re: sort orderings
- From: Francis Labrie <email@hidden>
- Date: Thu, 29 Apr 2004 10:55:31 -0400
Hi,
Le 29 avr. 2004, ` 10:39, John Spicer a icrit :
Doing the sort now with the data type changed from text to char allows
the sort to work correctly.
It still does not answer the question WHY!
TEXT attributes are not stored the same way CHAR are in OpenBase, and
this affect the way it's sorted. A TEXT is more something like a BLOB.
This is what the OpenBase documentation says:
"The object and text data-types are used to store BLOB (Binary Large
Objects) ids for image or other binary data. Object and TEXT fields
have a special mechanism that will automatically erase old BLOBs when
updated with a new BLOB id. When records are deleted, the database will
also automatically remove associated BLOBs.
The TEXT date-type is used for storing large amounts of text where
previously the data-type OBJECT would have been used. The difference
between these types is that the TEXT type applies a text encoding to
the data so that it appears correctly no matter what encoding the
client computer is using. The OBJECT data type stores binary data and
does not try to apply a text encoding.
For efficiency reasons, Object and Text data (BLOBs) are not stored in
the records themselves. Because of their potentially large size they
are kept in a separate area and referenced using a BLOB id which
connects the blobs to the record columns. Methods in the various
OpenBase APIs available allow you to retrieve BLOB information when you
need it using the BLOB id value stored in the column."
--
Francis Labrie
Saint-Bruno-de-Montarville, Quebec, Canada
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.