[Apc-aa-coders] number field type

[Michael M. <mi...@gn...>]

Hi,

I have noticed that the number field types are defined as store as text 
rather than numeric what I expected. Here it is the last '1', 
sqlupdate.php3 line 1101 in CVS

e.g. $SQL_aacore[] = "INSERT INTO field (id, type, slice_id, name, 
input_pri, input_help, input_morehlp, input_default, required, feed, 
multiple, input_show_func, content_id, search_pri, search_type, 
search_help, search_before, search_more_help, search_show, 
search_ft_show, search_ft_default, alias1, alias1_func, alias1_help, 
alias2, alias2_func, alias2_help, alias3, alias3_func, alias3_help, 
input_before, aditional, content_edit, html_default, html_show, 
in_item_tbl, input_validate, input_insert_func, input_show, text_stored) 
VALUES( 'number', '', 'AA_Core_Fields..', 'Number', '100', '', 
'${AA_DOC_URL}help.html', 'qte', '1', '0', '0', 'fld', '', '100', '', 
'', '', '', '1', '1', '1', '_#UNDEFINE', 'f_h', 'alias undefined - see 
Admin pages - Field setting', '', '', '', '', '', '', '', '', '0', '0', 
'0', '', 'number', 'num', '1', '1')";

This makes it impossible to sort numerically in searches. Am I using the 
wrong field type? I have changed it on my installation but there are 
probably implications for 'live' installations.

Thanks,

Michael