![]() |
#8 |
Участник
|
Выдержка из документации
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 символов) |
|