Re: unicode match normal forms

2021-05-18 Thread goldgraeber-werbetechnik
>> El día lunes, mayo 17, 2021 a las 01:27:40p. m. -, haman...@t-online.de >> escribió: >> >> > Hi, >> > >> > in unicode letter ä exists in two versions - linux and windows use a >> > >> > composite whereas macos prefers >> > the decomposed form. Is there any way to make a semi-exact match th

Re: unicode match normal forms

2021-05-18 Thread goldgraeber-werbetechnik
Hi Gianni, many thanks for your detailed response. It turned out that my postgresql installation is too old for normalize,so I will probably a) use an external script to normalize existing data b) change application code to normalize data before inserting or searching Regards Wolfgang >> On 17

Re: unicode match normal forms

2021-05-17 Thread Daniel Verite
Hamann W wrote: > in unicode letter ä exists in two versions - linux and windows use a > composite whereas macos prefers > the decomposed form. Is there any way to make a semi-exact match that > accepts both variants? Aside from normalizing the strings into the same normal form before com

Re: unicode match normal forms

2021-05-17 Thread Gianni Ceccarelli
On Mon, 17 May 2021 15:45:00 +0200 Matthias Apitz wrote: > There is only *one* codepoint for the German letter a Umlaut: > LATIN SMALL LETTER A WITH DIAERESI U+00E4 True. On the other hand, the sequence: * U+0061 LATIN SMALL LETTER A * U+0308 COMBINING DIAERESIS will render exactly the same gly

Re: unicode match normal forms

2021-05-17 Thread Gianni Ceccarelli
On 17 May 2021 13:27:40 - haman...@t-online.de wrote: > in unicode letter ä exists in two versions - linux and windows use a > composite whereas macos prefers the decomposed form. Is there any > way to make a semi-exact match that accepts both variants? Actually, re-reading your request, you w

Re: unicode match normal forms

2021-05-17 Thread Matthias Apitz
El día lunes, mayo 17, 2021 a las 01:27:40p. m. -, haman...@t-online.de escribió: > Hi, > > in unicode letter ä exists in two versions - linux and windows use a > composite whereas macos prefers > the decomposed form. Is there any way to make a semi-exact match that accepts > both variants

Re: unicode match normal forms

2021-05-17 Thread Gianni Ceccarelli
On 17 May 2021 13:27:40 - haman...@t-online.de wrote: > in unicode letter ä exists in two versions - linux and windows use a > composite whereas macos prefers the decomposed form. Is there any way > to make a semi-exact match that accepts both variants? You should probably normalise the string

unicode match normal forms

2021-05-17 Thread hamann . w
Hi, in unicode letter ä exists in two versions - linux and windows use a composite whereas macos prefers the decomposed form. Is there any way to make a semi-exact match that accepts both variants? This question is not about fulltext but about matching filenames across a network - I wish to av