|
Выдержка из документации
char and varchar
Fixed-length (char) or variable-length (varchar) character data types.
char[(n)]
Fixed-length non-Unicode character data with length of n bytes. n must be a value from 1 through 8,000. Storage size is n bytes. The SQL-92 synonym for char is character.
varchar[(n)]
Variable-length non-Unicode character data with length of n bytes. n must be a value from 1 through 8,000. Storage size is the actual length in bytes of the data entered, not n bytes. The data entered can be 0 characters in length. The SQL-92 synonyms for varchar are char varying or character varying.
Remarks
When n is not specified in a data definition or variable declaration statement, the default length is 1.
When n is not specified with the CAST function, the default length is 30
Получается что при выполнении синхронизации таблиц Axapta использует конструкции типа
UPDATE INVENTCLOSING SET VOUCHER={fn IFNULL({fn LTRIM(CAST(VOUCHER AS VARCHAR))},' ')}
что есть не совсем корректно (cast(<поле> as varchar) будет выдавать максимум 30 символов)
|