knycrew Posted September 28, 2021 Share Posted September 28, 2021 I am working with Oracle 9iOracle data type varchar2 is searched as blankI'm hoping someone can give me an answer to my problemship_invoice_no -> charcustomer_name,local_code_name,work_ground_tel -> varchar2 DATA IS NOT NULL AND NOT BLANK Link to comment Share on other sites More sharing options...
gustavofarias Posted September 28, 2021 Share Posted September 28, 2021 Run the same query in SQL developer and post here what is shown. Link to comment Share on other sites More sharing options...
jgust Posted September 28, 2021 Share Posted September 28, 2021 This is a presentation choice that Jasper has made. Oracle does not have a BLANK. What you are seeing are NULLS. You can choose to display NULL or BLANK when you display the value on your report using the text field. There is a "Blank When NULL" checkbox in properties. Link to comment Share on other sites More sharing options...
knycrew Posted September 28, 2021 Author Share Posted September 28, 2021 this is same query in sql developer Link to comment Share on other sites More sharing options...
knycrew Posted September 28, 2021 Author Share Posted September 28, 2021 Link to comment Share on other sites More sharing options...
gustavofarias Posted September 29, 2021 Share Posted September 29, 2021 I guess it's something to do with those non ASCII charachters.Have you tried using the more modern Jaspersoft Studio instead of iReport? Link to comment Share on other sites More sharing options...
knycrew Posted September 29, 2021 Author Share Posted September 29, 2021 no, I USE iReport-5.6.0char data type is also displayed in Korean.only varchar2 columns have blank Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now