cast data in mysql

Want to convert some data from one thing into something else within MySQL? Try cast!

select id, cast(sequence as CHAR(1000) character set utf8) from table;

The cast, in this case, is required because the data is being stored in BLOB format rather than as a textfield or a simple varchar – either would do the job. I am not responsible for this.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s