Re: search on Oracle CHAR primary key column

[prev] [thread] [next] [Date index for 2004/08/25]

> I need to interface with an Oracle table that has CHARs as primary key
> columns (there are two), but I've been unable to get any
> selects/searches to match anything unless I use search_like. I finally
> figured out it was probably because the datatype is being set to
> VARCHAR by default.

My guess is its a padding issue.  Oracle right pads strings with spaces to
the length of the column.  That is, if your pk_id is defined as char(10),
and
you store "AU" in that field, Oracle will save: "AU        " in the column (
which is why your search_like is working).

To make search work you'd have to pad it yourself (I'm sure someone has
a much slicker way but ugly coded like:

my $id = substr("AU"." "x10,0,9);
my $row = __PACKAGE__->search({id=>$id});

Jay