Re: Proposal: CREATE CONVERSION

> Tatsuo Ishii writes:
> 
> > > Also, is there anything in SQL99 that we ought to try to be
> > > compatible with?
> >
> > As far as I know there's no such an equivalent in SQL99.
> 
> Sure:
> 
>          11.34  <translation definition>

I guess you mix up SQL99's "trasnlate" and "convert".

As far as I know, SQL99's "translation" is exactly a translation. e.g.
       rr) translation: A method of translating characters in one character           repertoire into characters of the
sameor a different character           repertoire.
 

For example, certain "translation" might take an input of Engish text,
and makes an output of Japanese one (I don't know if we could
implement such a translation though :-).

On the other hand "convert" just changes the "form-of-use" (SQL's
term, actually equivalent to "encoding"), keeping the character
repertoire.
--
Tatsuo Ishii