-----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-----
--
Sent via pgsql-bugs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
