- - wrote:
> 1) Functions like char_length() or length() do NOT return the number
> of characters (the manual says they do), instead they return the
> number of code points.
I think you have client_encoding misconfigured.
alvherre=# select length('á'::text);
length
--------
1
(1 fila)
alvherre=# select pg_column_size('á');
pg_column_size
----------------
3
(1 fila)
(there's one byte of overhead here, so á is two bytes)
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.