Re: [R] RODBC and NULL values

From: Jerome Asselin <jerome.asselin_at_crchum.qc.ca>
Date: Tue 17 Oct 2006 - 14:42:51 GMT

On Tue, 2006-10-17 at 11:49 +0100, Mark Wardle wrote:
> Prof Brian Ripley wrote:
> > What sqltype(s) are your variables?
> >
>
> The variables are all numeric.

I don't think this is an RODBC issue. I've had similar problems with numeric variables in FileMaker without using RODBC.

I have exported from FileMaker to MySQL numeric variables containing non-numeric strings. Since MySQL won't allow non-numeric characters into numeric variables, empty strings and other non-numeric values were replaced by the default (0). I suppose that's the same with PostgreSQL.

You might get more luck if you first convert your variables as TEXT in FileMaker and then import them to PostgreSQL where you can reconvert them to numeric there after fixing the NULL values. It's a bit of extra work...

In my case, the strategy I used was to export the FileMaker data into XML format and then run a XSLT script to insert the data as TEXT into MySQL where I could detect and fix non-numeric strings.

Regards,
Jerome

-- 
Jerome Asselin, M.Sc., Agent de recherche, RHCE
CHUM -- Centre de recherche
3875 rue St-Urbain, 3e etage // Montreal QC  H2W 1V1
Tel.: 514-890-8000 Poste 15914; Fax: 514-412-7106

______________________________________________
R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
Received on Wed Oct 18 01:25:04 2006

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.1.8, at Tue 14 Nov 2006 - 18:30:20 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.