On 8/11/2004 2:21 AM, Scott Marlowe wrote:
On Tue, 2004-08-10 at 23:42, Er GalvÃo Abbott wrote:
Greetings.
I have a question regarding performance of certain datatypes:
I have a field where I will store my clients phone numbers. I know
that this field will never exceed 15 characters, and I will sto
Thanks, Michael.
You and "Evil Azrael" (lol) got me. Never thought about leading zeros.
Varchar it is!
Thanks a lot,
--
Er Galvão Abbott
Desenvolvedor Web
http://www.galvao.eti.br/
[EMAIL PROTECTED]
Michael Glaesemann wrote:
On Aug 11, 2004, at 4:27 PM, Er Galvão Abbott wrote:
It
On Aug 11, 2004, at 4:27 PM, Er Galvão Abbott wrote:
It will. As I've said I wont be storing any symbols.
It won't store leading zeros, however. This may or may not be an issue
for you.
test=# create table tel (name_id integer not null, tel_numeric
numeric(15) not null, tel_varchar varchar(15) n
It will. As I've said I wont be storing any
symbols.
--
Er Galvão Abbott
Desenvolvedor Web
http://www.galvao.eti.br/
[EMAIL PROTECTED]
Pierre-Frédéric Caillaud wrote:
Numeric won't store that :
(+33) 4 01 23 45 67
On Wed, 11 Aug 2004 02:42:33 -0300, Er Galvão Abbott
<[EMA
Numeric won't store that :
(+33) 4 01 23 45 67
On Wed, 11 Aug 2004 02:42:33 -0300, Er Galvão Abbott
<[EMAIL PROTECTED]> wrote:
Greetings.
I have a question regarding performance of certain datatypes:
I have a field where I will store my clients phone numbers. I know that
this
field wil
On Tue, 2004-08-10 at 23:42, Er GalvÃo Abbott wrote:
> Greetings.
>
> I have a question regarding performance of certain datatypes:
>
> I have a field where I will store my clients phone numbers. I know
> that this field will never exceed 15 characters, and I will store only
> numbers here (no da
Greetings.
I have a question regarding performance of certain datatypes:
I have a field where I will store my clients phone numbers. I know that
this field will never exceed 15 characters, and I will store only
numbers here (no dashes, dots, etc...), so I was wondering:
Wich type is faster:
