Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How are you handling ASCII 0 values

user8999602Sep 3 2012 — edited Sep 3 2012
Hi,

I have noticed a strange thing with ASCII 0 values. in the process of database replication MSSQL to Oracle some columns in the source DB (MSSQL) have some of the values as ascii 0.
when i load this data with sqlldr in oracle and query the table this columns are not considered as null.

ex:
table_name : PriceItems
Column_name : Description

if i query the table with select count() from PriceItems where Description is null* the result is 0
if i query the table with select count() from PriceItems where Description = chr(0)* the result is 301 (actual rows)

how can we handle this kind of situations?
is this a bug of Oracle?


My Oracle Version:

Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
PL/SQL Release 11.1.0.7.0 - Production
"CORE 11.1.0.7.0 Production"
TNS for Linux: Version 11.1.0.7.0 - Production
NLSRTL Version 11.1.0.7.0 - Production

Edited by: user8999602 on Sep 3, 2012 9:22 AM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 1 2012
Added on Sep 3 2012
4 comments
1,330 views