Re: [Sqlalchemy-tickets] [sqlalchemy] #1953: cx_oracle dialect depends on NLS_LANG setting

[sqlalchemy <mi...@zz...>]

#1953: cx_oracle dialect depends on NLS_LANG setting
--------------------+-------------------------------------------------------
 Reporter:  guest   |          Owner:  zzzeek                  
     Type:  defect  |         Status:  new                     
 Priority:  medium  |      Milestone:  0.6.6                   
Component:  oracle  |       Severity:  major - 1-3 hours       
 Keywords:          |   Status_field:  needs questions answered
--------------------+-------------------------------------------------------
Changes (by zzzeek):

  * status_field:  awaiting triage => needs questions answered
  * severity:  no triage selected yet => major - 1-3 hours
  * milestone:  => 0.6.6


Comment:

 There is a workaround for this, but may I suggest that the GERMAN setting
 on NLS_LANG is going to cause more problems than that.   Decimal binds
 will not work either, and that is a cx_oracle issue:

 {{{
 #!python
 import os
 import cx_Oracle
 import decimal

 os.environ["NLS_LANG"] = "GERMAN"

 dsn = cx_Oracle.makedsn('localhost', '1521', 'xe')
 conn = cx_Oracle.connect('scott', 'tiger', dsn)
 cursor = conn.cursor()
 cursor.execute("select :foo from dual", foo=decimal.Decimal("56.5"))
 print cursor.fetchall()
 }}}

 for the above, we could add more handlers to accommodate but this will add
 latency to all queries.   I'd ask why you can't at least set NLS_LANG to
 "GERMAN_AMERICA", because for SQLA to work around this is not going to be
 pretty.

-- 
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/1953#comment:1>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python