Re: Storing Binary Data in varchar2 fields

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Tue, 17 Jun 2003 18:57:27 +0200
Message-ID: <m1iuev453p1qk4jv2qram0pjuugrn2mgjp@4ax.com>

On 17 Jun 2003 03:22:22 -0700, barkeref_at_sigcomp.com (Ed Barker) wrote:

>If my conclusions are correct, it seems strange (i.e. a deficiency in
>the product) that there is no data type similar to varchar2 but that
>tells Oracle to not perform any character translation. raw seemed to
>serve this purpose, but the docs say not to use it anymore.
>
>Can any of the gurus confirm or refute my conclusions?

The deprecation of RAWs affect LONG RAWs.

Also you have BLOBs nowadays (Binary Large OBjects) so I don't see why you insist on misusing a varchar2 for binary data.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Jun 17 2003 - 11:57:27 CDT