Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: integer vs integer external in .ctl file
On 8 Sep 2005 13:48:35 -0700, "cumin" <jkilbourne_at_gmail.com> wrote:
>Looking on the web, I found that integer values in the .ctl file can be
>changed to char() with a number of digits spcified in the parens.
>Changing my .ctl file in that way does work. The other solution is to
>change "integer" to "integer external" in the .ctl file. My question
>is, "Why is this so?" I didn't find this well-documented.
The first 'solution' is a bad idea as it will allow non-numerics in
your data. Eventually Oracle will reject them, but you leave the
conversion to the database.
Integer external just means your numbers aren't stored in binary (O/S
specific) form, but in whatever characterset is on the O/S.
-- Sybrand Bakker, Senior Oracle DBAReceived on Fri Sep 09 2005 - 00:19:07 CDT