SQL Error in Custom Date Format

Post here if you have a problem with your account.
Forum rules
User avatar
Something_Smart
Something_Smart
He
Somewhat_Balanced
User avatar
User avatar
Something_Smart
He
Somewhat_Balanced
Somewhat_Balanced
Posts: 22616
Joined: November 17, 2015
Pronoun: He
Location: Rochester, New York

SQL Error in Custom Date Format

Post Post #0 (ISO) » Wed Mar 07, 2018 11:02 am

Post by Something_Smart »

This is a totally inconsequential thing but I figured it'd be better to post it than to not. :P

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.
Post Reply