[freetds] Empty string in insert query

ZIGLIO, Frediano, VF-IT Frediano.Ziglio at vodafone.com
Tue Sep 14 05:23:07 EDT 2004


> 
> Hello,
> 
> I'm on PHP 4.3.8 + FreeTDS 0.61 + MSSQL 2000
> 
> I'm trying to execute a simple query with empty value like this :
> $sql = "INSERT INTO MY_TABLE (COL1, COL2) VALUES ('TOTO', '')";
> mssql_query($sql) or die($sql)
> 
> Unfortunatly, when query is executing, it will insert the 
> value ' ' for COL2.
> 
> I saw there was a thread in the forum for a similar problem 
> but it concerns
> stored procedure and NULL value.
> 
> Once again when I used an old version of freeTDS, I didn't 
> have this problem
> 
> 
> CREATE TABLE [MY_TABLE] (
> 	[COL1] [varchar] (50) NULL ,
> 	[COL2] [varchar] (50) NULL
> )

Probably you are using protocol version 4.2. Check your configuration.

freddy77



More information about the FreeTDS mailing list