mssql_field_length

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

mssql_field_length — Get the length of a field

Warning

This function was REMOVED in PHP 7.0.0.

Alternatives to this function include:

说明

mssql_field_length ( resource $result [, int $offset = -1 ] ) : int

Returns the length of field no. offset in result.

参数

result: The result resource that is being evaluated. This result comes from a call to mssql_query().
offset: The field offset, starts at 0. If omitted, the current field is used.

返回值

The length of the specified field index on success 或者在失败时返回 FALSE.

范例

Example #1 mssql_field_length() example


<?php
// Connect to MSSQL and select the database
mssql_connect('MANGO\SQLEXPRESS', 'sa', 'phpfi');
mssql_select_db('php');

// Send a select query to MSSQL
$query = mssql_query('SELECT [name], [age] FROM [php].[dbo].[persons]');

// Print the field length
echo 'The field \'age\' has a data length of ' . mssql_field_length($query, 1);

// Free the query result
mssql_free_result($query);
?>

以上例程的输出类似于：

The field 'age' has a data length of 4

注释

Note: Note to Windows Users

Due to a limitation in the underlying API used by PHP (MS DBLib C API), the length of VARCHAR fields is limited to 255. If you need to store more data, use a TEXT field instead.

参见

mssql_field_name() - Get the name of a field
mssql_field_type() - Gets the type of a field

add a note

User Contributed Notes 2 notes

down

zz(lost dot childz at gmail dot com) ¶

11 years ago


there are same problem with VARBINARY, if you are forced to use existing database with such fields you can do it like this:

SELECT CAST(master.dbo.fn_varbintohexstr(VARBINARYFIELD) AS TEXT) FROM table;

down

Anonymous ¶

14 years ago


You can also work around this limitation with the following:

   -- for example, with MyVarCharField VARCHAR(1000)
   SELECT CAST(MyVarCharField AS TEXT) FROM MyTable

add a note

官方地址：https://www.php.net/manual/en/function.mssql-field-length.php

有任何技术问题请点击这里网站运营推广招聘

IT PHP 编程语言 Linux 开发编程科技 Elasticsearch HTML/CSS/XML 网络 JAVA NoSQL 数据库面试 C/C++ Golang Git 算法操作系统正则表达式 Redis 互联网 MySql JavaScript 运维软件国际架构设计 Mac OS TCP/IP Excel Vim Windows Socket Oracle VR MongoDB Python 运营 MemCache 商业硬件电子娱乐设计 nginx 摄影游戏 WordPress HTTP 团建数码电器

php7 安装fileinfo扩展 preg_split — 通过一个正则表达式分隔字符串 php位值,解决 PHP 中 usort 在值相同时改变原始位置的问题 [PHP] inet_pton/inet_ntop IP地址转换函数 array_multisort() 多字段排序 PHPMailer设置utf8 PHPMailer字符集CharSet ADORecordSet对象 adodb手册 PHP 8.1 [鸟哥]PHP_INT_MIN 和 -9223372036854775808 opcache预加载 Composer的Packagist资源 mysql面试题 [鸟哥]PHP FFI详解 - 一种全新的PHP扩展方式 PHP7添加redis扩展 adodb连接mysql多个数据库的问题 PHP获取指定函数定义在哪个文件中及行号 PHP mkdir()写出来的权限与mode值不符合 PHP-FPM进程数的设定利用PHP SOAP实现WEB SERVICE

略微加速

PHP官方手册 - 互联网笔记

mssql_field_length

说明

参数

返回值

范例

注释

参见

User Contributed Notes 2 notes