Costum Alpabetic Sorting in Access

[D. Roshani]

Hello

Do you have any idea how I can create a Macro in Access which can do costume alphabetic sorting of
only one column with foreign words (ISO-8859-1),

I would like to define how I want those words positioned according to my costume sorting order.

Thank you for your help,

Dilan

[Jeremy Wallace]

Dilan,

It's probably easiest to make a second table that lists all of the possible
words in the column to be sorted and has another field with numbers in it,
indicating the sort order.

That way you'll be able to add the other table to your queries, linked on
the first field and sort by the second (numerical) field.

Jeremy

PS: "Costume" is an outfit you dress up in. "Custom" means designed for a
specific purpose. Just thought I'd point it out--I only speak one language,
so I'm certainly not criticizing.

"D. Roshani" <di***@c2i.net> wrote in message
news:bl**********@oyez.ccc.nottingham.ac.uk...

Hello

Do you have any idea how I can create a Macro in Access which can do costume alphabetic sorting of only one column with foreign words (ISO-8859-1),

I would like to define how I want those words positioned according to my costume sorting order.
Thank you for your help,

Dilan

[Michael \(michka\) Kaplan [MS]]

Custom collation at the engine level is not supported by Access (or by
Windows, the original source of the Access collation data). Incidentally,
none of the ISO-8859-# encodings specify collations in them.

Out of curiousity, what language arre you trying to collate that would not
be in Windows already that is in Latin1?
--
MichKa [MS]
Windows Globalization, Collation Developer

This posting is provided "AS IS" with
no warranties, and confers no rights.
"D. Roshani" <di***@c2i.net> wrote in message
news:bl**********@oyez.ccc.nottingham.ac.uk...

Hello

Do you have any idea how I can create a Macro in Access which can do costume alphabetic sorting of only one column with foreign words (ISO-8859-1),

I would like to define how I want those words positioned according to my costume sorting order.
Thank you for your help,

Dilan

[Michael \(michka\) Kaplan [MS]]

This is great if

1) you only care about the first letter
2) if the language has no compressions
3) if there are no reverse diacritic (e.g. French) type issues

In other words, not very often. Its simply not a problem with a good
solution that does not involve the OS local-specific data.
--
MichKa [MS]
Windows Globalization, Collation Developer

This posting is provided "AS IS" with
no warranties, and confers no rights.
"Jeremy Wallace" <ne**@abcdataworks.SKIPTHISPART.com> wrote in message
news:jP********************@speakeasy.net...

Dilan,

It's probably easiest to make a second table that lists all of the possible words in the column to be sorted and has another field with numbers in it,
indicating the sort order.

That way you'll be able to add the other table to your queries, linked on
the first field and sort by the second (numerical) field.

Jeremy

PS: "Costume" is an outfit you dress up in. "Custom" means designed for a
specific purpose. Just thought I'd point it out--I only speak one language, so I'm certainly not criticizing.

"D. Roshani" <di***@c2i.net> wrote in message
news:bl**********@oyez.ccc.nottingham.ac.uk...

Hello

Do you have any idea how I can create a Macro in Access which can do

costume alphabetic sorting of

only one column with foreign words (ISO-8859-1),

I would like to define how I want those words positioned according to my

costume sorting order.

Thank you for your help,

Dilan

[Marc]

"D. Roshani" <di***@c2i.net> wrote in message news:<bl**********@oyez.ccc.nottingham.ac.uk>...

Hello

Do you have any idea how I can create a Macro in Access which can do costume alphabetic sorting of
only one column with foreign words (ISO-8859-1),

I would like to define how I want those words positioned according to my costume sorting order.

Thank you for your help,

Dilan

Dilan,

I think you mean custom in stead of costume.
If you want some advice I think you will have to describe more
precisely what kind of access version you are using, the locale-id or
sort-order ("tools > options > general > New database sort order"
menu-item) that you are using and the operating system version and
language configuration.

if the characters are not all readable it is possible you converted
some older access version not in the proper way. see also the next
web-page:

http://www.microsoft.com/office/ork/xp/three/intc05.htm

Marc

[D. Roshani]

Thanks!
It is Kurdish which is not supported in any MS applications please see the web page at
http://www.kurdistanweb.org/kval/

Dilan

Michael (michka) Kaplan [MS] wrote:

Custom collation at the engine level is not supported by Access (or by
Windows, the original source of the Access collation data). Incidentally,
none of the ISO-8859-# encodings specify collations in them.

Out of curiousity, what language arre you trying to collate that would not
be in Windows already that is in Latin1?

[D. Roshani]

not only the first letter this is the sorting order
http://kurdweb.humanrights.de/kval/e...bet-table.html

There is no compressions for it so you can use the sorting functions for other languages, But the
idea for sorting is the same as in any other language so it is not about the first letter only,

Michael (michka) Kaplan [MS] wrote:

This is great if

1) you only care about the first letter
2) if the language has no compressions
3) if there are no reverse diacritic (e.g. French) type issues

In other words, not very often. Its simply not a problem with a good
solution that does not involve the OS local-specific data.

[Michael \(michka\) Kaplan [MS]]

Yes, that was the point of my message.
--
MichKa [MS]

This posting is provided "AS IS" with
no warranties, and confers no rights.
"D. Roshani" <di***@c2i.net> wrote in message
news:bl**********@oyez.ccc.nottingham.ac.uk...

not only the first letter this is the sorting order
http://kurdweb.humanrights.de/kval/e...bet-table.html

There is no compressions for it so you can use the sorting functions for other languages, But the idea for sorting is the same as in any other language so it is not about the first letter only,
Michael (michka) Kaplan [MS] wrote:

This is great if

1) you only care about the first letter
2) if the language has no compressions
3) if there are no reverse diacritic (e.g. French) type issues

In other words, not very often. Its simply not a problem with a good
solution that does not involve the OS local-specific data.

[Michael \(michka\) Kaplan [MS]]

Ah yes, you are right. Kurdish support is not available in any version of
Windows. Even if/when it is added to Windows, it could not be added to
Access as the Jet collation tables are frozen at this point.

Please note that contrary to your other message there *are* compressions
here (Jh, ll, rr, Sh). It is not the most complex possible collation but it
is not as simple as other Latin-script languages like english or Swedish.

Note that for the Arabic script, there are several Unicode code points that
are not currently in the table at all so they are sorted as if they do not
exist. This will be changed in the next version of Windows but the Jet
tables cannot be changed here.
--
MichKa [MS]

This posting is provided "AS IS" with
no warranties, and confers no rights.

"D. Roshani" <di***@c2i.net> wrote in message
news:bl**********@oyez.ccc.nottingham.ac.uk...

Thanks!
It is Kurdish which is not supported in any MS applications please see the web page at http://www.kurdistanweb.org/kval/

Dilan

Michael (michka) Kaplan [MS] wrote:

Custom collation at the engine level is not supported by Access (or by
Windows, the original source of the Access collation data). Incidentally, none of the ISO-8859-# encodings specify collations in them.

Out of curiousity, what language arre you trying to collate that would not be in Windows already that is in Latin1?