Thread: BUG #7867: Similarity function fails
The following bug has been logged on the website: Bug reference: 7867 Logged by: Michele Baravalle Email address: michele.baravalle@me.com PostgreSQL version: 9.2.3 Operating system: Mac OSX 10.8 Description: = Using this sql: SELECT similarity('=D0=9A=D1=80=D1=83=D0=B8=D0=B7-=D0=BA=D0=BE=D0=BD=D1=82= =D1=80=D0=BE=D0=BB=D1=8C =D0=BE=D1=82=D0=BA=D0=BB=D1=8E=D1=87=D0=B5=D0=BD',= '=D0=9A=D1=80=D1=83=D0=B8=D0=B7-=D0=BA=D0=BE=D0=BD=D1=82=D1=80=D0=BE=D0=BB= =D1=8C =D0=BE=D1=82=D0=BA=D0=BB=D1=8E=D1=87=D0=B5=D0=BD'); work well on Linux and Windows and the result is 1: on OSX the result is NaN. Thanks
michele.baravalle@me.com writes: > Using this sql: > SELECT similarity('ÐÑÑиз-конÑÑÐ¾Ð»Ñ Ð¾ÑклÑÑен', 'ÐÑÑиз-конÑÑÐ¾Ð»Ñ Ð¾ÑклÑÑен'); > work well on Linux and Windows and the result is 1: on OSX the result is > NaN. I couldn't reproduce that on my own Mac. I tried it in ru_RU.UTF-8 and en_US.UTF-8 locales --- perhaps you are using something else? regards, tom lane