Re: NLS Language management for Tables with different NLS LANGS within the same schema.

On Wed, 20 Oct 2004 15:21:22 +0200, max <igse_at_bluewin.ch> wrote:

>How can I set the language per table in a schema of a database.
>
>For instance:
>
>Table : mygermantable is created from somewhere with WE8ISO8859P1
>
> histable is created from somewhere else with EE8MACCES
>
>
>as an exotic example.
>
>
>What do I have to do if i make a
>
>select mytable.x, histable.y ..... from mytable,histable
>
>where blablabla
>
>
>So that everything will display o.k.
>
>Is there a general HOWTO about this problem which comes over me again
>and again ?
>
>I am happy if I get a usefull answer from anyone of you.
>
>Maximilian

There is a convert function to convert between various charactersets. However, you would better create your databases in a generic UTF8 characterset, in order to get rid of the problem completely.

--
Sybrand Bakker, Senior Oracle DBA