How do I convert from BLOB to TEXT in MySQL?

That’s unnecessary. Just use SELECT CONVERT(column USING utf8) FROM…..

Post Views: 506

Читайте также

  • How to enable MySQL Query Log?

    If you don't want or cannot restart the MySQL server you can proceed like this on your running server:Create your…

  • Mysql rownum

    Есть таблица меню в БД с полем порядка order_id, но порядок неправильный и надо порядок обновить по алфавиту другого поля title.…

  • Mysql import/export

    Экспорт БД через shell mysqldump -uroot -ppass base > dump.sql Импортировать данные из sql файла в mysql как известно можно…

Добавить комментарий

Ваш e-mail не будет опубликован. Обязательные поля помечены *

Related Posts

Laravel Many to Many Relationship Tutorial

Many To Many (e.g. User can win multiple Trophies and each trophy can belong to many Users) Steps 1 — Models classes and Tables2 — Migrations3 — Defining Relationships in Modal classes4 — Fetch/Create/Update/Delete Records Read more

Install composer packages from private repository from GitLab

I had to install a PHP package that’s not hosted on packagist. Rather, it stays under my organization’s private repository on Gitlab. So, I thought to write an article that can be easy for others Read more

How to change the commit author for one specific commit?

Interactive rebase off of a point earlier in the history than the commit you need to modify (git rebase -i <earliercommit>). In the list of commits being rebased, change the text from pick to edit Read more

Любишь мемасики?

Подпишись на мой телеграм-канал!

Открыть
Закрыть