Hi all,

we experience a sorting problem since we migrated from tbase to oracle 9i.
As we are a german company, we use letters like ÖÄÜ as item descriptions, line "Ölpumpe" etc.

Now, when you use print sessions in which we can specify a print range of item descr., from-to, we find, that those items starting with ÖÄÜ are not printed.
range is " " to "ZZZZ".

problem is that oracle sorts the ÖÄÜ after "Z", so no printout.

when using binary sort and range up to "ÿÿÿÿÿÿ" it works.

this would be a work-around but is not very convenient, cause we have loads of sessions that use form defaults like "ZZZZZZZZZZZ", so we would have to modify them all :(

any good ideas ?!?!?

Jochen

Well, we're also germans, so lets communicate in our best English!

I guess you are now using ISO-8859-1 which is best for western europe and I would say Oracle does the right thing. I have no idea what character set T-base uses.

As you already said, common usage of ÄÖÜ is in some fields such as descriptions (and hence in generated search keys). For such fields, you must not use the fix string "zzz..." but insead "fmax($#)" e.g. on form defaults or session scripts. I think you have to change your customizations here, sorry.

There is another point to mention: Check your user's locale (Maintain User Data, Form 4). There is a difference between "ISO-8859-1" and "ISO_BIN". I guess you should have "ISO-8859-1" for your problem. (Please check the different behaviour for one user first on sessions having fmax($#) as form default; don't forget to convert to runtime).

Günther

Danke Günther for your thoughts.

i already changed the locale before, with no effect concerning our problem.

i guess, the only possibility would be to modify all sw-components, which i don't want.
OR
i think i make my users change all descriptions ( or write a small query ).

any more ideas ?!?!

Jochen

i think i make my users change all descriptions ( or write a small query ).


Bah! My name is Günther, not Guenther - what more should I say?

Have you already tried to figure out, how much data you have to change. What about the future? Germans will enter Ölpumpe the next day, too.

Hey Günther, not Guenther,

would you also insist to be filed as Günther even when you know you won't get paid any commision for your orders.
I guess out reps would prefer to be called Guenther and receive full commission.

:rolleyes:

Jochen

i already changed the locale before, with no effect concerning our problem.

If you have a session with e.g. two form fields "item.f" and "item.t", the first one should have default [x] and value (empty). The second one should have [x] and value "fmax($#)".

* For a user with locale "ISO_BIN", the item.t field will be "ZZZ...".
* For a user with locale "ISO-8859-1", the item.t field will be "ÿÿÿ...".

Please check that for the moment!

Günther

If I use ISO_BIN as locale setting for our german site they get ranges from '' '' to "ÿÿÿ"

so no need to change forms etc.

Regards,
Han