search for: longvarchar

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