From String to Blob

Question

I am trying to use concat_ws inside a group_concat command. With a query, which simplified looks like:

SELECT item.title, GROUP_CONCAT( CONCAT_WS(  ',', attachments.id, attachments.type,     attachments.name ) )  as attachments
FROM story AS item
LEFT OUTER JOIN story_attachment AS attachments ON item.id = attachments.item_id
GROUP BY item.id

I get the attachments column as a Blob type. is it it possible to get it as a string instead of Blob?

Wayne · Accepted Answer · 2008-10-10 17:05:50Z

2

You need to cast as a char..

SELECT item.title, GROUP_CONCAT( CAST(CONCAT_WS(',', attachments.id, 
attachments.type, attachments.name ) as CHAR ) ) as attachments 
FROM story AS item 
LEFT OUTER JOIN story_attachment AS attachments 
ON item.id = attachments.item_id GROUP BY item.id

edited Oct 10, 2008 at 17:05

answered Oct 10, 2008 at 16:06

Wayne

40.2k4 gold badges40 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Draemon · Accepted Answer · 2008-10-10 16:09:38Z

0

Although I suspect CAST is the appropriate answer, it's worth mentioning that I ran into a similar thing in the past which turned out to be down to a strange/conflicting collation type and character set.

answered Oct 10, 2008 at 16:09

Draemon

34.9k16 gold badges80 silver badges106 bronze badges

Collectives™ on Stack Overflow

From String to Blob

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related