Hello all,

    I have a strange / interesting problem that might be 'R' settings
themselves, or it might be something with the OS.

    I am using the RODBC library.  I have a script that goes out and, before
making a query for a big data set, will first query for the column names of
the data set.  The column names could sometimes be quite long (e.g., "Time
Background Estimation (seconds)" ).  If I make this query for the column
names from my Windows laptop or from a Windows server, using odbcConnect() &
sqlQuery(), I get the column names properly.  However, if I run this via
unix, it will chop off part of the column name.  (E.g., with "Time
Background Estimation (seconds)", it becomes "Time Background Estimation
(se", which is 30 characters long.)

    Does anyone have a clue what might be causing this (settings in 'R',
something within unix, etc.)?  I am not even sure how to debug, and I can't
really get around this because I cannot simply query all of the columns, the
data set would become too large.

                                                  Thanks!
                                                          Mike




"Telescopes and bathyscaphes and sonar probes of Scottish lakes,
Tacoma Narrows bridge collapse explained with abstract phase-space maps,
Some x-ray slides, a music score, Minard's Napoleanic war:
The most exciting frontier is charting what's already here."
  -- xkcd

--
Help protect Wikipedia. Donate now:
http://wikimediafoundation.org/wiki/Support_Wikipedia/en

	[[alternative HTML version deleted]]

