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