Re: Django 1.2.3, Oracle with Character Set WE8MSWIN1252 - 'utf8' codec can't decode bytes

On Thu, Dec 2, 2010 at 5:52 PM, Anurag Chourasia wrote: > Hi Ian, > Can't tell you how much this helps :-) > Setting the variable using ctypes before the import of cx_Oracle does the > trick for me. > Appreciate the time you spent in helping resolve this. > Is there

Re: Django 1.2.3, Oracle with Character Set WE8MSWIN1252 - 'utf8' codec can't decode bytes

Hi Ian, Can't tell you how much this helps :-) Setting the variable using ctypes before the import of cx_Oracle does the trick for me. Appreciate the time you spent in helping resolve this. Is there any Cygwin specific doc where we could include this? Regards, Anurag On Fri, Dec 3, 2010 at

Re: Django 1.2.3, Oracle with Character Set WE8MSWIN1252 - 'utf8' codec can't decode bytes

On Thu, Dec 2, 2010 at 5:34 PM, Anurag Chourasia wrote: > Hi Ian, > I just tried the ctypes solution that you mentioned in your previous email > but it does not work for me. In your transcript, it appears that Django has already been loaded when you call the ctypes

Re: Django 1.2.3, Oracle with Character Set WE8MSWIN1252 - 'utf8' codec can't decode bytes

Hi Ian, I just tried the ctypes solution that you mentioned in your previous email but it does not work for me. Below is my session transcripts. >>> import ctypes *>>> ctypes.CDLL('kernel32').SetEnvironmentVariableA('NLS_LANG', '.UTF8')* *1* >>> TerminologyMap.objects.get(term_id=8) Traceback

Re: Django 1.2.3, Oracle with Character Set WE8MSWIN1252 - 'utf8' codec can't decode bytes

On Thu, Dec 2, 2010 at 3:23 PM, Ian Kelly wrote: > Weird.  From what I can tell, this seems to have something to do with > Cygwin, or at least I'm able to replicate it in that environment. > Setting NLS_LANG in or out of process and changing the registry key > all have no

Re: Django 1.2.3, Oracle with Character Set WE8MSWIN1252 - 'utf8' codec can't decode bytes

On Thu, Dec 2, 2010 at 1:21 PM, Anurag Chourasia wrote: > Hi Ian, > Here is the information requested by you. > $ python > Python 2.5.2 (r252:60911, Dec  2 2008, 09:26:14) > [GCC 3.4.4 (cygming special, gdc 0.12, using dmd 0.125)] on cygwin > Type "help", "copyright",

Re: Django 1.2.3, Oracle with Character Set WE8MSWIN1252 - 'utf8' codec can't decode bytes

Hi Ian, Here is the information requested by you. $ python Python 2.5.2 (r252:60911, Dec 2 2008, 09:26:14) [GCC 3.4.4 (cygming special, gdc 0.12, using dmd 0.125)] on cygwin Type "help", "copyright", "credits" or "license" for more information. >>> import os >>> print os.environ['NLS_LANG']

Re: Django 1.2.3, Oracle with Character Set WE8MSWIN1252 - 'utf8' codec can't decode bytes

On Thu, Dec 2, 2010 at 6:43 AM, Anurag Chourasia wrote: > Hi Ian, > Yes.I set the NLS_LANG in my shell to UTF8 before trying this. > Query using Django model still fails (direct query using cx_Oracle works > fine) > Regards, > Anurag Okay, so it would appear that

Re: Django 1.2.3, Oracle with Character Set WE8MSWIN1252 - 'utf8' codec can't decode bytes

Hi Ian, Yes.I set the NLS_LANG in my shell to UTF8 before trying this. Query using Django model still fails (direct query using cx_Oracle works fine) Regards, Anurag On Thu, Dec 2, 2010 at 1:20 PM, Ian Kelly wrote: > On Wed, Dec 1, 2010 at 7:58 PM, Anurag Chourasia

Re: Django 1.2.3, Oracle with Character Set WE8MSWIN1252 - 'utf8' codec can't decode bytes

On Wed, Dec 1, 2010 at 7:58 PM, Anurag Chourasia wrote: > This is using cx_Oracle and it works fine > === cx_Oracle.version > '5.0.3' cursor.execute("select to_term from terminology_map where id=316") cursor.fetchone()[0] >

Re: Django 1.2.3, Oracle with Character Set WE8MSWIN1252 - 'utf8' codec can't decode bytes

Hi Ian, Thanks for the response. With cx_Oracle(version 5.0.3), the retrieval of that field value works fine as in my original email. It's only when i directly use the Django models way of accessing that it fails. Below two examples will make it more clear. This is using Django models and it

Re: Django 1.2.3, Oracle with Character Set WE8MSWIN1252 - 'utf8' codec can't decode bytes

On Nov 30, 8:31 pm, Anurag Chourasia wrote: > On Oracle 10.2 with Character-Set set to WE8MSWIN1252, > > When using Django, I try to select a Oracle row which contains a field with > value as 'Páginas', i encounter the following error "'utf8' codec can't > decode bytes

Django 1.2.3, Oracle with Character Set WE8MSWIN1252 - 'utf8' codec can't decode bytes

Hi All, On Oracle 10.2 with Character-Set set to WE8MSWIN1252, When using Django, I try to select a Oracle row which contains a field with value as 'Páginas', i encounter the following error "'utf8' codec can't decode bytes " Here is the trace from the python command prompt. >>> tmlist =