User wants to migrate db from 4.1 to 5.2 and they unload DB from DBMaker4.1, and then try to load db to 5.2, but Warning63 (Data truncated when converting from different type)　was faced. The Warning63 caused by the last “line break” which is not a printable SJIS symbol. For unloading data from Table, the best workaround should be “set unload chartohex on”, but the feature only have been supported from DBMaker4.3 version.

Generally, we think if drop the last "\t” for the problematical records, the WARNING (63) will be disappeared, but actually, the last "\t" still be truncated and other "\t" still cannot be loaded correctly. And some SJIS Kanji cannot be loaded correctly.

For example: "能"

The hex for "能" is 945c, the "5c" is same with hex of line break - "0D0A", so "5c" is taken as line break - "\" for mistake. When we load this SJIS Kanji the "945c" is truncated to "94", which cause some wrong record data, not same as before.

In addition, the DBMaker4.1 version does not support the workaround “set unload chartohex on”. So we can’t use unload/load directly from 4.1 to 5.2, the right way as below:

(1). Upgrade DBMaker4.1 to DBMaker4.34. We can start db with DB file of DBMaker4.1,, and please backup DB at first.

(2). Unload data from DBMaker4.34 with "set unload chartohex on".

(3). Load data to DBMaker5.2.

Then we can successfully unload db from DBMaker4.1 version and load db to DBMaker5.2 version.

Version: DBMaker5.x

Product: Normal /Bundle

Platform: All