Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:42866
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Received-SPF: error (pb1.pair.com: domain noodles.gr from 209.85.128.188 cause and error)
MIME-Version: 1.0
In-Reply-To: <8d3051340901280652v38278272qbe2ee454f5c5dffc@mail.gmail.com>
References: <!&!AAAAAAAAAAAYAAAAAAAAALAQQy2VDkRFhHuWymAYfeLCgAAAEAAAAKL6Bh1UwE9EkS/Oc9B6LlQBAAAAAA==@aphroecs.com>
	 <8d3051340901280652v38278272qbe2ee454f5c5dffc@mail.gmail.com>
Date: Wed, 28 Jan 2009 17:11:56 +0200
Message-ID: <641f88250901280711s3d26befdl32e449772165c4f7@mail.gmail.com>
To: =?UTF-8?B?QWxww6FyIFTDtnLDtms=?= <torokalpar@gmail.com>
Cc: bipul@aphroecs.com, internals@lists.php.net
Content-Type: multipart/alternative; boundary=0016e6d376467ee98704618c64fb
Subject: Re: [PHP-DEV] search string problem with special characters in php 
	4.4.7
From: george@noodles.gr (George Antoniadis)

--0016e6d376467ee98704618c64fb
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

On Wed, Jan 28, 2009 at 4:52 PM, Alp=C3=A1r T=C3=B6r=C3=B6k <torokalpar@gma=
il.com> wrote:

> 2009/1/28 Bipul Agarwal <bipul@aphroecs.com>
>
> > Hi all,
> >
> > I have a search string which works just fine with php 4.4.9 and my loca=
l
> > 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 i=
s
> > 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 rec=
ords
> > 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 no=
t
> > 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
> >
> 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
> >
> >
>
>
> --
> Alpar Torok
>

Most likely there is something different on your mysql server configuration=
s
and most probably that something is charset and/or collation related...
Check what "set names" can do for you.

G.

--0016e6d376467ee98704618c64fb--