Finding Acute-e

Hi,

Does anyone know how to query a varchar field to bring back any records
containing an acute-e - that's the "é"

The table is set to Colldation: latin1_swedish_ci

I have tried a number of things but nothing seem to work - it seem to return
records that contain any type of e.

Thanks,

SteveK
stevek [ Di, 28 August 2007 04:33 ] [ ID #1807070 ]

Re: Finding Acute-e

On 28 Aug, 03:33, "SteveK" <steve... [at] gmail.com> wrote:
> Hi,
>
> Does anyone know how to query a varchar field to bring back any records
> containing an acute-e - that's the "=E9"
>
> The table is set to Colldation: latin1_swedish_ci
>
> I have tried a number of things but nothing seem to work - it seem to ret=
urn
> records that contain any type of e.
>
> Thanks,
>
> SteveK

Try using the BINARY keyword.
Captain Paralytic [ Di, 28 August 2007 11:46 ] [ ID #1807934 ]
PHP » alt.php.sql » Finding Acute-e

Vorheriges Thema: PHP & Open Source Camps India (UnConference)
Nächstes Thema: Strange class OOP behavior