Re: Oracle encoding query

On Wed, Dec 06, 2017 at 04:53:36PM +0100, H.Merijn Brand wrote:
> On Wed, 6 Dec 2017 15:34:17 +0000, Tim Bunce <[email protected]>
> wrote:
> 
> > A view might be useful. Or perhaps define your own function to wrap the expression.
> 
> That worked very well!
> 
> CREATE OR REPLACE FUNCTION diac_u (v VARCHAR2) RETURN NCHAR IS
>     BEGIN
>     RETURN utl_i18n.raw_to_nchar (utl_i18n.string_to_raw (v), 'utf8');
>     END;
> /
> 
> select diac_u (land_u) from land where c_land = 7072;

You might want to add DETERMINISTIC before the IS so the function can be
used more efficiently in some cases.

Tim.