in reply to Writing special characters to mysql DB

DBI::quote() should only be applied to data, not to SQL or table and column names. You may find it preferable to use placeholders in your SQL statements. They handle quoting and escaping automagically.

After Compline,
Zaxo

  • Comment on Re: Writing special characters to mysql DB

Replies are listed 'Best First'.
Re: Re: Writing special characters to mysql DB
by Anonymous Monk on Mar 10, 2002 at 14:48 UTC
    Thanks for the info. Unfortunately the MySQL & mSQL book is not very good at explaining these concepts well.

    Can you elaborate further on placeholders?

    Much appreciated

    sdyates

[reply]

      Thanks for the info. Unfortunately the MySQL & mSQL book is not very good at explaining these concepts well.

      Placeholders are not an SQL, MySQL or mSQL thing. They're a DBI invention, that helps Perl programmers. Documentation can of course be found in the DBI manual. 

      44696420796F7520732F2F2F65206F
7220756E7061636B3F202F6D736720
6D6521203A29202D2D204A75657264

[reply]

In Section Seekers of Perl Wisdom