SQL Error in Custom Date Format
Posted: Wed Mar 07, 2018 11:02 am
This is a totally inconsequential thing but I figured it'd be better to post it than to not.
In the Custom Date Format field (Control Panel -> Board Preferences -> Global Settings), the character limit is 30 characters.
However, if you enter a double quote (") or an ampersand (&), it is counted as more than one character, which causes an SQL error if the total is over 30. Presumably this is because it is converted to " or & before the string is stored.
In the Custom Date Format field (Control Panel -> Board Preferences -> Global Settings), the character limit is 30 characters.
However, if you enter a double quote (") or an ampersand (&), it is counted as more than one character, which causes an SQL error if the total is over 30. Presumably this is because it is converted to " or & before the string is stored.