Posts tagged mysql

Dec09

Oracle vs. MySQL, handling of values exceeding column width

errorhandling forms mysql oracle | comments

Say you have a form that someone slapped together some ages ago, and that form has no maxlength attributes on its text input fields. Say also that you don’t have any JavaScript validation of said form wherein those field lengths would be checked upon submit. Say you likewise have no logic in your form processing script with knowledge of the appropriate length at which the storied form input should be curtailed.

Continue reading »

Oct06

MySQL -> Oracle, CONCAT

mysql oracle sql concatenationoperator | comments

CONCAT in MySQL takes any number of values.

CONCAT in Oracle takes only TWO values.

Continue reading »