Erik Landvall

Bloggen

  • Apache
  • CouchDB
  • CSS
  • Design pattern
  • Git
  • Javascript
  • Joomla
  • jQuery
  • Linux
  • Magento
  • Mobile
  • Netbeans
  • PHP
  • SEO
  • SQL
  • Web
  • WordPress
  • Zend Framework 2
  • Electronic cigarettes

Category / SQL

30 April, 201230 April, 2012 by Erik Landvall

Incorrect sorting with “order by”

  • SQL
  • SQL, Wordpress

Got some problems with sorting in wordpress again, posting a short solution.

Does the response return rows in incorrect order, in the sense that letters like Å and Ä are counted as A and Ö counts as O, even though you specified an “order by” statement? The fault probably lies in the table’s collation.

Continue reading →

Proudly powered by WordPress | Theme: editor by Array
  • English
  • Svenska (Swedish)