Integer storage

Deane Venske deane.venske at eduss.com
Tue Feb 10 19:37:51 CST 2004


On Tue, 10 Feb 2004 09:39:30 +0200, Ruslan Zasukhin 
<sunshine at public.kherson.ua> wrote:

> on 2/10/04 1:00 AM, Deane Venske at deane.venske at eduss.com wrote:
>
>> I'm wanting to store a timestamp YYYYMMDDHHMMSS
>> I've come to not trust any date functionality in any program.
>
> :-)
>
>> I want to
>> handle dates myself when it comes to storage. I've had countless 
>> problems
>> with every DB I've used (MySQL, Access) and prefer a method I know 
>> works.
>> But ATM I use a Varchar(14) and it's working great. Thought I'd see if I
>> could be a little more effecient.
>
> Yes,
>
> For string 14 bytes length, better use STRING[14]
> Will be more effective of VarChar
>
>
Ok thanks Ruslan I will keep this in mind. Should all VarChars be strings? 
When is each more efficient?


-- 
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/


More information about the Valentina mailing list