Re: [R] truncated fields with RODBC

and what size of number I was looking for. cheers, Mikkel - Original Message From: Prof Brian Ripley <[EMAIL PROTECTED]> To: Mikkel Grum <[EMAIL PROTECTED]> Cc: [EMAIL PROTECTED] Sent: Sunday, November 25, 2007 2:05:37 PM Subject: Re: [R] truncated fields with RODBC

Re: [R] truncated fields with RODBC

Thanks. I tried the following syntax and got the same error message: sqlSave(pg, Grids, append = TRUE, rownames = FALSE, typeInfo = list(double = "double precision", integer = "integer", character = "text")) Warning messages: 1: In odbcUpdate(channel, query, mydata, paramdata, test = tes

Re: [R] truncated fields with RODBC

You need to study the RODBC documentation: you haven't set the type of the character fields in the database table correctly (in fact, you seem not to have set them at all, hence will get the default of varchar(255)). The 64k limit is for reading, not writing. As ever, full details and a reprodu

[R] truncated fields with RODBC

I'm changing some functions from storing data in SQLite (using RSQLite) to storing it in PostgreSQL (using RODBC). When trying to store very long character fields I get the following message: >sqlSave(pg, Grids, rownames = FALSE, append = TRUE) Warning messages: 1: In odbcUpdate(channel, query