Joel OConnor 26.Apr.11 09:05 AM a Web browser LEI LEI - 6.5 Windows
I just upgraded my Oracle Warehouse version from 9i to 11g. LEI stayed the same at 6.5. One difference that I noticed was if a text field is blank/empty in Notes, Oracle is entering a square (’) in the varchar2 column. This is only happening in 11g though. Queries that are executed against these text fields think that the column is not empty.
I ran the following query in both my 9i and 11g instance:
select * from NLS_DATABASE_PARAMETERS where parameter='NLS_CHARACTERSET';
In each instance the character set is UTF8. The Domino server that LEI runs on has a parameter in the notes.ini of:
This issue is driving me nuts. Does anyone have an insight into why oracle is entering a square (’) in a varchar2 column when the associted notes field is empty? Again the only thing that changed was the Oracle version. Any help is appreciated.
EDIT: I have discovered that the square character is actually CHR(0) which in ASCII is NUL.
Select dump(third_party_pd) as d from gdash;
Returns: Typ=1 Len=1: 0
Also, it's LEI that is doing it. If I manually insert a row into the table via SQL PLUS the varchar2 fields are NULL.