>>>>> On Mon, 5 Sep 2022 11:21:52 +0200, Uwe Schuerkamp said: > > I've tried casting "blob" and "tinyblob" (the mariadb column types for > VolumeName, for example) to "text", but pgloader just hangs when > including those cast statements.
What exact cast statement did you use? > > Also, Dima wrote earlier: > > > Because it's a hex text, presumably ;) > > > This is likely happening when pulling the data out of mysql, not when > > displaying it in bconsole. > > > You could try `select encode(Volume, 'hex') from` whatever table it's in, in > > psql. If that looks OK: `update $table set Volume=encode(Volume, 'hex')` > > would > > be quick fix. Maybe add a guard along the lines of "where Volume like '\x%'" > > or something. > > When doing the "select" outlined above I simply end up with the same > volume names minus the leading "\x": > > bacula=# select encode(VolumeName, 'hex') from media; > encode > ---------------------------- > 7a69662d66756c6c2d30303031 > 7a69662d696e63722d30303032 > 7a69662d696e63722d30303033 > ... I think you need convert_from(), not encode(). Something like select convert_from(VolumeName::bytea, 'SQL_ASCII') from media; __Martin _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
