11-04-15, 04:46 #1Registered User
- Join Date
- Nov 2015
Unanswered: DB admin is telling me our db does not recognize that "ä" and "Ä" belong together
The Problem: We have a street named "Ästerstrasse" in the db. We enter "ä" as search term and we get 0 results. But if we enter "Ä" we get all streets beginning with an Ä (like Ästerstrasse).
Now we contacted the db admin and he told us: "We set the db to international so that things like € are recognized. But this leads to the issue that the DB does not recognize german Umlaute like ä or ü. By that it does also not know that Ä and ä belongs together. We cannot change this without loosing other functionalities. It is also not possible to use the UPPER() function for umlaute. The db is configured for case-insensitive search but as it turns out this is not working for umlaute.
As we are running Sybase 12.5 he suspects this is the issue.
Now my questions: The db is behaving correctly if we enter Ä. So it knows Umlaute. It the db admin correct? Or is this just something not set correctly?
We are running Adaptive Server Enterprise by Sybase in Version 12.5. I know its old, that is why I ask you guys as I am not sure if maybe he is right and I am not a db expert.
11-04-15, 07:14 #2Registered User
Provided Answers: 4
- Join Date
- Jan 2004
As far as I know choosing a specific character set (to allow umlauts) doe not mean you can't set the observer to accent insensitive sort order. I have had a few ASE12.5 instances that allowed umlauts and still were set to accent insensitive sort orders.I'm not crazy, I'm an aeroplane!