[R] MySQL and RODBC - limitations

jorgusch hackl.schorsch at web.de
Tue Mar 30 19:35:24 CEST 2010

I found the solution.
The problem was indeed R. 

Their is a simple way to solve the problem, but it just needs a bit more
If you download large integers from a database, convert it "on the fly" with

SELECT CONVERT(yourcolumn,char)

That is it. This is nor problem, as long you do NO comparisons within this
columns. If you want to find something like entry10>entry11 ('13'>'2') than
the result will be wrong, if both values do not have the same number of
characters. Hence, if you have numbers, you must fill up the empty slotes
with zeros. So it would look like:  '13'>'02'.
View this message in context: http://n4.nabble.com/MySQL-and-RODBC-limitations-tp1692743p1745570.html
Sent from the R help mailing list archive at Nabble.com.

More information about the R-help mailing list