hi,

i have small problems with a select statement.
select * from PARTNER where NR containing 'o' or NAME containing 'o'..
NR is a Integer Column
o is a runtime user value for search PARTNERS
the above statemant works fine
but now if the user uses a spezial german char like ö
select * from PARTNER where NR containing 'ö' or NAME containing 'ö'..
the statement fails with the message
cannot transliterate char between charsets

oh connection is correct with the right charset

if using containing only on varchar columns everything works fine

thanks for your help
franz bartlechner