Re: Weird Characters in table

[Ashish Kulkarni <ashish.kulkarni13@xxxxxxxxx>]

Hi
i ran this query and it shows result as below, how do i know what is wrong
with Hex data

the data is as below

8285939385A5A4857C8399A489A285A2888997838595A38599A24B839694404141

Ashish
On Wed, Nov 9, 2011 at 3:11 PM, paul therrien <
paultherrien@xxxxxxxxxxxxxxxxxx> wrote:

> I use:
>
> select hex(fieldname)
>
> This shows the hexadecimal value of the field and lets me see if there are
> non-display characters.
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Ashish Kulkarni
> Sent: Wednesday, November 09, 2011 1:56 PM
> To: Midrange Systems Technical Discussion
> Subject: Weird Characters in table
>
> Hi
> I am running into weird issue of having some weird characters in table
> which
> are not displayed on any SQL program, for example if i run query
>
> 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
>
> select * from mycontact; from 5250 screen or iseries navigator i dont see
> any characters after .com, so how do i find what it is, and how do i fix
> this data
>
> Regards
> --
> Ashish
> www.ayurwellness.com
> www.mysoftwareneeds.com
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
> unsubscribe,
> or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
> moment to review the archives at http://archive.midrange.com/midrange-l.
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.