[freetds] FreeTDS creating all fields as not null

Constantin Vasilyev vasilyev at ncbi.nlm.nih.gov
Thu Sep 21 13:58:55 EDT 2006


That doesn't seem to be the case for me.

[106] MSSQL0.testdb.1> create table foo(id int null);
[107] MSSQL0.testdb.1> sp_help foo; -mvert | grep Nullable
Nullable:             yes
[108] MSSQL0.testdb.1> select @@version;
Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86)
        Apr 14 2006 01:12:25
        Copyright (c) 1988-2005 Microsoft Corporation
        Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)|

Would you please provide an example of what you're doing (you may catch
what's actually comes to the server using Profiler).

Constantin Vasilyev

On Thu, 21 Sep 2006, Eloy Lafuente wrote:

> Hi,
>
> I'm using FreeTDS to handle one MSSQL 2005 server with PHP
> running the "replacement" php_mssql extension with this
> freetds.conf file:
>
> [global]
>      host = 10.0.2.2
>      port = 1433
>      client charset = UTF-8
>      tds version = 7.0
>
> Everytime I create one table having NULL fields, they become
> NOT NULL in the target DB.
>
> Curiously, executing the same CREATE TABLE statement from
> the "tsql" command line interface, the table is created
> properly (with NULL fields being NULL).
>
> Any idea about how this could be solved?
>
> TIA and ciao, Eloy :-)
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>




More information about the FreeTDS mailing list