This seems to work:
UPDATE Posts
SET content = 0xFFFE + content

Then:
SELECT
Id,
CONVERT(nVARCHAR(MAX), [Title]) AS [Title],
CONVERT(nVARCHAR(MAX), [Content]) AS [Content]
FROM Posts
where Contains(Content, 'foo')

Apparently a byte marker is needed to clean this up.