Newsgroups: php.internals Path: news.php.net Xref: news.php.net php.internals:42865 Return-Path: Mailing-List: contact internals-help@lists.php.net; run by ezmlm Delivered-To: mailing list internals@lists.php.net Received: (qmail 22878 invoked from network); 28 Jan 2009 14:52:58 -0000 Received: from unknown (HELO lists.php.net) (127.0.0.1) by localhost with SMTP; 28 Jan 2009 14:52:58 -0000 Authentication-Results: pb1.pair.com header.from=torokalpar@gmail.com; sender-id=pass; domainkeys=bad Authentication-Results: pb1.pair.com smtp.mail=torokalpar@gmail.com; spf=pass; sender-id=pass Received-SPF: pass (pb1.pair.com: domain gmail.com designates 66.249.90.177 as permitted sender) DomainKey-Status: bad X-DomainKeys: Ecelerity dk_validate implementing draft-delany-domainkeys-base-01 X-PHP-List-Original-Sender: torokalpar@gmail.com X-Host-Fingerprint: 66.249.90.177 ik-out-1112.google.com Received: from [66.249.90.177] ([66.249.90.177:36122] helo=ik-out-1112.google.com) by pb1.pair.com (ecelerity 2.1.1.9-wez r(12769M)) with ESMTP id B5/32-08436-94170894 for ; Wed, 28 Jan 2009 09:52:58 -0500 Received: by ik-out-1112.google.com with SMTP id c30so1876340ika.7 for ; Wed, 28 Jan 2009 06:52:55 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:cc:content-type; bh=ii4T6vFZSDBbE1LBN/XGKOJpy29w1NOqf+37UW00C5U=; b=o311872U49AT3hAX+4FIO5avSs1ALweq+f8gL8G4ivXQhVx4KKmEcpahabX1I0i3Hl IfwNk903JYifbyPkDk8xYjAy5eOGQ8hdWsfqsS6WCBW1YTk2MXT0eIPrnm4JA3ytg9X8 8Zdv4NrAw4Ytpd2uF9Ds0Z7qn1Z006hlPzG6k= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; b=G2DqCv7UxvRQAtwM4dOVFJbEhd/21hoIPVhMyMs67Ai+sIgw1ZanpT5I8qm0QgD5uw 64KNgQSpyKYfoEI7myJFaur3JPollqAslUjVJd+MlIZzRBK7orRW6Ewdow+VQGsjkSG9 6Ak/S4rWCcPMGU7CryB0WlgIH+JIUg/ZyuZ7s= MIME-Version: 1.0 Received: by 10.67.123.1 with SMTP id a1mr200522ugn.42.1233154374848; Wed, 28 Jan 2009 06:52:54 -0800 (PST) In-Reply-To: References: Date: Wed, 28 Jan 2009 16:52:54 +0200 Message-ID: <8d3051340901280652v38278272qbe2ee454f5c5dffc@mail.gmail.com> To: bipul@aphroecs.com Cc: internals@lists.php.net Content-Type: multipart/alternative; boundary=00148520fa3177513404618c2051 Subject: Re: [PHP-DEV] search string problem with special characters in php 4.4.7 From: torokalpar@gmail.com (=?UTF-8?B?QWxww6FyIFTDtnLDtmsg?=) --00148520fa3177513404618c2051 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable 2009/1/28 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 - =C3=A5re - 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 - =C3=A5re - we get around 26 recor= ds > 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? th= e > problem could be because of php versions or it has to be in my codes? > > Thanks in advance, > Bipul > I think your problem is Db related. Try cross testing the databases with the different PHP versions, to make sure where the problem is. > > > -- > PHP Internals - PHP Runtime Development Mailing List > To unsubscribe, visit: http://www.php.net/unsub.php > > --=20 Alpar Torok --00148520fa3177513404618c2051--