Re: VARCHAR vs NUMBER
From: Martin Bronstein <marty_at_amelia.sp.trw.com>
Date: 1995/10/25
Message-ID: <46mi3b$dal_at_ns5.nba.TRW.COM>#1/1
Date: 1995/10/25
Message-ID: <46mi3b$dal_at_ns5.nba.TRW.COM>#1/1
smurray_at_booz.bah.com (Murray Shane) wrote:
>Q: Is there an advantage in storing a "number" as a NUMBER data
>type given that I don't need to
>do any mathematical operations on this number field?
>
>The scenario I have is this: I want to store a case tracking number
>that is currently a NUMBER
>data type. What if this were a VARCHAR(x) data type? I could then
>use letters and numbers.
>
>Is there a performance issue on sorting, finding, etc.?
>
>--
>--Shane Murray (offsite)
>
>*** Make sure to reply to ***
>*** smurray_at_booz.bah.com ***
Sorting 'numbers' as varchar fields will produce an unexpected result:
1
10
11
12
13
14
15
16
17
18
19
2
20
21
22
Received on Wed Oct 25 1995 - 00:00:00 CET