Sort order using swedish åäö

Robert57

Joined: 2005-11-25
Posts: 33
Posted: Fri, 2006-03-31 07:35

Hi
I'm using Titel - Ascending to sort the album. When the Titel is using swedish åäö this pictures is sorted as "a" and "o". The should be sorted last in the album in the order å ä ö.

Is it possible for me to fix this?

regards
Robert

Gallery version = 2.0.2 core 1.0.0.2
PHP version = 4.4.1 cgi-fcgi
Webserver = Microsoft-IIS/6.0
Database = mysql 5.0.16-nt
Toolkits = Exif, ImageMagick, Ffmpeg
Operating system = Windows NT AXSRV02 5.2 build 3790
Browser = Mozilla/4.0 (compatible; M
 
mindless
mindless's picture

Joined: 2004-01-04
Posts: 8601
Posted: Fri, 2006-03-31 17:15

the database does the sort... i'm not sure if there are database settings to affect how sorting is done :(
 
Robert57

Joined: 2005-11-25
Posts: 33
Posted: Fri, 2006-03-31 17:22

Of cause. I will check Mysql to see.
txn
Robert
 
Robert57

Joined: 2005-11-25
Posts: 33
Posted: Fri, 2006-03-31 17:56

I have checked MYSQL but I'm not sure wish tabel that holds the Titel. Is it the Item tabel?
However I did some test and change between different charset and charset for sort order but with no success.

Is there anyone there how know what to do?

regards
Robert

Gallery version = 2.0.2 core 1.0.0.2
PHP version = 4.4.1 cgi-fcgi
Webserver = Microsoft-IIS/6.0
Database = mysql 5.0.16-nt
Toolkits = Exif, ImageMagick, Ffmpeg
Operating system = Windows NT AXSRV02 5.2 build 3790
Browser = Mozilla/4.0 (compatible; M