postgresql support well long string. so i modify some column (sql command) to long string.
now when i export 2pack from old (or pure) instance it will import empty to this column.
reason: it treatment column like blob, so try to read from binary.
solution: check if have text value, set like text, other treatment like blob
Found that commit 1031d73 still had an issue and it was not working fine.
Fixed in 6.1 with commit 9c91b54
Also, noticed the opposite case is also broken - this is: in case a 2pack is generated on a system with a blob column, and then imported in a system where that column is string, the import leaves wrong data. Maybe could be worthy to fix that possibility also?
correct case string value is "acb|cdf" will wrong detect as blobs
will test and fix issue on your latest command
Hi , so the use case here is the source and target is using different text data type ? if yes, what are the data type involve ?
yeb for same column
one instance use short string type (example string, text)
other instance use long string type (text long)