Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses
 
PerlMonks  

Re: Re: Re: Re: OT: Is MD5 ALWAYS 32 character long?

by sth (Priest)
on Dec 20, 2003 at 16:17 UTC ( #316050=note: print w/ replies, xml ) Need Help??


in reply to Re: Re: Re: OT: Is MD5 ALWAYS 32 character long?
in thread OT: Is MD5 ALWAYS 32 character long?

Judging from what my copy of Oracle does, the output of select 'yes' from dual where 'hello ' = 'hello';

..Are you sure that Oracle is not treating the strings as varchar2's, within that statement? Granted I ran into this problem with Oracle 8.0.5, but there was a column in a table that was defined as char(18) and I was using DBI to do lookups against that table. Some of the lookup values did not have trailing spaces and the matched failed. DBD::Oracle trims trailling spaces by default, which can be overriden. I eventually changed the column to be a varchar2 and the trailing spaces were not an issue anymore.


Comment on Re: Re: Re: Re: OT: Is MD5 ALWAYS 32 character long?
Re: Re: Re: Re: Re: OT: Is MD5 ALWAYS 32 character long?
by tilly (Archbishop) on Dec 30, 2003 at 19:44 UTC
    My strong guess is that Oracle actually is treating the strings as varchar2's. However if a varchar2 and a char get treated differently, I think that that is a bug.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://316050]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others scrutinizing the Monastery: (5)
As of 2014-08-31 01:11 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (294 votes), past polls