Skip site navigation (1) Skip section navigation (2)

length() return wrong result

From: Cédric Villemain <cedric(dot)villemain(at)dalibo(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: length() return wrong result
Date: 2009-04-06 09:03:00
Message-ID: 49D9C544.7030108@dalibo.com (view raw or flat)
Thread:
Lists: pgsql-bugs
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

- From the documentation, length(string) is 'Number of characters in string'

But it didn't :

1/ in a LATIN9 database:

postgres=# show server_encoding;
 server_encoding
- -----------------
 LATIN9

postgres=# set client_encoding = utf8;
SET
postgres=# select length('é');
 length
- --------
      1

postgres=# set client_encoding = latin9;
SET
postgres=# select length('é');
 length
- --------
      2

2/ in a UTF8 database:

postgres=# show server_encoding;
 server_encoding
- -----------------
 UTF8

postgres=# set client_encoding = utf8;
SET
postgres=# select length('é');
 length
- --------
      1

postgres=# set client_encoding = latin9;
SET
postgres=# select length('é');
 length
- --------
      2





- --
Cédric Villemain
Administrateur de Base de Données
Cel: +33 (0)6 74 15 56 53
http://dalibo.com - http://dalibo.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)

iEYEARECAAYFAknZxUQACgkQo/dppWjpEvyi+wCeNAB3706M2iSwUJGMWAQsCWyi
YRgAoJKwDRq6esZeMmnFdOAtq2d4kqoP
=6mds
-----END PGP SIGNATURE-----

Responses

pgsql-bugs by date

Next:From: Heikki LinnakangasDate: 2009-04-06 10:36:02
Subject: Re: length() return wrong result
Previous:From: Euler Taveira de OliveiraDate: 2009-04-05 15:01:14
Subject: Re: BUG #4749: trigonometric functions broken

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group