character setting trouble

[griffith]

Hi

php multibyte functions support only iso-8859-6 (arabic) while
mysql supports only cp1256 (windows arabic).

i'm storing iso-8859-6 string in binary column and later i want to order by this column but this is not possible because mysql can not convert to iso-8859-6...

Anything i can do about this situation? -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[divinepower]

Try this out

store a portion of the field, let say the first 20 characters in a char or varchar field and then use that field to sort on.

Bye -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[nchammer]

Hey pal
There is one other way to do this

You can fetch the data from database, then put it in an array, and then sort it in the script before outputting it.
Doing this in PHP would be fast and easy, if you are able to let PHP sort correctly by the language used. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[zinedine]

Create another field in the table. A numeric field where one can enter a numeric value, indicating the sort order for the record.
It all depends on how much control you have over the database and the scripts. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --