Sorting Integer value treeview column

[Jason Brisbane <darkeen westnet com au>]

Hello,

I have a treeview that is populated with an Integer value (from a mysql 
database) that is populated into a G_TYPE_STRING. This displays 
correctly but the sort function using:
         gtk_tree_view_column_set_sort_column_id (col, x);
         gtk_tree_view_column_set_sort_indicator (col, TRUE);

sorts the values as Alphanumeric, not numeric.
ie:
12
2
3
6
7

instead of
2
3
6
7
12

Do I need to hook in a Sort function and use the Modelsort instead of Model?
Should sorting a integer value be a basic function of a treeview/liststore?
Should I be setting an attribute of the column as "integer" instead of 
"text"?

The entire function is listed here:

void populate_battle (gchar *battleid)
{
// Get Treeview and populate with all the Combatants in the Battle!
gchar   *sql;
MYSQL   *conx;
MYSQL_RES *result_set;
MYSQL_ROW db_row;
MYSQL_FIELD *field;
GtkListStore *list_store;
GtkTreeModel *model;
GtkTreeIter iter;
GtkTreeView *treeview2;
GtkCellRenderer *renderer; 
GtkTreeViewColumn *col;
GtkTreeSelection  *selection;
gint x, MAX_BATTLE_COLUMNS = 9;
gboolean valid;
gchar *BATTLE_COLS[] = { "ID", "Name", "Init", "AC","Flat", "Touch", 
"HP", "Max HP", "Base Init" };

// CREATE THE TREE_VIEW
treeview2 = GTK_TREE_VIEW(lookup_widget(battlemaster_mainwindow, 
"treeview2"));
selection = gtk_tree_view_get_selection(GTK_TREE_VIEW(treeview2));
gtk_tree_selection_set_select_function(selection, 
copy_battle_creature_func, NULL, NULL);
model = gtk_tree_view_get_model(treeview2);
// Clear out old Model so we can get the new one.
// gtk_list_store_clear (GTK_LIST_STORE(model));
if (model == NULL)
{
   // CREATE COLUMN HEADERS
   for (x=0; x< MAX_BATTLE_COLUMNS; x++)
   {
      // -- Add Column X --
      col = gtk_tree_view_column_new();
      gtk_tree_view_column_set_title(col, BATTLE_COLS[x]);
      gtk_tree_view_append_column(GTK_TREE_VIEW(treeview2), col);
      renderer = gtk_cell_renderer_text_new();
      gtk_tree_view_column_pack_start(col, renderer, TRUE);
      gtk_tree_view_column_add_attribute(col, renderer, "text", x);
      gtk_tree_view_column_set_resizable(col, TRUE);
      gtk_tree_view_column_set_expand(col, TRUE);
      if (x == 2)
      {
         gtk_tree_view_column_set_sort_column_id (col, x);
         gtk_tree_view_column_set_sort_indicator (col, TRUE);
         g_object_set(renderer, "editable", TRUE, NULL);
         g_signal_connect(renderer, "edited", (GCallback) 
init_edited_callback, NULL);

      }
      if (x == 6)
      {
         g_object_set(renderer, "editable", TRUE, NULL);
      }

  }
}
   // Create the data storage
   list_store = gtk_list_store_new (MAX_BATTLE_COLUMNS, G_TYPE_STRING, 
G_TYPE_STRING, G_TYPE_STRING, G_TYPE_STRING, G_TYPE_STRING, 
G_TYPE_STRING, G_TYPE_STRING, G_TYPE_STRING, G_TYPE_STRING);
/* First, connect to the database. */
conx = mysql_init(0L);
if (conx != 0L)
{
  conx = mysql_real_connect(conx, SERVER, USER, PASS, DBASE, 0, 0L,0);
  if (conx != 0L)
  {
   sql = g_strconcat("select c1.nameid, c1.charname, b1.init, c1.ac, 
c1.flat, c1.touch, b1.actualhp, c1.hp, c1.init from battle b1, creature 
c1 where b1.nameid = c1.nameid AND combatid = ", combat_id, " ; ", 0L);
   if (mysql_query (conx, sql) == 0)
   {
     result_set = mysql_store_result (conx);
     // ADD ONE ROW FOR EACH MYSQL ROW RETRIEVED
     while ((db_row = mysql_fetch_row (result_set)) != 0L)
     {
         gtk_list_store_append (list_store, &iter);
         // Now Fill a Row with the Data Retrieved
         gtk_list_store_set (list_store, &iter, 0, db_row[0],
            1, db_row[1],
            2, db_row[2],
            3, db_row[3],
            4, db_row[4],
            5, db_row[5],
            6, db_row[6],
            7, db_row[7],
            8, db_row[8],  -1);
     }
     mysql_close(conx);
  }
 }
 model = GTK_TREE_MODEL(list_store);
 gtk_tree_view_set_model (treeview2, model);
 g_object_unref (model);
}
gtk_widget_show(GTK_WIDGET(treeview2));
}


Thanks for any guidelines.....


--
---
Regards,

Jason Brisbane