Re: [nyphp-talk] Programs rights and Lic etc.

2013-02-05 Thread Eugenio Tacchini
uences but maybe you can further investigate. -- Dr. Eugenio Tacchini, Ph.D. *Freelance Software Analyst and Developer, Milan Area, Italy* *Lecturer of Information Systems, Catholic University of Piacenza, Italy* *Researcher in Music Recommender Systems* *D

Re: [nyphp-talk] UTF-8, databases and best practices

2012-05-24 Thread Eugenio Tacchini
>> 2) How to handle the fact that the data I receive from the database >> can be stored using any possible charset? Do I need iconv functions >> and convert everything in utf-8? And then convert it back in the >> original charset when I have to write to the DB? > > I'd be interested to hear other's

[nyphp-talk] UTF-8, databases and best practices

2012-05-23 Thread Eugenio Tacchini
Hi all, I need to distribute an application that potentially can be used with many different DBMSs (such as MySQL, PostgreSQL, SQLite, Microsoft SQL Server). The charset used in the databases can be ANY. I would like to always output UTF-8 text when possible and my questions are about the current

[nyphp-talk] UTF-8, databases and best practices

2012-05-19 Thread Eugenio Tacchini
Hi all, I need to distribute an application that potentially can be used with many different DBMSs (such as MySQL, PostgreSQL, SQLite, Microsoft SQL Server). The charset used in the databases can be ANY. I would like to always output UTF-8 text when possible and my questions are about the current

[nyphp-talk] UTF-8, databases and best practices

2012-05-16 Thread Eugenio Tacchini
Hi all, I need to distribute an application that potentially can be used with many different DBMSs (such as MySQL, PostgreSQL, SQLite, Microsoft SQL Server). The charset used in the databases can be ANY. I would like to always output UTF-8 text when possible and my questions are about the current

Re: [nyphp-talk] un-escape db content using php or ADOdb functions

2012-05-02 Thread Eugenio Tacchini
2012/5/2 Hans Zaunere : > If you've inherited an application that does this, then it could be painful. Yes, that's the point :) ------ Eugenio Tacchini dadabik.org DaDaBIK database front-end ___ New York PHP User Group C

Re: [nyphp-talk] un-escape db content using php or ADOdb functions

2012-05-02 Thread Eugenio Tacchini
ents is already escaped and your problem is to > un-escape, try to understand how is escaped, then str_replace or > preg_replace will do the job! Yes, that's one point, it's not always clear what the escape functions did (unless you don't want to look inside the PHP source code)

Re: [nyphp-talk] un-escape db content using php or ADOdb functions

2012-05-02 Thread Eugenio Tacchini
2012/5/2 Rob Marscher : > > On May 2, 2012, at 1:08 PM, Eugenio Tacchini wrote: >> Now, I'm wondering if the DB specific escape functions really give >> additional values respect to addslashes. > > Chris Shiflett's article from 2006 had the best argument I&#

Re: [nyphp-talk] un-escape db content using php or ADOdb functions

2012-05-02 Thread Eugenio Tacchini
to make them easier to read in log files." it seems that, if we are talking about queris execution, just \ and ' needs to be escaped. What do you think about? -- Eugenio Tacchini dadabik.org DaDaBIK database front-end ___ New Y

[nyphp-talk] un-escape db content using php or ADOdb functions

2012-05-02 Thread Eugenio Tacchini
rk if you switch from addslashes to something like adodb->qstr. Thanks in advance. Cheers, -- Eugenio Tacchini dadabik.org DaDaBIK database front-end ___ New York PHP User Group Community Talk Mailing List http://lists