RE: st: could it be a bug in odbc??

[tashi lama <ltashi32@hotmail.com>]

Here is a post somewhat similar in the archive

http://www.stata.com/statalist/archive/2003-01/msg00377.html

If odbc indeed is adding some black characters while converting string as the post reads, and if string exceeds its limitation, stata doesn't skip strings. It truncates. Is that not right? 

Thanks
----------------------------------------
> From: joshua.birnbaum@bluematrix.com
> To: ltashi32@hotmail.com
> Subject: RE: st: could it be a bug in odbc??
> Date: Thu, 30 Aug 2012 12:23:05 -0400
>
> Hi Tashi,

>
> It's certainly possible. Modern software has many moving
> parts. To that end, it's the data type transformations that
> have to occur for Stata to talk to MySQL and MonetDB that
> I'm really interested in. It is an interesting problem.
>
> I've spent a lot of time doing Unix and Linux systems
> programming in C and C++. Data typing in these kinds of
> environments is something that you must be very careful
> with.
>
> My money is on our waiting for Stata to get back to us.
>
> Thanks,
>
> Josh Birnbaum
> Systems & Network Engineer
> BlueMatrix, New York
> Tel: (646) 556-7478
> Cel: (646) 338-9861
>
>
> > -----Original Message-----
> > From: tashi lama [mailto:ltashi32@hotmail.com]
> > Sent: Thursday, August 30, 2012 12:10 PM
> > To: joshua.birnbaum@bluematrix.com
> > Subject: FW: st: could it be a bug in odbc??
> >
> >
> >
> > ----------------------------------------
> > > From: jcoveney@bigplanet.com
> > > To: statalist@hsphsun2.harvard.edu
> > > Subject: Re: st: could it be a bug in odbc??
> > > Date: Fri, 31 Aug 2012 01:03:03 +0900
> > >
> > > Tashi Lama wrote:
> > >
> > > I posted this question yesterday and failed to hear any
> > responses.
> > > Could be because the way I framed my question. So, I am
> > attempting to
> > > make it more clear and concise. The problem is with odbc
> > running in
> > > unix. I have a table "readership" in mysql which has a
> > column
> > > doc_title of type varchar. While running in windows,
> odbc
> > imports that column in stata with data type string.
> > > This runs in par with the stata documentation which
> lists
> > string as
> > > the corresponding stata datatype to varchar in SQL. The
> > problem arises
> > > while running Stata in unix. Stata skips the the column
> > doc_title and
> > > gives the following notice.
> > > note: doc_title is of a type not supported in Stata;
> skipped
> > >
> > > This is so confusing. Did anyone encounter this problem?
> > Any hint or
> > > solution will be highly appreicated.
> > >
> > >
> ------------------------------------------------------------
> ----------
> > > ----------
> > >
> > > I don't know anything about MySQL, but is sounds as if
> > your settings
> > > for the VARCHAR columns or for the Unix ODBC driver are
> > telling Stata
> > > that the VARCHAR columns are coming across as BLOB or
> > as Unicode.
> > > Stata cannot read those, and so it gives the "type not
> > supported" error.
> > >
> > > It's just a guess, but I cannot imagine that whatever
> our
> > problem is
> > > is inherent in MySQL under Unix. There are several
> others
> > on this list
> > > who I believe use MySQL, perhaps also under Unix or
> > Linux, and if what
> > > your experiencing were an ingrained bug (as opposed to
> > some kind of
> > > settings problem), it would probably have come up
> > before.
> > >
> > > Check the way that you've got MySQL and the ODBC driver
> > set up on your
> > > equipment: see whether your VARCHAR columns are set
> > up as something
> > > analogous to Microsoft SQL Server's VARCHAR(MAX) (that
> > is, similar to
> > > a BLOB), or whether there's a toggle setting for the
> ODBC
> > driver
> > > somewhere having to do with automatically converting
> > character data
> > > into Unicode or something during passage.
> > >
> > > Joseph Coveney
> > >
> > >
> > > *
> > > * 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/
> >
>
> 		 	   		  
*
*   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/