Re: PerlDBI and quoting

[haukex]

However, when I look at the data content in SQL Developer, or when I then perform a 'select' on the table to extract the data later, it has enclosing quotes i.e. I don't get " CONTENT " - I get " 'CONTENT' ", which then interferes with string matching downstream. What have I missed?

You don't need both ->quote and placeholders (?, ?). Placeholders are The Right Way, so just use only those.

[jerryhone]

Thanks haukex - that works nicely! I was clearly being a a bit overprotective!

[haukex]

I was clearly being a a bit overprotective!

Better than not knowing Little Bobby Tables at all! :-)

[LanX]

Tangential:

at last Germany.pm online meeting we were discussing using emojis inside passwords.

Since then I'm trying to register a properly named unicode character for little Bobby ... ;D