Statalist The Stata Listserver

[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: tosql datatypes

From   "Hendri Adriaens" <>
To   <>
Subject   st: tosql datatypes
Date   Wed, 13 Jun 2007 08:13:37 +0200


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 

*   For searches and help try:

© Copyright 1996–2017 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index