[PHP-DEV] Char/Varchar(1) bug in Oracle support??? From: Klaasjan Tukker (jit <email protected>)
Date: 05/29/98

** also posted on php3 <email protected> **

L.S.

While developing I discovered the following using Oracle:

create table SBB_NawLeerling(
        KlantID varchar2(10) primary key not null,
        sex varchar2(1),
);

When I do a select on the database with php and Oracle , I can
retrieve the KlantID, but when I try to get the "sex" field,
I get an empty result. This happens to when the field is of
the type Char(1). When I change the type to varchar2(2), I
get the result "M " or "F "... also one space to much...

Is it a bug, or is it a feature?

Greetz,

Klaasjan Tukker