Re: Table with Text values
Posted by: Rick James
Date: December 16, 2015 10:25PM

If you can limit it to 255, you can make it UNIQUE and not have to worry about hashes and other kludges.

If you need more than 255 (actually 767 bytes), then the `hash` trick will work. Suggest a 32-bit hash of some kind. Even if there are collisions in `hash`, you will verify by checking `text`.

Options: ReplyQuote


Subject
Written By
Posted
December 13, 2015 09:28AM
December 13, 2015 10:44AM
December 14, 2015 01:05AM
December 14, 2015 08:02AM
Re: Table with Text values
December 16, 2015 10:25PM
December 16, 2015 10:27PM
December 17, 2015 03:53AM
December 17, 2015 01:00PM
December 17, 2015 03:52PM
December 18, 2015 05:34PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.