<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">I really don't have the time right now to explain but I couldn't agree less....<div><br></div><div>1) most serious sql databases understand the types Valentina is using</div><div>2) if you want speed you will need to optimise the structure of your database</div><div>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 ?</div><div><br></div><div><br></div><div><br></div><div><br></div><div><br><div><div>On 10 Jul 2008, at 14:15, william humphrey wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><span class="Apple-style-span" style="font-family: Courier; ">- <font color="#1509EE"><u>0003119</u></font>: <b>[SQL]</b> Can't create field with <span id="st" name="st" class="st" style="background-image: initial; background-repeat: initial; background-attachment: initial; -webkit-background-clip: initial; -webkit-background-origin: initial; background-color: rgb(255, 255, 136); background-position: initial initial; ">DECIMAL</span> type (ruslan) - resolved.</span><div> <font class="Apple-style-span" face="Courier"><br></font></div><div><font class="Apple-style-span" face="Courier">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)</font></div></blockquote><div><br></div><div><br></div><div>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)</div><div><br></div><br><blockquote type="cite"><div><font class="Apple-style-span" face="Courier"> and CHAR (which I have figured out are called STRING in Valentina and VARCHAR (which I'm glad you have).</font></div></blockquote><div><br></div><div>You could have looked in the wiki.</div><br><blockquote type="cite"> <div><font class="Apple-style-span" face="Courier"><br></font></div><div><font class="Apple-style-span" face="Courier">And while I'm asking why does Valentina have all those:</font></div><div><font class="Apple-style-span" face="Courier"><br> </font></div><div><font class="Apple-style-span" face="Courier">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.</font></div> <div><font class="Apple-style-span" face="Courier"><br></font></div><div><font class="Apple-style-span" face="Courier">Can't it be a little simpler? Simpler is usually better!</font></div></blockquote><div><br></div><div>money is not simple and still this you would like to have ?</div><br><blockquote type="cite"><div><font class="Apple-style-span" face="Courier"><br> </font></div><div><font class="Apple-style-span" face="Courier">I like:</font></div><div><font class="Apple-style-span" face="Courier"><br></font></div><div><font class="Apple-style-span" face="Courier">NUMERIC</font></div> <div><font class="Apple-style-span" face="Courier">DECIMAL</font></div><div><font class="Apple-style-span" face="Courier">INTEGER</font></div><div><font class="Apple-style-span" face="Courier">SMALLINT</font></div><div><font class="Apple-style-span" face="Courier">BIGINT</font></div> <div><font class="Apple-style-span" face="Courier"><br></font></div><div><font class="Apple-style-span" face="Courier">I can understand those. Maybe most users of Valentina Studio are going to be people coming from SQL standards and not from C programming?</font></div></blockquote><div><br></div><div>Look at Oracle, MySQL, PostgreSQL,DB2, ... they understand these types and together I would say they form the SQL Standards</div><div><br></div><div><br></div><br><blockquote type="cite"> <div><font class="Apple-style-span" face="Courier"><br></font></div><div><font class="Apple-style-span" face="Courier">If you used the same SQL conventions as everyone else it would also be easier to import and export SQL dumps.</font></div> <div><font class="Apple-style-span" face="Courier"><br></font></div><div><font class="Apple-style-span" face="Courier">Is the goal for Valentina Studio and the further marketing of your database going to be for SQL users?</font></div> <div><font class="Apple-style-span" face="Courier"><br></font></div><div><font class="Apple-style-span" face="Courier">Bill</font></div><div><font class="Apple-style-span" face="Courier"><br></font></div><div><font class="Apple-style-span" face="Courier">PS - I guess I should have kept this question simple and not ranted but...</font></div> _______________________________________________<br>Valentina-beta mailing list<br><a href="mailto:Valentina-beta@lists.macserve.net">Valentina-beta@lists.macserve.net</a><br>http://lists.macserve.net/mailman/listinfo/valentina-beta<br></blockquote></div><br></div></body></html>