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.

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.

I also found this tidbit in the archives:

http://groups.kasei.com/mail/arc/cdbi-talk/2004-07/msg00251.html

but that didn't work either.

Are one of these the solution? If so, I'll assume I'm doing something 
wrong and keep trying.

I'm using CDBI 0.94.

Thanks,
Jim

==========================================
Jim Brandt
Administrative Computing Services
University at Buffalo