Hello. Here is what caused problems for me with both mySQL and PostgreSQL:
ns_dblist $h "SELECT lower([ns_dbquotevalue {ABC'DEF\'}])" Basically it quoted the string into 'ABC''DEF\'', which is not correct. Also, it does not work correctly for UTF-escapable characters. proc ns_dbquotevalue {val} { set val [string map [list "'" "''" "\\" "\\\\"] $val] return "'$val'" } Here's the code I used - it does not handle datatypes, but I never used them anyway :) Any comments on this one? -- WK