[unixODBC-dev] Question about who does the localisation conversions

martin.evans at easysoft.com martin.evans at easysoft.com
Tue Mar 1 21:33:19 GMT 2005


Not that I'm saying this is directly relvelent to your question but...

Be vary wary of localisation settings - they often do not do what you expect.
See 

http://www.easysoft.com/products/9999/faq_answer.phtml?ID=837&product=2002

Martin

Quoting Nick Gorham <nick at lurcher.org>:

> Bill Medland wrote:
> 
> >Can anyone help on this?
> >
> >We have a program running under Wine through unixODBC down into IBM DB2.
> >
> >In order to get Spanish display under Wine we set the LANG to es_ES under 
> >Linux.  (Under Windows we set the regional settings)
> >
> >When we get a decimal number (DECIMAL length 19 scale 3) from the database 
> >under windows through ODBC it comes through with a period as the decimal 
> >point separator.
> >
> >If I use the db2 command itself to query the database, using 
> >LANG=es_ES db2
> >then it displays with a period for the decimal point.
> >
> >If I use isql to query the database, using
> >LANG=es_ES <dbname> <username> <password>
> >then it displays with a comma for the decimal point.
> >
> >Can anyone confirm or deny for me that unixODBC will be doing the conversion
> 
> >from the underlying database type on the basis of the LANG setting?  Or is
> it 
> >likely that it is the actual database drived?
> >  
> >
> 
> unixODBC will try and use iconv if its present to convert to and from 16 
> bit unicode to ascii if needed, but will not do any of the sort of 
> conversions you are talking about.
> 
> I would check if there are any attributes that can be set either via the 
> API or in the ini file for the db2 driver.
> 
> --
> Nick
> 
> _______________________________________________
> unixODBC-dev mailing list
> unixODBC-dev at easysoft.com
> http://mail.easysoft.com/mailman/listinfo/unixodbc-dev
> 
> 
> 






More information about the unixODBC-dev mailing list