Displaying 2 results from an estimated 2 matches for "longvarchar".
Did you mean:
adlongvarchar
2010 Sep 18
0
Saving long character variable to database saves timestamp instead
...d a timestamp in the database rather than a variable of 35000
characters. PostgreSQL claims that there is no limit to the length of text
in a text variable, so where does the time stamp come from? Any ideas on how
to avoid it and get all 35000 characters?
BTW. In my ODBC driver, I have set the Max LongVarChar to 65520 and doubling
it doesn't do the trick.
Have I left out any details?
> sessionInfo()
R version 2.10.1 (2009-12-14)
i386-pc-intel32
locale:
[1] LC_COLLATE=English_Ireland.1252 LC_CTYPE=English_Ireland.1252
[3] LC_MONETARY=English_Ireland.1252 LC_NUMERIC=C
[5] LC_TIME=English_Ireland...
2007 Nov 24
2
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, mydata, paramdata,
test = test, verbose = verbose, :
character data truncated in column