Question

3
Replies
506
Views
Rajesh Manem Member since 2012 8 posts
Bank of America
Posted: 4 years ago
Last activity: 2 years 11 months ago
Closed

Obj-Browse with "Is Equal" on Oracle CHAR type Column is NOT working

Hello,

We have recently migrated our Application Database to Oracle 11g from DB2.

Now, we are facing an issue with Obj-Browse with "Is Equal" on CHAR type columns, as the values in CHAR type column are trailing with spaces to maintain same length

We have a Database Table with 2 columns Country and State, as shown below. Now we need to get States corresponding to selected country from DB and display in a DropDown.

Country State

CHAR(5) CHAR(10)

------------- --------------

US FLORIDA

US ATLANTA

US WASHINGTON

The same was working fine with DB2 CHAR type columns.

If we change the CHAR to VARCHAR, it works but need to do the same thing for all the CHAR type columns and not sure whether DB team is ready for that do it in PROD.

Please advice...

Regards,

Rajesh

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Data Integration Data Integration Java and Activities
Moderation Team has archived post
Share this page LinkedIn