| ![]() |
From | Kit Baum <baum@bc.edu> |
To | statalist@hsphsun2.harvard.edu |
Subject | st: Re: tosql datatypes |
Date | Wed, 13 Jun 2007 06:54:17 -0400 |
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).
* * 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/
© Copyright 1996–2025 StataCorp LLC | Terms of use | Privacy | Contact us | What's new | Site index |