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

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

Django sets it to ".UTF8".

On 22 בינואר 2015 12:46:07 GMT+02:00, Vladimir Ryabtsev <gre...@gm...> wrote:
>Dayton,
>what is the value of NLS_LANG on client machine?
>What is returned by 'SELECT USERENV ('language') FROM DUAL' when
>calling
>from django?
>
>2015-01-21 21:37 GMT+03:00 Dayton Gomez <Day...@sy...>:
>
>> I grabbed the ful query, plus the bound variables. I get this for
>bound
>> vars:
>>
>> DATATYPE_STRING   VALUE_STRING
>> ---------------------------    ----------------------
>> NVARCHAR2(32)        ios
>>
>> It seems right. The only thing I notice is that the table definition
>is
>> for NVARCHAR2(20).
>>
>> From: Vladimir Ryabtsev <gre...@gm...>
>> Reply-To: "cx-...@li..." <
>> cx-...@li...>
>> Date: Tuesday, January 20, 2015 2:42 PM
>> To: "cx-...@li..." <
>> cx-...@li...>
>> Subject: Re: [cx-oracle-users] Python 2: unicode vs str param causing
>> slowness
>>
>> Hi,
>> Did you try to look the text of actual query that being executed when
>you
>> come across the slowness?
>> Something like this:
>>
>http://stackoverflow.com/questions/55899/how-to-see-the-actual-oracle-sql-statement-that-is-being-executed
>> You can also find out the datatype of your bound variable :platform
>as
>> mentioned here:
>>
>http://stackoverflow.com/questions/1707291/how-to-get-the-last-executed-sql-statement-and-bind-variable-values-in-oracle
>> This will you give a clue about implicit datatype conversion.
>> I don't think it's a django thing.
>>
>>
>>
>>
>------------------------------------------------------------------------------
>> New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
>> GigeNET is offering a free month of service with a new server in
>Ashburn.
>> Choose from 2 high performing configs, both with 100TB of bandwidth.
>> Higher redundancy.Lower latency.Increased capacity.Completely
>compliant.
>> http://p.sf.net/sfu/gigenet
>> _______________________________________________
>> cx-oracle-users mailing list
>> cx-...@li...
>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>>
>>
>
>
>------------------------------------------------------------------------
>
>------------------------------------------------------------------------------
>New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
>GigeNET is offering a free month of service with a new server in
>Ashburn.
>Choose from 2 high performing configs, both with 100TB of bandwidth.
>Higher redundancy.Lower latency.Increased capacity.Completely
>compliant.
>http://p.sf.net/sfu/gigenet
>
>------------------------------------------------------------------------
>
>_______________________________________________
>cx-oracle-users mailing list
>cx-...@li...
>https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.