Html type store in postgresql result in byte

[chenwl]

With yesod-0.10.1

Definition:

postBlogR :: Handler RepHtml
postBlogR = do
((res, articleWidget), enctype) <- runFormPost entryForm
case res of
FormSuccess article -> do
articleId <- runDB $ insert article
setMessage $ toHtml $ (articleTitle article) <> " created"
redirect $ ArticleR articleId
_ -> defaultLayout $ do
setTitle "Please correct your entry form"
$(widgetFile "articleAddError")
Database

Article
title Text
content Html
deriving
I get \x48656c6c6f2c20776f726c6421 in database if I post Hello, world!
Also it present as '\x48656c6c6f2c20776f726c6421' in web page.

I've tried mongodb and sqlite, both works as expect. Postgresql is
strange.

[Michael Snoyman]

This was a bug in earlier versions of the persistent package. It
should be solved in the most recent release (0.8.0.2). Can you try
upgrading to that and see if the problem persists?

Michael

[陈文龙]

Thanks, I'll try

2012/3/20 Michael Snoyman <mic...@snoyman.com>

[陈文龙]

After upgrade persistent to 0.8.0.2, it is fixed.

I am curious what cause the bug. Why only postgresql affected?

2012/3/20 陈文龙 <qzch...@gmail.com>

[Michael Snoyman]

You can see the previous discussion here:
http://groups.google.com/group/yesodweb/browse_thread/thread/54cee822675f5857/6d305b5dd96d026c?hl=en_US&lnk=gst&q=postgresql#6d305b5dd96d026c

Go towards the bottom to see the actual problem and its resolution.

Michael