Hi, thanks for reply. I use Zend_Db to generate my queries, creating a select() object and then pass it to the query() method or to the fetchAll() method, depending if I have to iterate the data or not.
My database table uses the utf8_unicode_ci charset. Actually I removed all escaping function from my variables and everything works correctly, so I think Zend_Db do the work internally. I just need to have this confirmed :) Thank you Sergio Rinaudo Subject: RE: [fw-general] How to save a string with quotes correctly to the db Date: Thu, 11 Jun 2009 09:39:27 +0200 From: [email protected] To: [email protected]; [email protected] Depends on what you are using, Zend_db, or directly an extension. Could you show us the code where you create and execute your query to the database? Met vriendelijke groet, Martin de Keijzer consultant Reduitlaan 33 . 4814 DC Breda . kvk 20096422 t +31 76 888 00 88 . f +31 76 888 00 89 e [email protected] . i http://www.e-sites.nl Deze e-mail is uitsluitend bestemd voor de geadresseerde(n). Verstrekking aan en gebruik door anderen is niet toegestaan. e-sites sluit iedere aansprakelijkheid uit die voortvloeit uit elektronische verzending. This e-mail is intended exclusively for the addressee(s), and may not be passed on to, or made available for use by any person other than the addressee(s). e-sites rules out any and every liability resulting from any electronic transmission. Van: Sergio Rinaudo [mailto:[email protected]] Verzonden: donderdag 11 juni 2009 9:05 Aan: [email protected] Onderwerp: [fw-general] How to save a string with quotes correctly to the db Hello, I'm having a problem on saving descriptions ( long strings ) that have quotes within them. So, I am asking which is the correct way to filter the string variable, before save it to the db, and how to render it after getting from the database. Thanks Sergio Rinaudo Scarica Messenger gratis: comunica, divertiti e condividi rapidamente! _________________________________________________________________ Messenger 2009: vieni a scoprire tutte le novità ! http://www.messenger.it/
