On Aug 15, 2007, at 7:41 AM, Ivan Zolotukhin wrote:
What is the best practice to process such a broken strings before passing them to PostgreSQL? Iconv from utf-8 to utf-8 dropping bad characters?
This rings of GIGO... if your user enters garbage, how do you know what they wanted? You don't. You tell them they entered garbage, else the result will be garbage. Data validation... learn from microsoft's mistakes :-)
---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
