My Oracle Support Banner

Converting Blob To Longtext (Doc ID 2499341.1)

Last updated on MARCH 03, 2020

Applies to:

MySQL Server - Version 5.7 and later
Information in this document applies to any platform.


On converting a blob to longtext field, the values show correctly in the mysql command client and MySQL Workbench, but when loading the data in a Windows text editor it shows padded zeros like:

'T\0o\0 \01\09\01\01\0\r\0\n\0Y\0.\0 \0F\0u\0j\0i\0t\0a\0 \0a\0n\

Why does this happen?


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.