RE: Column width different in view

From: Mark W. Farnham <mwf_at_rsiz.com>
Date: Mon, 18 Jul 2011 15:12:17 -0400
Message-ID: <01d001cc457e$9ce8f390$d6badab0$_at_rsiz.com>

One last thing: If indeed the "problem" database has a different character set, then matching character sets in your client prior to that connection should also work as a solution. That is not always convenient in a script set though.  

It is possible that the "problem" database being a different character set is masking extra overhead all the time and if setting the client NLS parms to match the database it will be connecting to is not too much trouble in the context of your applications, that is generally a better solution. This of course won't magically allow you to store multibyte character sets in single bytes, but it will avoid the conversion overhead when you're really only using ASCII anyway.  

mwf  

From: Dennis Williams [mailto:oracledba.williams_at_gmail.com] Sent: Monday, July 18, 2011 10:36 AM
To: Mark W. Farnham
Cc: Mark.Bobak_at_proquest.com; oracle-l_at_freelists.org Subject: Re: Column width different in view  

Thanks everyone. Wow, I never would have guessed this one. Amazing resources on this list.

<snip>

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Bobak, Mark
Sent: Friday, July 15, 2011 6:09 PM
To: Dennis Williams; oracle-l_at_freelists.org Subject: Re: Column width different in view

What is nls length semantics set to? What is character set?

<snip>

List,

We have a situation where a view is created on a table. The underlying column is defined as CHAR(18). We are doing this to a number of Oracle 10.2.0.4 databases. On all of them the view creates just fine. But on one database the column in the view is created as CHAR(54). Has anyone encountered anything like this?

Thank you,

Dennis Williams  

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jul 18 2011 - 14:12:17 CDT