Create a field type DECIMAL(5,2) like for money

[Bart Pietercil]

I really don't have the time right now to explain but I couldn't agree  
less....

1) most serious sql databases understand the types Valentina is using
2) if you want speed you will need to optimise the structure of your  
database
3) if looking up the meaning of the datatypes in the wiki proves to   
be too difficult maybe you should be only the datatypes you do  
understand ?





On 10 Jul 2008, at 14:15, william humphrey wrote:

> - 0003119: [SQL] Can't create field with DECIMAL type (ruslan) -  
> resolved.
>
> How do you do this using studio?  I (like most people) have simple  
> ordinary everyday things in my database like dates, simple numeric  
> integers, money (you know two decimal places)


Maybe we are not like most people (I wouldn't know) but we choose  
Valentina because the optimization features (among which choosing the  
correct datatype is important)


> and CHAR (which I have figured out are called STRING in Valentina  
> and VARCHAR (which I'm glad you have).

You could have looked in the wiki.

>
> And while I'm asking why does Valentina have all those:
>
> LONG, SHORT, MEDIUM, UNSIGNED MEDIUM, UNSIGNED LONG, UNSIGNED LONG  
> LONG, UNSIGNED SHORT, FLOAT, DOUBLE ? Geez, I can't believe there  
> are people that understand the difference between all those kinds of  
> integer fields and use them for various important ways in their  
> database design? In an internet search I see it is from "C"  
> programming and not from SQL.
>
> Can't it be a little simpler? Simpler is usually better!

money is not simple and still this you would like to have ?

>
> I like:
>
> NUMERIC
> DECIMAL
> INTEGER
> SMALLINT
> BIGINT
>
> I can understand those. Maybe most users of Valentina Studio are  
> going to be people coming from SQL standards and not from C  
> programming?

Look at Oracle, MySQL, PostgreSQL,DB2, ... they understand these types  
and together I would say they form the SQL Standards



>
> If you used the same SQL conventions as everyone else it would also  
> be easier to import and export SQL dumps.
>
> Is the goal for Valentina Studio and the further marketing of your  
> database going to be for SQL users?
>
> Bill
>
> PS - I guess I should have kept this question simple and not ranted  
> but...
> _______________________________________________
> Valentina-beta mailing list
> Valentina-beta at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina-beta

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.macserve.net/pipermail/valentina-beta/attachments/20080710/b679c9f8/attachment.html