Re: Weird Characters in table

[Brian Johnson <brian.johnson.mn@xxxxxxxxx>]

On Wed, Nov 9, 2011 at 1:56 PM, Ashish Kulkarni <ashish.kulkarni13@xxxxxxxxx
> wrote:

> select * from mycontact where email  = 'myemail@xxxxxxxx'; this query does
> not return any rows, but if i modify the query like below
>
> select * from mycontact where email  *like 'myemail@xxxxxxxx%'*; it
> returns
> data, so i believe is there is some weird data after *.com *, but if i run

Perhaps you have null-delimited string in email column. That is, a x'00'
character following the displayable characters.

A diagnostic query may help :

select email, hex(email) as email_in_hex
from mycontact where email  *like 'myemail@xxxxxxxx%'*;