Select char_length(cast('123456789 1' as varchar(10))) from rdb$database. Получаем: Exception ... string truncation Т.е. пробел мы обрезать можем, а другие символы нет. Так и должно быть или нет?
select cast (2000 as type of quint) from rdb$database select cast (2000 as int) from rdb$database. If TYPE OF is used with a (VAR)CHAR type, its character.
select cast (2000 as type of quint) from rdb$database select cast (2000 as int) from rdb$database. If TYPE OF is used with a (VAR)CHAR type, its character.
Бесплатный сервис Google позволяет мгновенно переводить слова, фразы и веб-страницы с английского на более чем 100 языков и обратно.
select cast (2000 as type of quint) from rdb$database select cast (2000 as int) from rdb$database. If TYPE OF is used with a (VAR)CHAR type
select cast (2000 as type of quint) from rdb$database select cast (2000 as int) from rdb$database.
There are : 82 website users Online And : 5 users talking here. Free For All . - Page Loaded In 0.171 Second.
Since you're casting from a larger integer type to a smaller one, it takes the least significant part regardless of endianness. If you were casting pointers instead, though, it would take the byte at the address, which would depend on endianness. So c = (char)i assigns the least-significant byte to c, but...
CAST(expression AS datatype(length)). Parameter Values.
When the CAST or CONVERT functions output a character string, and they receive a character string input, the output has the same collation and collation label as the input.