Whether sand or dust you want sharp edges/corners. Masonry sand is sharp sand. It locks together when compacted. Beach sand has the edges knocked off and moves around a lot. You can compact it, but water will cause it to flow. Don't ever build your house with shallow foundations on a beach.
R