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

Re: Finding Acute-e

On 28 Aug, 03:33, "SteveK" 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.