Assuming numeric is required, the following 11 results were found.
-
of 500 words should only be TEXT (~64Kb) rather than LONGTEXT (~4Gb). Data Type Column Type Range or Description Storage Numeric TinyInt Signed values from -128 to 127 1 byte Unsigned values from 0 to 255 Numeric SmallInt Signed values from -32768 to...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
If you ever want to check the parameters submitted with a report for alpha numeric characters (so it doesn't contain symbols, punctuations, etc) then you should do this at the database level, and then get the report to complete the check: The Plan User...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
XML Schema Referencehttps://joellipman.com/articles/web-development/xml/xml-schema-reference.html
of characters or list items allowed. Must be equal to or greater than zero maxExclusive Specifies the upper bounds for numeric values (the value must be less than this value) maxInclusive Specifies the upper bounds for numeric values (the value must be...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: en-GB
-
failure. All this blab actually means is that there is a chance one of your date values is BLANK, NULL or contains a non-numerical value in a number such as COMMA (,) and therefore the parsing (to extract year for example) will fail and stop the task...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
the formatting and get weird question mark characters instead such as: . How? Ensure you are using the numbers on your numeric keypad and NOT the numbers at the top of your keyboard for the following steps. Also check that you have "Num Lock"...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
A quick post on how I managed to build a regex to extract all non-numeric characters (all non-digits) from a string. Why? I only want the digits/numbers from a string: v_PaymentTerms = "Credit Note - 30 Days"; // we want the 30 from the above string...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
"utf-8" ); // converts html entities into characters (symbols) $str = preg_replace("/&.{0,}?;/",'', $str); // removes numeric entities? $str = preg_replace('//i', '', $str); // removes MS Office style html comments (and everything in between) $str =...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
Unix Date Format Specifiershttps://joellipman.com/articles/linux/unix-date-format-specifiers.html
(%H:%M:%S) Date and Time %c locale's date and time Sat Nov 04 12:02:33 EST 1989 Time zone %z -zzzz RFC-822 style numeric timezone -0500 %Z time zone (e.g., EDT) nothing if no time zone is determinable EST
- Type: Article
- Author: Joel Lipman
- Category: Linux
- Language: *
-
// password type field textVisiblePassword // um... textPhonetic // text that will sound like number // changes keyboard to numeric numberDecimal // allow a decimal number phone // enter a phone number datetime // enter a date and time date //...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
if a cell value has been formatted to a text type. Returns true if the cell value is a number AND the cell data type is numeric. Search( is a case-insensitive search with the first parameter being the text to search for (can be a range) and the second...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
quickly, we take each character from the given string and convert it to its RGB value. Replace letters A to F with their numeric equivalents. Made up of 2 characters to convert to an RGB subset, the 1st value is to be multiplied by 16 and then added to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *