[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