Re: [Slashcode-development] RFC: SQL Placeholders

[Stephen C. <the...@wa...>]

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

On Sat, Apr 07, 2001 at 08:11:03PM -0700, Eric Dannewitz wrote:
> Why not use VARCHAR2 in Oracle? From what I remember of Oracle, that is a much
> better variable than VARCHAR

Currently VARCHAR == VARCHAR2 in Oracle.  Makes you wonder why they have two
different names, but then there are lots of things you tend to wonder about
Oracle.  Officially the docs say they may develop differences in a future 
version, but they also said that 8i would finally break the infuriatingly 
annoying '' == NULL behavior (which is also mucking up its share of things in
my porting attempts).  I'm not looking for either change to happen soon.

In any case, the maximum length of VARCHAR* is 4000 bytes; beyond that you must 
use *LOB.  The templates are well beyond that limit, and inevitably some user 
comments will be as well, so the use of LOB is unavoidable here.  My original 
problem remains.

- -- 
Stephen Clouse <the...@wa...>
warpcore.org Founder, Chief Megalomaniac, and Evil Overlord

-----BEGIN PGP SIGNATURE-----
Version: PGP 6.5.8

iQA/AwUBOs/kvt1EXk7JbKbMEQINbwCgjITyQNrtg1oQEQTKFoWXMX1ZZhsAoPxp
y6U7l/03EO7Zv8yLkoX96ght
=JIu4
-----END PGP SIGNATURE-----