IDS Forum

Re: Locale setting

Posted By: Gerald Cousins
Date: Wednesday, 21 February 2007, at 1:30 p.m.

In Response To: Re: Locale setting (BALU T)

Prasanna and Marcus, have told you how to get the correct DB_LOCALE value,
and will be of the form ll_tt.codeset.

where codeset is the decimal value of the codeset which can be
looked up in the registry file (see my mail yesterday).

(comment on Marcus's mail)
If you set DB_LOCALE to a different value when entering data, the database
doesn't ignore the value from sysdatabases.

"server uses the value form sysdatabases"

Client will use the value set in environment.

later versions of IDS will throw an error if the value of
DB_LOCALE is not compatible with the "database locale" (less important for
Latin 1 locales)

For setting CLIENT_LOCALE,

On Solaris 9 (locale -a is standard for all *nix platforms that I know)

locale -a | grep ja,
ja #equlivant to ja_jp.ujis
ja_JP.PCK #equlivant to ja_jp.sjis-s
ja_JP.UTF-8 #equlivant to ja_jp.utf8
ja_JP.eucJP #equlivant to ja_jp.ujis

Set LANG to the OS equlivant of CLIENT_LOCALE.
You also must use the correct font in the terminal that you are using
(i.e. one compatible with the value of CLIENT_LOCALE), I use the following
cmd on Linux to use utf8 in an xterm (so check the man pages for the
terminal and xserver, window manager that you are using)
the last 2 elements of the font name relate to code set used by that font
(xfontsel is what I use to see what x fonts are installed.)

xterm \
-fb "-misc-fixed-medium-r-*-*-*-*-*-*-*-*-iso646.1991-*" \
-fi "-misc-fixed-medium-r-*-*-*-*-*-*-*-*-iso646.1991-*" \
-fn "-misc-fixed-medium-r-*-*-*-*-*-*-*-*-iso646.1991-*" \
-fw "-misc-fixed-medium-r-*-*-*-*-*-*-*-*-iso646.1991-*" \
-fwb "-misc-fixed-medium-r-*-*-*-*-*-*-*-*-iso646.1991-*" \
-fx "-misc-fixed-medium-r-*-*-*-*-*-*-*-*-iso646.1991-*"

normally ja_jp.sjis is only used as a DB_LOCALE when some clients set
client_locale to ja_jp.ujis and others to ja_jp.sjis-s
as ja_jp.sjis should provide round trip codeset conversion for both these
locales.

"BALU T" <coolbalaga@rediffmail.com>
Sent by: ids-bounces@iiug.org
02/21/2007 12:52 AM
Please respond to
ids@iiug.org

To
ids@iiug.org
cc

Subject
Re: Locale setting [8458]

Hello,

Thanks for the replies.

My Q was :
How can I know what the locale setting that is being used currently ?

i.e., set the nondefault locale,
<----
For example, to access a database with a Japanese SJIS locale, set both
DB_LOCALE and CLIENT_LOCALE to ja_jp.sjis on the client system
----->

For the above example, how can i know what locale the database is set ?
Is there a command to run and get the details of the locale, and so that I
can
then assign the values to DB_LOCALE and CLIENT_LOCALE.

~ Balu

*******************************************************************************

Forum Note: Use "Reply" to post a response in the discussion forum.

Messages In This Thread

• Locale setting
  BALU T -- Tuesday, 20 February 2007, at 7:43 a.m.
  • RE: Locale setting
    Marcus Haarmann -- Tuesday, 20 February 2007, at 7:58 a.m.
    • RE: Locale setting
      Martin Fuerderer -- Tuesday, 20 February 2007, at 10:14 a.m.
  • Re: Locale setting
    Gerald Cousins -- Tuesday, 20 February 2007, at 2:12 p.m.
  • Re: Locale setting
    BALU T -- Wednesday, 21 February 2007, at 12:52 a.m.
    • Re: Locale setting
      Prasanna A Mathada -- Wednesday, 21 February 2007, at 2:31 a.m.
    • RE: Re: Locale setting
      Marcus Haarmann -- Wednesday, 21 February 2007, at 3:27 a.m.
    • Re: Locale setting
      Gerald Cousins -- Wednesday, 21 February 2007, at 1:30 p.m.
    • Re: Locale setting
      BALU T -- Wednesday, 25 April 2007, at 6:15 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.