Newsgroups: php.internals Path: news.php.net Xref: news.php.net php.internals:42863 Return-Path: Mailing-List: contact internals-help@lists.php.net; run by ezmlm Delivered-To: mailing list internals@lists.php.net Received: (qmail 19272 invoked from network); 28 Jan 2009 14:31:32 -0000 Received: from unknown (HELO lists.php.net) (127.0.0.1) by localhost with SMTP; 28 Jan 2009 14:31:32 -0000 Authentication-Results: pb1.pair.com smtp.mail=bipul@aphroecs.com; spf=permerror; sender-id=unknown Authentication-Results: pb1.pair.com header.from=bipul@aphroecs.com; sender-id=unknown Received-SPF: error (pb1.pair.com: domain aphroecs.com from 69.56.144.10 cause and error) X-PHP-List-Original-Sender: bipul@aphroecs.com X-Host-Fingerprint: 69.56.144.10 gateway13.websitewelcome.com Linux 2.6 Received: from [69.56.144.10] ([69.56.144.10:54725] helo=gateway13.websitewelcome.com) by pb1.pair.com (ecelerity 2.1.1.9-wez r(12769M)) with ESMTP id 7E/81-08436-34C60894 for ; Wed, 28 Jan 2009 09:31:31 -0500 Received: (qmail 19079 invoked from network); 28 Jan 2009 14:47:01 -0000 Received: from gator638.hostgator.com (174.132.114.98) by gateway13.websitewelcome.com with SMTP; 28 Jan 2009 14:47:01 -0000 Received: from [122.163.187.38] (port=1856 helo=Bipul) by gator638.hostgator.com with esmtpa (Exim 4.69) (envelope-from ) id 1LSBRs-00039U-UM for internals@lists.php.net; Wed, 28 Jan 2009 08:31:25 -0600 Reply-To: To: Date: Wed, 28 Jan 2009 20:00:49 +0530 Organization: Aphro ECS Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-Mailer: Microsoft Office Outlook 11 thread-index: AcmBUuB3cP+OGzUWSmWmZbZddFElUAAAG5rwAABrJTA= X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 Disposition-Notification-To: "Bipul Agarwal" X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - gator638.hostgator.com X-AntiAbuse: Original Domain - lists.php.net X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - aphroecs.com Subject: search string problem with special characters in php 4.4.7 From: bipul@aphroecs.com ("Bipul Agarwal") Hi all, I have a search string which works just fine with php 4.4.9 and my local host but some how its not working with php version 4.4.7. Search is for a Swedish name with special characters like - =E5re - I am = able to display these characters properly on the browser. the only problem is with searching keywords with special characters like above from the database. In php version 4.4.9 if we search for - =E5re - we get around 26 records = which is correct. but when we search the same in php version 4.4.7 (with same coding and same database) it retracts over 11,000 records - which is not correct. Database version for both servers is - MySQL client version: 5.0.51a I have a deadline tomorrow and wonder if you could please help me out? = the problem could be because of php versions or it has to be in my codes? Thanks in advance, Bipul