Re: Python 2: unicode vs str param causing slowness
Shai Berger <shai-9mtU2oJkgntWk0Htik3J/[email protected]> Thu, 22 Jan 2015 13:03:14 +0200
| Newsgroups | gmane.comp.python.db.cx-oracle |
|---|---|
| Message-ID | <[email protected]> |
Django sets it to ".UTF8". On 22 בינואר 2015 12:46:07 GMT+02:00, Vladimir Ryabtsev <[email protected]> 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 <[email protected]>: > >> 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 <[email protected]> >> Reply-To: "[email protected]" < >> [email protected]> >> Date: Tuesday, January 20, 2015 2:42 PM >> To: "[email protected]" < >> [email protected]> >> 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 >> [email protected] >> 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 >[email protected] >https://lists.sourceforge.net/lists/listinfo/cx-oracle-users -- Sent from my Android device with K-9 Mail. Please excuse my brevity. ------------------------------------------------------------------------------ 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-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org https://lists.sourceforge.net/lists/listinfo/cx-oracle-users