varchar2 behaviour

Hello erverybody,

 I want to insert or update an emtpy string into a column defined  as varchar2(n) ( Oracle 7.1.6 or 7.2.3 ).  If there is no NOT NULL constraint then it works fine (insert/update)  but if I execute a query the db returns a null value for this column.

 In our application we have to distinguish between null and ''  therefore I should have a solution to get back an empty string.

 We use the C-interface from Oracle ( Pro*C/C++ 2.1 ).

 Regards

  Werner
  wernerm_at_hpbbn.bbn.hp.com Received on Thu Nov 14 1996 - 00:00:00 CET