Explore Courses Blog Tutorials Interview Questions
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.4k 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;

To master SQL statements, queries and become proficient in SQL queries, enroll in our industry-recognized SQL course.

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
asked Dec 22, 2020 in SQL by Appu (6.1k points)
Welcome to Intellipaat Community. Get your technical queries answered by top developers!

28.4k questions

29.7k answers


94.1k users

Browse Categories