Welcome Guest, Not a member yet? Register   Sign In
uploading an image (BLOB) to mysql
#8

(This post was last modified: 03-21-2021, 12:03 AM by richb201.)

In lookig at the log I see
Query error: Invalid utf8 character string: '\x89PNG' - Invalid query: UPDATE `substantiator`.`word` SET image_BLOB = �PNG
and then looking at the SHOW VARIABLES LIKE 'collation%'; in mysqlworkbench, I see that the database is set to 'collation_database', 'utf8mb4_0900_ai_ci'. So I think I need to modify the collation for the database to be utf8. But this is RDS so it is not very straightforward.
proof that an old dog can learn new tricks
Reply


Messages In This Thread
uploading an image (BLOB) to mysql - by richb201 - 03-19-2021, 09:04 AM
RE: uploading an image (BLOB) to mysql - by richb201 - 03-21-2021, 12:03 AM



Theme © iAndrew 2016 - Forum software by © MyBB