Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot
 
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 wandering the Monastery: (18)
As of 2015-07-01 18:04 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (16 votes), past polls