[Ruby-DBI-devel] Bug in string handling for DBI?

[James F.H. <jf...@ci...>]

There appears to be a bug in the string handling for either DBI#prepare
and DBI#execute, or else in the corresponding routines in the Pg driver.

When attempting to insert a Windows pathname such as 

	C:\this\is\a\path

the backslash and the next char are getting interpolated as an escaped
character, leading to garbage being inserted into the table.

I tried using Regexp.escape, but that ends up putting the backslashes
used to escape the characters into the table as well, which I'd like 
to avoid.

Does anyone know if there's a quick fix for this?

----------------------------------------------------------------------
| Jim Hranicky, Senior SysAdmin                   UF/CISE Department |
| E314D CSE Building                            Phone (352) 392-1499 |
| jf...@ci...                      http://www.cise.ufl.edu/~jfh |
----------------------------------------------------------------------

"Given a choice between a complex, difficult-to-understand, disconcerting
 explanation and a simplistic, comforting one, many prefer simplistic
 comfort if it's remotely plausible, especially if it involves blaming
 someone else for their problems."
                                                -- Bob Lewis, _Infoworld_