https://wiki.ispirer.com/ 2026-04-28T00:41:27+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/conversions?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL Database Conversions * to Oracle text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/data-types?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL Data Types Versions: MySQL 5.x, 4.x and 3.23 Data Type Parameters and Range Character Data Types CHAR(n) - Fixed-length character data 0 <= n <= 255, default is 1 NCHAR(n) - Fixed-length character data in UTF8 0 <= n <= 255, default is 1 VARCHAR(n) - Variable-length character data text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/date-time-functions?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL - Date and Time Functions This article describes date and time functions in MySQL. Overview Date and Time Function Description DATE() Extracts date part (day, month and year) DATE MySQL - DATE Syntax DATE(datetime_expression) Description text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/functions?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL Functions * SQL Functions Mapping to Other Databases * Numeric Functions * ABS * ACOS * ASIN * ATAN * ATAN2 * CEILING * CONV * COS * COT * CRC32 * DEGREES * DIV * EXP * FLOOR * LN * LOG10 * LOG2 * LOG * MOD * PI * POWER * RADIANS * RAND * ROUND * SIGN * SIN * SQRT * TAN * TRUNCATE * String Functions … text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/identifiers?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL - Identifiers This article describes identifiers in MySQL. Identifiers rules MySQL - Identifier First Character An alphanumeric character Subsequent Characters Alphanumeric characters, the underscore (_), dollar sign ($) Maximum Length text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/limits?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL Limits This article describes the database and SQL limits for MySQL 5.1 and earlier. Tables Row Size MySQL - Row Size Maximum Row Size 65535 bytes Notes Limit includes all overhead and applies to all storage engines LOB Data text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/migration-assessment?rev=1741078743&do=diff User Documentation Ispirer Assessment Tools Overview Pricing MySQL Migration Assessment * Collecting Information text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/string-functions?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing MySQL - String Functions This article describes string functions in MySQL. Overview String Function Description LOCATE() Position of substring in string LOCATE MySQL - LOCATE Syntax LOCATE(substring, string [, start_position]) Description LOCATE searches text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/table-def?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing Table Definition * Default Column Value text/html 2025-03-04T08:59:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/mysql/techniques?rev=1741078743&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing Techniques * Returning Single Value from Procedure * Outer apply and cross apply conversion from MS SQL Server to MySQL and PostgreSQL * Referring to a TEMPORARY table more than once in the same query in MySQL * Sequences conversion from MS SQL Server to MySQL * TRUNC (date) function conversion from Oracle to MySQL