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

From: max <igse_at_bluewin.ch>
Date: Thu, 21 Oct 2004 08:40:42 +0200
Message-ID: <417759c8$1_3@news.bluewin.ch>

The problem is that the table histable comes from somewhere else and is imported via odbc

In particular my case I import the Table from a sh...y ms-sqlserver table.

Sybrand Bakker wrote:

> 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

Received on Thu Oct 21 2004 - 01:40:42 CDT