WebSphere Message Broker, Version 8.0.0.7 Operating Systems: AIX, HP-Itanium, Linux, Solaris, Windows, z/OS

See information about the latest product version

PHP data types

PHP data types are supported by WebSphere® Message Broker.

The following table shows the mappings between the ESQL and PHP data types:

ESQL type PHP type
INTEGER, INT
  • int - for integers in the range -2147483648 - 2147483647
  • float - for integers outside the range -2147483648 - 2147483647
FLOAT float
DECIMAL Java™ BigDecimal
CHARACTER, CHAR string
BLOB MbsBlob
DATE Java com.ibm.broker.plugin.MbDate
TIME, GMTIME Java com.ibm.broker.plugin.MbTime
TIMESTAMP, GMTIMESTAMP Java com.ibm.broker.plugin.MbTimestamp
INTERVAL Not supported
BOOLEAN Boolean
REFERENCE MbsElement

Some of the PHP types are mapped onto Java data types; for example, BigDecimal and MbTimestamp. You can manipulate these values by using the Java bridge. For more information, see Calling Java from PHP.

No 64-bit integer type exists in PHP, therefore large values are represented as a float. You can use the Java bridge to manipulate Java types. The INTERVAL ESQL type is not represented in the Java API for the broker.

PHP processes the values stored in a string data type as single-byte strings. However, PHP has a multibyte string extension that enables the manipulation of multibyte strings in a PHP string variable. This PHP extension is included with the PHPCompute node.

For more information about PHP extensions, see the PHP: Hypertext Preprocessor website.

The following multibyte functions are provided with the PHPCompute node:

Function Description
mb_convert_encoding Converts the character encoding of a string.
mb_decode_mimeheader Decodes the encoded string in a MIME header.
mb_encode_mimeheader Encodes a string with MIME header encoding.
mb_ereg Runs the regular expression match with multibyte support.
mb_ereg_replace Replaces the regular expression with multibyte support.
mb_internal_encoding Sets or gets the internal character encoding.
mb_regex_encoding Returns the current encoding for a multibyte regex as a string.
mb_regex_set_options Sets the default options (specified by the options parameter) for multibyte regex functions.
mb_split Splits a multibyte string and returns the result as an array.
mb_stripos Finds the position of the first occurrence of a string within another. This function is not case sensitive.
mb_stristr Finds the first occurrence of a string within another. This function is not case sensitive.
mb_strlen Gets the length of a string.
mb_strpos Finds the position of the first occurrence of a string in a string.
mb_strrchr Finds the last occurrence of a character in a string within another string.
mb_strrichr Finds the last occurrence of a character in a string within another string. This function is not case sensitive.
mb_strripos Finds the position of the last occurrence of a string within another string. This function is not case sensitive.
mb_strrpos Finds the position of the last occurrence of a string within a string.
mb_strstr Finds the first occurrence of a string within another.
mb_strtolower Makes a string lowercase.
mb_strtoupper Makes a string uppercase.
mb_substitute_character Sets or gets a substitution character.
mb_substr Gets part of a string.
mb_substr_count Counts the number of substring occurrences.
Notices | Trademarks | Downloads | Library | Support | Feedback

Copyright IBM Corporation 1999, 2016Copyright IBM Corporation 1999, 2016.

        
        Last updated:
        
        Last updated: 2016-05-23 14:46:34


Reference topicReference topic | Version 8.0.0.7 | ac69009_