Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down at the end of May, and its replacement, statalist.org is already up and running.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: odbc working differently in windows and linux


From   tashi lama <ltashi32@hotmail.com>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: odbc working differently in windows and linux
Date   Wed, 29 Aug 2012 20:19:17 +0000

Hello all, 
    I use odbc driver to import data from mysql into stata. While running in windows, the column doc_type which is of type varchar in mysql changes into str244 in stata. Unfortunately, in linux machine, when I use odbc to import column doc_type which is type varchar, I get error and I quote "note:doc_type is of a type not supported in Stata;skipped" 

.set odbcmgr unixodbc 
.odbc query indigo_readership 
readership 
users
......
.odbc desc readership 
variable name    variable type
source_id          integer
doc_id             varchar
doc_title          varchar

. odbc load, exec("select * from readership limit 3")
note: doc_id is of a type not supported in Stata; skipped
note: doc_title is of a type not supported in Stata; skipped

but if i select just source_id, it works 
.odbc load, exec("select source_id from readership limit 3")
93619   =>stata is happy 

The funny thing is, if I run the same query in windows, stata is happy. Does anyone know what is going on?

Thanks, 
Tashi  		 	   		  
*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/


© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index