[Geoserver-users] WFS Transaction with empty string values lead to NULL in database

GeoServer GeoServer User
1

Hello,

I encounter some problems when using WFS-T service from geoserver with string attributes whose values where empty.

I use OpenLayers with MySQL backend and the WFS Transaction for empty string looks like

WFS:PropertyWFS:NameMyEmptyVariable</WFS:Name>WFS:Value</WFS:Value></WFS:Property>

Geoserver interprets and stores it as a NULL value. This can lead to error for non Nillable columns.

For NULL value, OpenLayers actually sends

WFS:PropertyWFS:NameMyNullVariable</WFS:Name></WFS:Property>

Which is slightly different.

Can this be checked ?

Cheers

Vincent