By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,609 Members | 2,246 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,609 IT Pros & Developers. It's quick & easy.

Locale issue with db2

P: n/a
Hi,

I have a locale problem in AIX 5.1
locale LANG=pt_PT
LC_COLLATE="pt_PT"
LC_CTYPE="pt_PT"
LC_MONETARY="pt_PT"
LC_NUMERIC=en_US
LC_TIME=pt_PT
LC_MESSAGES=pt_PT
LC_ALL= db2 "select some_decimal_field from some_table" returned say 51,000. Note that decimal separator is <comma>.
By changing LC_NUMERIC to en_US, I expected the decimal separator to
be <period> which is not what I got.
locale -ck decimal_point

LC_NUMERIC
decimal_point="."

DB2 settings are also correct

Database territory = US
Database code page = 819
Database code set = ISO8859-1
Database country/region code = 1

DB2 Version is 8.1

Where do you think is the problem..? with db2 or locale ? or with OS?
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
I believe the en_US is not supported in AIX5.*, but if you change the
value, LC_NUMERIC=En_US", which may have another code page instead of
819, you should be fine. Try that.
gr*****@chn.cognizant.com (Rajesh Gopinathan) wrote in message news:<88**************************@posting.google. com>...
Hi,

I have a locale problem in AIX 5.1
locale

LANG=pt_PT
LC_COLLATE="pt_PT"
LC_CTYPE="pt_PT"
LC_MONETARY="pt_PT"
LC_NUMERIC=en_US
LC_TIME=pt_PT
LC_MESSAGES=pt_PT
LC_ALL=

db2 "select some_decimal_field from some_table" returned say 51,000. Note that decimal separator is <comma>.


By changing LC_NUMERIC to en_US, I expected the decimal separator to
be <period> which is not what I got.
locale -ck decimal_point

LC_NUMERIC
decimal_point="."

DB2 settings are also correct

Database territory = US
Database code page = 819
Database code set = ISO8859-1
Database country/region code = 1

DB2 Version is 8.1

Where do you think is the problem..? with db2 or locale ? or with OS?

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.