Hi

im having problem using utf8
db is oracle 10.2g
and retriving from db

using %TYPE from a field of type char(1) is returning a string which is being padded with spaces
e.g. 'T ' which naturally breaks code using If Something.field = 'T', even with
field in DB set to varchar2 it returns 'T '

anyone tried this and know how to fix it?

Which Direct Oracle Access version are you using?

Hi

using version 4.1.0.0