Skip to Content.
Sympa Menu

freetds - RE : [freetds] Empty string in insert query

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Cédric Dumetz <cedric.dumetz AT eolas.fr>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: RE : [freetds] Empty string in insert query
  • Date: Tue, 14 Sep 2004 15:02:41 +0200

I'm using protocol version 7.0 (I tried with 8.0 too)

Here my freetds.conf :

[MyEolas]
host = 213.XXX.XXX.XXX
port = 1433
tds version = 7.0
text size = 500000
client charset = ISO 8859-1



-----Message d'origine-----
De : ZIGLIO, Frediano, VF-IT [mailto:Frediano.Ziglio AT vodafone.com]
Envoyé : mardi 14 septembre 2004 11:23
À : FreeTDS Development Group
Objet : RE: [freetds] Empty string in insert query

>
> 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
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds



  • RE : [freetds] Empty string in insert query, Cédric Dumetz, 09/14/2004

Archive powered by MHonArc 2.6.24.

Top of Page