Hello,
tosql writes datatypes for variables when creating a table creation script.
But it uses the Stata datatypes for this, not the sql datatypes. I have a
column of integers, some around 36000. Stata treats this as float, but this
has a different meaning in sql. This is inconvenient as you will need
conversions or casts in the program using the sql database to make sure that
computations won't fail on the datatype.
Is there a way to improve on this? For instance via an interface to tosql
that allows for overruling the type of certain columns (or all at once).
Thank you, best regards,
-Hendri Adriaens.
--------------------------------
Hendri Adriaens
Researcher CentERdata
Tilburg University
Room K638
Warandelaan 2
PO Box 90153
5000 LE Tilburg, The Netherlands
Tel.: +31-13-466 3263 / 8325
Fax.: +31-13-466 2764
WWW: http://www.centerdata.nl
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
