CHAR(1) in OpenEdge SQL script

[Thomas Mercer-Hursh]

I seem to have found a BIG problem with the SQL script for creating an OpenEdge repository.  This is that there are a number of columns defined as CHAR(1).  This is mapped into the datatype fixchar which appears to be a datatype that works fine with SQL, but which cannot be accessed from ABL.

The fix would seem to be to convert these to a datatype like VARCHAR which maps to an ordinary ABL datatype, but will this cause EA a problem?

[Eve]

Hi Thomas,

I'd recommend emailing sparx systems support directly with any queries about the underlying datastructure.

Unfortunately, I don't know enough about this area myself to say what problems you may run into.