467,880 Members | 1,095 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,880 developers. It's quick & easy.

Locale issue with db2

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
  • viewed: 3967
Share:
1 Reply
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.

Similar topics

2 posts views Thread by sprotty | last post: by
6 posts views Thread by Troels Arvin | last post: by
10 posts views Thread by David Thielen | last post: by
5 posts views Thread by Mike Schilling | last post: by
2 posts views Thread by Daniele C. | last post: by
33 posts views Thread by Simon Brooke | last post: by
reply views Thread by Roman Bertle | last post: by
2 posts views Thread by mpalomas | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.