On 2002-02-28 14:25:26 -0700, Sterin, Ilya wrote: > Well do you want the default to go back to CHAR?
If that's what is necessry, yes. The default, if you store a string in a
varchar2 column, should be to store that string exactly as is[1], and not
strip spaces. If I want to strip spaces, I can do that myself, or I can
tell oracle to do it by using bind_param to choose a non-default data
type. But the default should not perform any surprising data
conversions.
hp
[1] Yes, I am aware that you cannot store an empty string, but that's
oracle's fault. A limitation of the DBMS, just like the 4000 byte limit
or the 38 digit limit in numbers. But DBI should not introduce any
additional limits.
--
_ | Peter J. Holzer | My definition of a stupid question is
|_|_) | Sysadmin WSR / LUGA | "a question that if you're embarassed to
| | | [EMAIL PROTECTED] | ask it, you stay stupid."
__/ | http://www.hjp.at/ | -- Tim Helck on dbi-users, 2001-07-30
msg09282/pgp00000.pgp
Description: PGP signature
