Re: storing byte values

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

pascal.dulleck_at_veda.net wrote:
> Hello!
> I've got a problem with byte values in Oracle (version 10g). I need to
> store a fixed number of bytes. Usually it's less then 10 kilobytes.

"Usually" and "fixed" do not match...

> I tried to use the data type RAW, but there is a limitation that only
> one column of this type may be created in a table. But I need more
> than one column per table. Then I tried to use BLOB, but BLOB fields
> can't be used in the primary key. As I need to migrate an existing
> database, I have no influence on the primary key. I need it, so that
> the unique constraint is correct.

Of course you do - you do the migration!

> I tried to use NCHAR columns as well, but some byte values seem to be
> unbound. The value I read from the database is not the same that I
> have written.
>
> Does anybody have an idea for this?

Rework the model to something more "standard"; I can hardly believe you store byte values, *and* use them as primary keys.

Describe your model, and one or two tables as example.

You are familiar with the Migration Workbench by Oracle? - --
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)

iD8DBQFGuGv9Lw8L4IAs830RArN6AJ48N7PkSZvEyIzoZz5WZDrbn/3LCwCgh4IN D5vBMJm7LZBTC7vZ52sDll0=
=jOoB
-----END PGP SIGNATURE----- Received on Tue Aug 07 2007 - 07:56:29 CDT