Thread: BUG #14415: non-breaking space matching in regex as whitespace

BUG #14415: non-breaking space matching in regex as whitespace

From
valerijs.gusjkovs@gmail.com
Date:
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz
aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDQxNQpMb2dnZWQgYnk6ICAg
ICAgICAgIFZhbGVyeSBHdXNrb3YKRW1haWwgYWRkcmVzczogICAgICB2YWxl
cmlqcy5ndXNqa292c0BnbWFpbC5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiA5
LjYuMApPcGVyYXRpbmcgc3lzdGVtOiAgIFJlZEhhdApEZXNjcmlwdGlvbjog
ICAgICAgIAoKVGhpcyB3YXMgd29ya25nIG9uIDkuNCBhdCBsZWFzdCwgYnV0
IGRvZXMgbm90IGluIDkuNi4gRm9sbG93aW5kIHJldHVybnMKc2hvdWxkIGJl
IHJldmVyc2VkIGFzIG5vbi1icmVha2luZyBzcGFjZSBpcyB3aGl0ZXNwYWNl
Og0KDQpzZWxlY3QgJ1dlYsKgcHJvamVjdCBleHBlcmllbmNlJyB+KiAnV2Vi
XFMrJyBhcyBwZXc7DQogcGV3DQotLS0tLQ0KIHQNCigxIHJvdykNCg0KX19f
X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX18N
Cg0Kc2VsZWN0ICdXZWLCoHByb2plY3QgZXhwZXJpZW5jZScgfiogJ1dlYlxz
KycgYXMgcGV3Ow0KIHBldw0KLS0tLS0NCiBmDQooMSByb3cpCgo=

Re: BUG #14415: non-breaking space matching in regex as whitespace

From
Tom Lane
Date:
valerijs.gusjkovs@gmail.com writes:
> This was workng on 9.4 at least, but does not in 9.6. Followind returns
> should be reversed as non-breaking space is whitespace:

What encoding and LC_CTYPE are you using?  AFAIR we haven't changed
anything about that code behavior since 9.4, so the most likely theory
is that your 9.6 installation is using a locale/encoding that doesn't
consider NBSP to be whitespace --- as C locale wouldn't, for example.

            regards, tom lane