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

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
baba
Posts: 22
Joined: Thu 14 Apr 2005 16:40

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

Post by 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 ?

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by 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.

Post Reply