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