mssql_field_type

(PHP 4, PHP 5, PECL odbtp >= 1.1.1)

mssql_field_type — Liefert den Typ eines Feldes

Beschreibung

string mssql_field_type ( resource $Ergebniskennung [, int $Feld-Offset ] )

Gibt den Typ des Feldes Nr. Feld-Offset aus Ergebniskennung zurück.

Parameter-Liste

Ergebniskennung: Der Bezeichner des Ergebnisses, das ausgewertet wird. Dieses Ergebnis stammt von einem Aufruf von mssql_query().
Feld-Offset: Der Offset des Feldes, beginnend bei 0. Falls er nicht angegeben wurde, wird das aktuelle Feld verwendet.

Rückgabewerte

Gibt den Typ des angegebenen Feldes zurück oder FALSE, falls ein Fehler auftrat.

Siehe auch

mssql_field_length() - Liefert die Länge eines Feldes
mssql_field_name() - Liefert den Namen eines Feldes

mssql_free_result

mssql_field_seek

Last updated: Fri, 30 Oct 2009

add a note User Contributed Notes
mssql_field_type

huib at bestia dot com
27-May-2005 10:18


If you need a more detailed discription of your column type,



This query shows your true datatypes like:



binary => binary 

varbinary => varbinary 

varchar => varchar 

bit => bit

char => char

datetime => datetime

smalldatetime => smalldatetime 

decimal => decimal 

real => real

float => float 

tinyint => tinyint 

smallint => smallint 

smallmoney => smallmoney 

money => money

nchar => nchar 

ntext => ntext 

text => text

numeric => numeric

nvarchar => nvarchar 

 



SELECT     sysobjects.name AS tableName, syscolumns.name AS columnName, systypes.name AS columnType

FROM         sysobjects INNER JOIN

                      syscolumns ON sysobjects.id = syscolumns.id INNER JOIN

                      systypes ON syscolumns.type = systypes.type AND syscolumns.xusertype = systypes.xusertype

nicholas at silverorange dot com
24-Mar-2005 02:39


The matching returned values for each of the common datatypes are:



binary => blob

varbinary => blob

varchar => char

bit => bit

char => char

datetime => datetime

smalldatetime => datetime

decimal => real

real => real

float => real

tinyint => int

smallint => int

smallmoney => money

money => money

nchar => char

ntext => text

text => text

numeric => numeric

nvarchar => char

rmorales at protel dot net dot mx
18-Jun-2003 06:46


Here i have an usable code for all u:



   I wanted to know if a field is nullable or if it's defined as a primary key, here are those functions definitions:



*Aditional Notes:

    if any of the tables are replicated in another database exactly , this code will not work well.



//-----to know if a field is nullable-------

function mssql_field_nullable($ip,$user,$pass,$table,$field)//starting from 1st field

{

      $conn=mssql_connect($ip,$user,$pass)or die;

      mssql_select_db('master');

      $result=mssql_query("SELECT syscolumns.isnullable

FROM sysobjects INNER JOIN

    syscolumns ON sysobjects.id = syscolumns.id WHERE sysobjects.name ='$table' AND syscolumns.isnullable = 1");

      $x=mssql_num_rows($result);

      mssql_close($conn);

      return ($x==1?1:0);



}

//-------to know if a field is a primary key-------

function mssql_field_key($ip,$user,$pass,$table,$field)//starting from 1st field

{

      $conn=mssql_connect($ip,$user,$pass)or die;

      mssql_select_db('master');

      $result=mssql_query("SELECT sysindexkeys.colid FROM sysobjects INNER JOIN sysindexkeys ON sysobjects.id = sysindexkeys.id WHERE sysobjects.name ='$table' AND sysindexkeys.colid = $field");

      $x=mssql_num_rows($result);

      mssql_close($conn);

      return ($x==1?1:0);



}

by R.M.R.A

add a note

mssql_free_result

mssql_field_seek

Last updated: Fri, 30 Oct 2009