Re: [cx-oracle-users] Python 2: unicode vs str param causing slowness

[Shai B. <sh...@pl...>]

Hi Dayton,

On Tuesday 20 January 2015 17:55:46 Dayton Gomez wrote:
> Another interesting fact is that the slowness happens on 11g, but not
> oracle 12c. 12c seems to operate just fine with either. Both have:
> NLS_CHARACTERSET        WE8MSWIN1252
> NLS_NCHAR_CHARACTERSET        AL16UTF16
> 
The Django documentation says that Django assumes a server encoding of UTF8; 
your use of UTF16 could create problems with values Django will think are fine 
but your server will think are too long.

Django also uses utf8 as the client-side encoding -- and that may (or may not) 
be related to the performance problem.

I recommend that, if this makes sense businesswise, you try to use a utf8 
encoding such as AL32UTF8.

HTH,
	Shai.