Page 1 of 1

in 4.50.33 'SSL Mode' does not exist and empty TEXT...

Posted: Tue 04 Aug 2009 12:06
by baba
FIRST :
in 4.50.33, connection string SSL Mode is no more supported (why ?)

SECONDLY :
Selecting a TEXT which actually is a ''::text becomes a DBNull

Example:

Select company from doms where uid=237

in that row, company is not null and equals ''.

In my dataset 'company' does not allow DBNull (for safety).
In the table the default value for 'company' is ''::text.
I double check in the database : company equals ''. This is correct.
Everything used to work but since 4.50.33, company is 'transformed' into DBNull.

Any idea ?

Posted: Thu 06 Aug 2009 12:39
by AndreyR
Please try to reproduce the problem using recent dotConnect for PostgreSQL 4.55.39.
We have made some fixes associated with DBNull and empty strings.