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

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

Postby baba » Tue 04 Aug 2009 12:06

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 ?
baba
 
Posts: 22
Joined: Thu 14 Apr 2005 16:40

Postby AndreyR » Thu 06 Aug 2009 12:39

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.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16


Return to dotConnect for PostgreSQL