PHP RSS PHP RSS

Sort Problem

Thread Solved
1 2

•
•
Join Date: Aug 2007
Posts: 199
Reputation: tanha is an unknown quantity at this point 
Solved Threads: 0
tanha tanha is offline Offline
Junior Poster

Sort Problem

 
0
  #1
May 17th, 2008
Hello everybody,
I am using WAMP:
1. PHP 5..
2. MySQL 5..
3. Apache 2..

the collation of my database and tables and fields are 'utf8_persian_ci', and also my query is in this format in PHP:
PHP Syntax (Toggle Plain Text) 
  1. mysql_query("SET NAMES utf8");
  2. mysql_query("SET CHARACTER SET utf8");
  3. $query = mysql_query("SELECT * FROM tblName SORT BY fieldName COLLATE utf8_persian_ci");

this all utf8 is for my Arabic and persian words...

Problem:
I faced a problem on sorting english words, I dont know why the result on the browser is like the attachment
Attached Thumbnails
sort.PNG  
Reply With Quote Quick reply to this message  
•
•
Join Date: Jan 2008
Posts: 71
Reputation: amigura is an unknown quantity at this point 
Solved Threads: 7
amigura's Avatar
amigura amigura is offline Offline
Junior Poster in Training

Re: Sort Problem

 
0
  #2
May 17th, 2008
just a guess check for extra spaces
http://www.amigura.co.uk
Reply With Quote Quick reply to this message  
•
•
Join Date: Aug 2007
Posts: 199
Reputation: tanha is an unknown quantity at this point 
Solved Threads: 0
tanha tanha is offline Offline
Junior Poster

Re: Sort Problem

 
0
  #3
May 17th, 2008
There is no more spaces...

just I dont know why doing like this
Reply With Quote Quick reply to this message  
•
•
Join Date: Jan 2008
Posts: 71
Reputation: amigura is an unknown quantity at this point 
Solved Threads: 7
amigura's Avatar
amigura amigura is offline Offline
Junior Poster in Training

Re: Sort Problem

 
0
  #4
May 17th, 2008
http://bugs.mysql.com/bug.php?id=30675

http://bugs.mysql.com/bug.php?id=29977
http://www.amigura.co.uk
Reply With Quote Quick reply to this message  
•
•
Join Date: Aug 2007
Posts: 199
Reputation: tanha is an unknown quantity at this point 
Solved Threads: 0
tanha tanha is offline Offline
Junior Poster

Re: Sort Problem

 
0
  #5
May 17th, 2008
I dont have farsi sort problem, but see the attachment, the problem is that the english words are not sorted correctly ...

also I enter through the web, mysql command line, phpMyAdmin the following data:
Asad
asad
Asad
asad

and again by executing the following query I get the same dispaly:
SELECT * FROM tblName order by fieldName;

or

SELECT * FROM tblName order by fieldName COLLATE utf8_persian_ci;

The Result:
Asad
asad
Asad
asad
Last edited by tanha; May 17th, 2008 at 8:38 pm.
Reply With Quote Quick reply to this message  
•
•
Join Date: Jan 2008
Posts: 71
Reputation: amigura is an unknown quantity at this point 
Solved Threads: 7
amigura's Avatar
amigura amigura is offline Offline
Junior Poster in Training

Re: Sort Problem

 
0
  #6
May 17th, 2008
try

PHP Syntax (Toggle Plain Text) 
  1. SELECT * FROM  table_name ORDER BY BINARY column_name ASC
http://www.amigura.co.uk
Reply With Quote Quick reply to this message  
•
•
Join Date: Aug 2007
Posts: 199
Reputation: tanha is an unknown quantity at this point 
Solved Threads: 0
tanha tanha is offline Offline
Junior Poster

Re: Sort Problem

 
0
  #7
May 17th, 2008
Then if I try to use the binary, then it is ok, but you know that the binary sort according to ascii code of the character, then the following problem:
Asad
asad
Asad
asad
Bob
Tom
the output:

Asad
Asad
Bob
Tom
asad
asad

The sort must be like this:
Asad
Asad
asad
asad
Bob
Tom
Last edited by tanha; May 17th, 2008 at 9:06 pm.
Reply With Quote Quick reply to this message  
•
•
Join Date: Jan 2008
Posts: 71
Reputation: amigura is an unknown quantity at this point 
Solved Threads: 7
amigura's Avatar
amigura amigura is offline Offline
Junior Poster in Training

Re: Sort Problem

 
0
  #8
May 17th, 2008
SELECT * FROM table_name ORDER BY column_name, BINARY column_name ASC
http://www.amigura.co.uk
Reply With Quote Quick reply to this message  
•
•
Join Date: Aug 2007
Posts: 199
Reputation: tanha is an unknown quantity at this point 
Solved Threads: 0
tanha tanha is offline Offline
Junior Poster

Re: Sort Problem

 
0
  #9
May 17th, 2008
again it is the same result, nothing more... but I need the result as:
Asad
Asad
asad
asad
Bob
Tom
Reply With Quote Quick reply to this message  
•
•
Join Date: Jan 2008
Posts: 71
Reputation: amigura is an unknown quantity at this point 
Solved Threads: 7
amigura's Avatar
amigura amigura is offline Offline
Junior Poster in Training

Re: Sort Problem

 
0
  #10
May 17th, 2008
when i try it i get

ASAD
ASAD
ASAD
AsAD
Asad
Asad
asad
asad
BOB
Bob
bob
TOM
tom
tom
http://www.amigura.co.uk
Reply With Quote Quick reply to this message  
Reply
1 2

Quick Reply to Thread
This thread has been marked solved.
Perhaps start a new thread instead?
•
•
•
•
•
•
•
•
Message:
•
•
•
•



Similar Threads
Other Threads in the PHP Forum
Thread Tools Search this Thread



.htaccess ajax apache api array back basic beginner binary broken cakephp checkbox class cms code computing cron curl customizableitems database date delete display dynamic echo email error file files filter folder form forms function functions gc_maxlifetime google host href htaccess html image include insert integration ip java javascript joomla limit link login loop mail memmory memory menu mlm mod_rewrite multiple mysql navigation oop parsing paypal pdf php problem query radio random recursion regex remote script search server sessions sms snippet soap source space sql syntax system table thesishelp trouble tutorial update upload url validation validator variable video web xml youtube
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC