@jooz
thanks to str_printf we can do

str_printf(query,"SELECT name FROM characters WHERE char_id = %d",(int)char_id);

instead of

str_for_num( strChar_id, char_id );
str_cpy( query, "SELECT name FROM characters WHERE char_id = " );
str_cat( query, strChar_id );

sorry for oftopic.