Neculai Macarie wrote: >> To my observations constants in a column declaration limit the >> column width to just fit the initial constant. >> Your choice of values 'gallary' and 'gallery-categ' just masked that >> out ;-) > Yes, you are right. Based on your observation I was able to trick him > with this query: > select Trim( 'gallery ' ) > as table_name, d_image_small, d_image_big > from gallery > UNION > select 'gallery_categ' as table_name, d_image, NULL > from gallery_categ > order by table_name; Well, it works for you, but preserving the original length don't feel logical. I fear this might change without notice.
Come to think of "select 'gallery ' as table_name, .." Yes, MySQL silently trims the trailing spaces for you!! HansH -- MySQL 4.1.0-alpha-max-nt on Windows XP using MySLQcc 0.9.2.B -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
