| From: | Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp> |
|---|---|
| To: | zakkr(at)zf(dot)jcu(dot)cz |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: SQL99 CONVERT() function |
| Date: | 2002-08-06 08:19:50 |
| Message-ID: | 20020806.171950.68052926.t-ishii@sra.co.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
> On Tue, Aug 06, 2002 at 02:55:04PM +0900, Tatsuo Ishii wrote:
> > I have added SQL99's CONVERT() function. docs and regression tests
> > also updated. Our own convert() functions can also be used. Example
> > usage of CONVERT():
> >
> > convert('PostgreSQL' using iso8859_1_to_utf8)
> ^^^^^
> What is it? Is it really in standard?
It's a "conversion name".
>From SQL99:
CONVERT <left paren> <character value expression>
USING <form-of-use conversion name> <right paren>
> 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...
--
Tatsuo Ishii
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Karel Zak | 2002-08-06 08:49:59 | Re: SQL99 CONVERT() function |
| Previous Message | Christopher Kings-Lynne | 2002-08-06 08:10:20 | Re: [Fwd: Who here is an AUUG member? (Australian Unix Users Group)] |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Karel Zak | 2002-08-06 08:49:59 | Re: SQL99 CONVERT() function |
| Previous Message | Dennis Bjorklund | 2002-08-06 08:14:50 | swedish translation of psql |