SQL Error in Custom Date Format

Post a reply

Smilies
:D :) :] :lol: :giggle: :P :roll: :wink: :cool: :mrgreen: :neutral: :oops: :o :eek: :( :? :mad: :cry: :evil: :good: :twisted: :igmeou: :shifty: :cop: :doc: :dead: :facepalm: :yawn: :nerd: :?: :!: :idea: :up: :right: :down: :left:
BBCode is OFF
Smilies are ON
Topic review
   

Expand view Topic review: SQL Error in Custom Date Format

SQL Error in Custom Date Format

Post Post #0 by Something_Smart » Wed Mar 07, 2018 5:02 pm

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.

Top