https://wiki.ispirer.com/ 2026-04-14T07:35:41+00:00 https://wiki.ispirer.com/ https://wiki.ispirer.com/lib/tpl/dokuwiki/images/favicon.ico text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/functions/string-functions/ascii?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL - ASCII Function MySQL - ASCII Syntax ASCII() Description ASCII function returns decimal representation of the first character according to ASCII code set Equivalents in Other Databases Database Equivalent Oracle ASCII SQL Server text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/functions/string-functions/bin?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL - BIN Function MySQL - BIN Syntax BIN() Description BIN function returns string representation of the number converted to the binary value text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/functions/string-functions/bit-count?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL - BIT_COUNT Function MySQL - BIT_COUNT Syntax BIT_COUNT() Description BIT_COUNT function returns number of bits in the string text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/functions/string-functions/bit-length?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL - BIT_LENGTH Function MySQL - BIT_LENGTH Syntax BIT_LENGTH() Description BIT_LENGTH function returns length of a string in bits text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/functions/string-functions/char-length?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL - CHAR_LENGTH Function MySQL - CHAR_LENGTH Syntax CHAR_LENGTH() Description CHAR_LENGTH function returns length of a string Equivalents in Other Databases Database Equivalent Oracle LENGTH SQL Server LEN IBM DB2 CHARACTER_LENGTH text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/functions/string-functions/char?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL - CHAR Function MySQL - CHAR Syntax CHAR() Description CHAR function returns character with the binary equivalent of a number specified Equivalents in Other Databases Database Equivalent Oracle CHR SQL Server CHAR IBM DB2 CHR text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/functions/string-functions/concat-ws?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL - CONCAT_WS Function MySQL - CONCAT_WS Syntax CONCAT_WS() Description CONCAT_WS function returns concatenated string with separator specified text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/functions/string-functions/concat?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL - CONCAT Function MySQL - CONCAT Syntax CONCAT() Description CONCAT function returns concatenated string Equivalents in Other Databases Database Equivalent Oracle CONCAT IBM DB2 CONCAT text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/functions/string-functions/elt?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL - ELT Function MySQL - ELT Syntax ELT() Description ELT function returns string at index number text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/functions/string-functions/export-set?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL - EXPORT_SET Function MySQL - EXPORT_SET Syntax EXPORT_SET() Description EXPORT_SET function returns string such that for every bit set in the value, you get one string specified and for every unset bit, you get another string specified text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/functions/string-functions/field?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL - FIELD Function MySQL - FIELD Syntax FIELD() Description FIELD function returns index of the first argument in the subsequent arguments text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/functions/string-functions/find-in-set?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL - FIND_IN_SET Function MySQL - FIND_IN_SET Syntax FIND_IN_SET() Description FIND_IN_SET function returns index position of the first argument within the set text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/functions/string-functions/insert?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL - INSERT Function MySQL - INSERT Syntax INSERT() Description INSERT function returns string with the replaced symbols by replacement string in the specified position Equivalents in Other Databases Database Equivalent SQL Server text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/functions/string-functions/instr?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL - INSTR Function MySQL - INSTR Syntax INSTR() Description INSTR function returns position of a string in the string Equivalents in Other Databases Database Equivalent Oracle INSTR SQL Server CHARINDEX IBM DB2 LOCATE text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/functions/string-functions/left?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL - LEFT Function MySQL - LEFT Syntax LEFT() Description LEFT function returns specified number of characters from the left part of a specified string Equivalents in Other Databases Database Equivalent SQL Server LEFT IBM DB2 LEFT text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/functions/string-functions/length?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL - LENGTH Function MySQL - LENGTH Syntax LENGTH() Description LENGTH function returns length of a string Equivalents in Other Databases Database Equivalent Oracle LENGTH SQL Server LEN IBM DB2 CHARACTER_LENGTH text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/functions/string-functions/locate?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL - LOCATE Function MySQL - LOCATE Syntax LOCATE() Description LOCATE function returns position of a string in the string Equivalents in Other Databases Database Equivalent Oracle INSTR SQL Server CHARINDEX IBM DB2 LOCATE text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/functions/string-functions/lower?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL - LOWER Function MySQL - LOWER Syntax LOWER() Description LOWER function returns string with each letter in lowercase Equivalents in Other Databases Database Equivalent Oracle LOWER SQL Server LOWER IBM DB2 LCASE text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/functions/string-functions/lpad?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL - LPAD Function MySQL - LPAD Syntax LPAD() Description LPAD function returns left-padded string Equivalents in Other Databases Database Equivalent Oracle LPAD text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/functions/string-functions/ltrim?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL - LTRIM Function MySQL - LTRIM Syntax LTRIM() Description LTRIM function returns string with removed spaces from the left end Equivalents in Other Databases Database Equivalent Oracle LTRIM SQL Server LTRIM IBM DB2 LTRIM text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/functions/string-functions/make-set?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL - MAKE_SET Function MySQL - MAKE_SET Syntax MAKE_SET() Description MAKE_SET function returns set of comma-separated strings that have the corresponding bit in bits set text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/functions/string-functions/oct?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL - OCT Function MySQL - OCT Syntax OCT() Description OCT function returns string representation of the number converted to the octal value text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/functions/string-functions/octet-length?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL - OCTET_LENGTH Function MySQL - OCTET_LENGTH Syntax OCTET_LENGTH() Description OCTET_LENGTH function returns length of a string Equivalents in Other Databases Database Equivalent Oracle LENGTH SQL Server LEN IBM DB2 CHARACTER_LENGTH text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/functions/string-functions/ord?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL - ORD Function MySQL - ORD Syntax ORD() Description ORD function returns code for the leftmost multi-byte character text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/functions/string-functions/quote?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL - QUOTE Function MySQL - QUOTE Syntax QUOTE() Description QUOTE function returns validated quoted string Equivalents in Other Databases Database Equivalent SQL Server QUOTENAME text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/functions/string-functions/regexp?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL - REGEXP Function MySQL - REGEXP Syntax REGEXP() Description REGEXP function returns true if the specified using regular expression pattern matches the string text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/functions/string-functions/repeat?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL - REPEAT Function MySQL - REPEAT Syntax REPEAT() Description REPEAT function returns string replicated the number of times specified Equivalents in Other Databases Database Equivalent SQL Server REPLICATE IBM DB2 REPEAT text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/functions/string-functions/replace?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL - REPLACE Function MySQL - REPLACE Syntax REPLACE() Description REPLACE function returns string with the replaced occurrences of the specified string Equivalents in Other Databases Database Equivalent Oracle REPLACE SQL Server REPLACE text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/functions/string-functions/reverse?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL - REVERSE Function MySQL - REVERSE Syntax REVERSE() Description REVERSE function returns string in reversed order Equivalents in Other Databases Database Equivalent SQL Server REVERSE text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/functions/string-functions/right?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL - RIGHT Function MySQL - RIGHT Syntax RIGHT() Description RIGHT function returns specified number of characters from the right part of a specified string Equivalents in Other Databases Database Equivalent SQL Server RIGHT IBM DB2 text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/functions/string-functions/rpad?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL - RPAD Function MySQL - RPAD Syntax RPAD() Description RPAD function returns right-padded string Equivalents in Other Databases Database Equivalent Oracle RPAD text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/functions/string-functions/rtrim?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL - RTRIM Function MySQL - RTRIM Syntax RTRIM() Description RTRIM function returns string with removed spaces from the right end Equivalents in Other Databases Database Equivalent Oracle RTRIM SQL Server RTRIM IBM DB2 RTRIM text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/functions/string-functions/soundex?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL - SOUNDEX Function MySQL - SOUNDEX Syntax SOUNDEX() Description SOUNDEX function returns phonetic representation of a string Equivalents in Other Databases Database Equivalent Oracle SOUNDEX SQL Server SOUNDEX IBM DB2 SOUNDEX text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/functions/string-functions/space?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL - SPACE Function MySQL - SPACE Syntax SPACE() Description SPACE function returns string replicated the number of times specified Equivalents in Other Databases Database Equivalent SQL Server REPLICATE IBM DB2 REPEAT text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/functions/string-functions/strcmp?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL - STRCMP Function MySQL - STRCMP Syntax STRCMP() Description STRCMP function returns status for the comparison of two strings text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/functions/string-functions/trim?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL - TRIM Function MySQL - TRIM Syntax TRIM() Description TRIM function returns string with removed spaces from the left and/or from the right end Equivalents in Other Databases Database Equivalent Oracle TRIM IBM DB2 STRIP text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/functions/string-functions/upper?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL - UPPER Function MySQL - UPPER Syntax UPPER() Description UPPER function returns string with each letter in uppercase Equivalents in Other Databases Database Equivalent Oracle UPPER SQL Server UPPER IBM DB2 UCASE text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/functions/string-functions/weight-string?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL - WEIGHT_STRING Function MySQL - WEIGHT_STRING Syntax WEIGHT_STRING() Description WEIGHT_STRING function returns binary string that represents the sorting and comparison value of the string