From: | David Johnston <polobo(at)yahoo(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: problem with query |
Date: | 2013-09-12 22:57:34 |
Message-ID: | 1379026654020-5770653.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Roberto Scattini wrote
> what makes the 'ñ' char special that makes the queries the same when it is
> not there?
My knowledge here is a little rough around the edges but the following is
conceptually true:
For the most part legacy encodings (or non-encodings as this case
technically falls under) recognize only the explicit case-conversions for
the latin alphabet A-Z (mapped onto "a-z") without any accents.
To reasonably process strings/varchars/clobs that contain accented letters
it is necessary to use a more modern encoding - such as UTF-8/Unicode -
which contains the necessary logic to perform the additional conversions.
these should (not going to test it myself at this time) by
case-insensitively identical:
abcdëFGH
ABCDëfgh
since the "a-d, f-h" can be converted between and the one symbol that
cannot, "ë" is the same in both string....so it isn't that the ë breaks
things but rather that symbol has no upper-case alternative to equivalently
match against...just like numbers and symbols behave in the same situation.
To ASCII ë is just a symbol without any "letter of alphabet"
characteristics.
David J.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/problem-with-query-tp5770637p5770653.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | BladeOfLight16 | 2013-09-12 23:58:11 | Re: Sum of columns |
Previous Message | Suzuki Hironobu | 2013-09-12 22:40:59 | Re: 9.2 Replication in Ubuntu ; need help |