>>>>> "Guru" == Guru Prasad <[EMAIL PROTECTED]> writes:
Guru> the field 'id' is of type CHAR(5). I didn't get any records (
Guru> when i am sure that the data is available for '1001' ). If i
Guru> changed the data type to VARCHAR(5), it is working fine. Why is
Guru> it so ?
This is indeed becoming an FAQ. Please see:
http://www.mail-archive.com/dbi-users%40perl.org/msg00185.html
As well as many previous comments in that thread.
Guru> P.S: Don't ask me to use "select name from junk where id like
Guru> '1005%'", as i know this works but it is not an elegant way of
Guru> doing it.
Well, using CHAR unnecessarily is hardly elegant either...
t.
