st: odbc working differently in windows and linux

[tashi lama <ltashi32@hotmail.com>]

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/