Differences

This shows you the differences between two versions of the page.

--- v5:reference:connection:properties [2021/03/12 03:52] – created mnewnham
+++ v5:reference:connection:properties [2021/03/13 01:11] (current) – mnewnham
@@ Line 1: / Line 1: @@
 ====== Public Properties Of The Connection======
-The Connection Object exposes numerous properties that can be used inside SQL statements to create portable statements. For example, to create a portable SQL statement that will return a column in uppercase no matter which database is in use, use the ''** $db->upper**'' property.
+The Connection Object exposes numerous properties that can be used inside SQL statements to create portable statements. For example, to create a portable SQL statement that will return a column in uppercase no matter which database is in use, use the ''** $db->upperCase**'' property.
 ===== String Handling =====
-^ Property  ^ Description  ^
+^ Property      ^ Description                                                                                                                       ^
-|  $substr         | Returns the substring operator. Also available as a method [[v5:connection:reference:substr|substr()]] |
+| $substr       | Returns the substring operator. Also available as a method [[v5:reference:connection:substr|substr()]]                            |
-|  $length         | Returns a legnth operator|
+| $length       | Returns a length operator                                                                                                         |
-|  $random         | Returns the random number function|
+| $random       | Returns the random number function                                                                                                |
-|  $upperCase      | The uppercase function|
+| $upperCase    | The uppercase function                                                                                                            |
+| $maxblobsize  | The maximum size of data that can be inserted into a blob field. Some drivers return -1 as the value, effectively limitless size  |
 ===== Date & Time =====
-^ Property  ^ Description =====
+^ Property  ^ Description ^
 | $sysDate  | Returns the current local date in Y-m-d format|
 | $sysTimeStamp | Returns the current local date/time in Y-m-d H:i:s format|
+| $sysUTimeStamp |Returns the current timestamp accurate to the microsecond or nearest fraction|
+===== Database Specific Properties =====
+Some drivers expose database-specific properties. See the driver documentation for more information.