0 votes
1 view
in SQL by (20.3k points)

I have a whole lot of records where the text has been stored in a blob in MySQL. For ease of handling, I'd like to change the format in the database to TEXT... Any ideas on how easy to make the change so as not to interrupt the data - I guess it will need to be encoded properly?

1 Answer

0 votes
by (40.3k points)

You can use the code this way: 

SELECT CONVERT(column USING utf8) FROM table_name

Instead of using the below code:

SELECT column FROM table_name;

Related questions

0 votes
1 answer
asked Jul 20, 2019 in SQL by Tech4ever (20.3k points)
0 votes
1 answer
0 votes
1 answer
Welcome to Intellipaat Community. Get your technical queries answered by top developers !


Categories

...