Re: search on Oracle CHAR primary key column

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

On Wed, Aug 25, 2004 at 10:19:03AM -0400, Jim Brandt wrote:
> 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.
> 
> Is there any way I can tell CDBI to treat these as CHARs and bind the 
> parameters correctly?
> 
> I found a reference to the data_type method on the kwiki:
> 
> http://www.class-dbi.com/cgi-bin/wiki/index.cgi?WorkingWithBlobs
> 
> but was unable to get it to work.

That's probably the right approach though, so start debugging CDBI...

Tim.