Re: Charset/collate support and function parameters

On Sun, 31 Oct 2004, Tatsuo Ishii wrote:

> > and now we could add functions that work with this charset
> >
> > CREATE FUNCTION bar (x VARCHAR(255) CHARACTER SET foo) ....
> >
> > What we are saying is that we don't want to be able to do this?
>
> Not sure we want to add above. Is it something defined in the
> standard?

The syntax in sql2003 do allow it. The exact semantics is difficult to
get a clear picture of from the spec (as always).

I thought this question was the whole argument. We can't have something
like the above with the pg overloading since then the resolving process
will be too hard according to Tom.

> 2) make shared tables such as pg_database and pg_shadow can handle
> multiple charsets. this is necessary because database names and
> user names could be repsented in different charsets

Shouldn't we just define the charset for user names and database names?
Either one fixed or one that's set during initdb. You don't mean that we
want different user numes to be defined using different charsets?

The rest of the points looks good to me. The main problem is still what to
do with the function definitions as above. Is it something we want or not?

Is the charset something that makes two text types different or not?

--
/Dennis Björklund