Path: text.usenetserver.com!out03a.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!g4g2000hsf.googlegroups.com!not-for-mail
From:  pascal.dulleck@veda.net
Newsgroups: comp.databases.oracle.misc
Subject: Re: storing byte values
Date: Wed, 08 Aug 2007 00:45:55 -0700
Organization: http://groups.google.com
Lines: 23
Message-ID: <1186559155.626327.95780@g4g2000hsf.googlegroups.com>
References: <1186490352.387891.259240@w3g2000hsg.googlegroups.com>
   <1186491398.883576.199920@r34g2000hsd.googlegroups.com>
   <1186497885.316099.125510@b79g2000hse.googlegroups.com>
   <1186501829.760107.111940@d55g2000hsg.googlegroups.com>
   <1186509159.560762.49130@d55g2000hsg.googlegroups.com>
NNTP-Posting-Host: 217.6.189.98
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
X-Trace: posting.google.com 1186559155 8885 127.0.0.1 (8 Aug 2007 07:45:55 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 8 Aug 2007 07:45:55 +0000 (UTC)
In-Reply-To: <1186509159.560762.49130@d55g2000hsg.googlegroups.com>
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.8.1.6) Gecko/20070725 Firefox/2.0.0.6,gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: g4g2000hsf.googlegroups.com; posting-host=217.6.189.98;
   posting-account=ps2QrAMAAAA6_jCuRt2JEIpn5Otqf_w0
Xref: usenetserver.com comp.databases.oracle.misc:249151
X-Received-Date: Wed, 08 Aug 2007 03:45:56 EDT (text.usenetserver.com)

Thanks, Vladimir, for your suggestion. I will give it a try.

Daniel, you are right. I can't explain the need for this requirement,
because I don't understand the reason. Actually, I don't even know the
reason. That's because there are several reasons from different
applications and there will be more in the future. My task is not to
migrate one single database with clear requirements and background
information, but to create a generic migration for several (and
presently unknown) databases. So all I have are the technical
possibilities of the origin DBMS (which is DB2 for iSeries, by the
way). And maybe I can make a few careful assumptions about the
necessity for some possibilities. But still, this leaves me with the
requirement to store byte values and to include them in a unique
constraint.
If this is not possible in Oracle, then I have to find a workaround or
the best compromise.

I understand that what Daniel, Sybrand and Frank were advising is
usually the best way. But it just does not work for me.

Well, no need to discuss this endlessly. I appreciate your answers.
Hopefully, next time I come up with a more "standard" question... ;-)