-----Original Message----- From: Barry Zubel [mailto:bar...@ablebox.com] Sent: Monday, December 06, 2004 3:43 AM To: dot...@lists.mysql.com Subject: MySqlDateTime in Datatables sorting by Text, not Date.

Okay, an odd one that I've probably managed to screw up myself (tee hee).

The following extracted code should reproduce the problem: (parts removed for brevity)

sSql = "SELECT DATECOLUMN, SOMEOTHERFIELD FROM YOURTABLE ORDER BY SOMEOTHERFIELD ASC" (where DATECOLUMN is a DATE or DATETIME Mysql Type, SOMEOTHERFIELD can be anything)

... (instantiate connector, command, and dataadapter and fill datatable with results) ...

myDataGrid.DataSource = myDataTable

Now the important thing is to have source data that spans several months. When the datagrid is displayed, simply click on the DATECOLUMN column header to resort by date ascending or descending.

I have found that the DataTable actually seems to text-sort, instead of date-sort.

For example, The dates:

01/10/2004 01/11/2004 02/10/2004 02/11/2004

Will appear IN THAT ORDER, instead of the more logical (and expected):

01/10/2004 02/10/2004 01/11/2004 02/11/2004

(Based on the UK date format, which is DD/MM/YYYY)

This has occurred since Beta 2, (I believe - I've not confirmed this yet) but I'd like someone else to verify that this is the case before I post something to the mysql bugzilla.

Ta muchly!