Lookup not working as expected

cosec · Post by **cosec** » Tue May 31, 2011 11:43 pm

Please advice if there is any special handling that needs to be done for character fields using a lookup after migration for v8.1

chulett · Post by **chulett** » Wed Jun 01, 2011 6:15 am

Special? No. Since this is a direct DB lookup, I'd say double-check your SQL and column metadata, ensure they match. Are you using custom SQL?

cosec · Post by **cosec** » Wed Jun 01, 2011 8:13 pm

I have checked and the column meta deta is exactly the same. Yes, I am using a custom SQL.

chulett · Post by **chulett** » Wed Jun 01, 2011 8:35 pm

You might want to check with support. Sometimes they plug holes and fix things that people didn't know were broken and relied upon. And sometimes they break things.

cosec · Post by **cosec** » Wed Jun 08, 2011 5:57 am

Thanks. We are currently checking with IBM on this issue.

ray.wurlod · Post by **ray.wurlod** » Wed Jun 08, 2011 4:30 pm

Always use trimmed VarChar on both inputs. Char is always untrimmed, so you need to have them identically padded.