I would guess then that you mispelled any of the names. I tried your query in a database I have, with different names of course, and I got the result back.
However, Normally I would write the query as:
SELECT name, collation_name
WHERE object_id = Object_id('Orders')
AND name = 'CustomerID'
Or I would be lazy and simply use sp_help...