Re: SQL99 CONVERT() function

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
Cc: zakkr(at)zf(dot)jcu(dot)cz, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: SQL99 CONVERT() function
Date: 2002-08-06 21:18:18
Message-ID: Pine.LNX.4.44.0208062310280.927-100000@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Tatsuo Ishii writes:

> > Sorry, but it seems
> > strange. What 'ISO8859-1' as name?
>
> Sure, you can use '-' instead of '_' if you don't mind quoting it
> with "(i.e. delimited identifier).
>
> convert('PostgreSQL' using "iso8859-1-to-utf8")
>
> I'm sure people don't like that way...

I suggest using the official IANA names and replace all the non-identifier
characters by underscores and all upper-case letters with lower-case.
So it would be iso_8859_1_to_utf_8. That way it's almost as pretty but a
lot more predictable.

--
Peter Eisentraut peter_e(at)gmx(dot)net

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Joe Conway 2002-08-06 21:25:40 Re: FUNC_MAX_ARGS benchmarks
Previous Message Peter Eisentraut 2002-08-06 21:18:06 Re: FUNC_MAX_ARGS benchmarks

Browse pgsql-patches by date

  From Date Subject
Next Message Alvaro Herrera 2002-08-07 00:16:40 CLUSTER patch and regression test
Previous Message Peter Eisentraut 2002-08-06 21:17:06 Re: swedish translation of psql