Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2008
    Posts
    7

    Unanswered: Informix Multilingual Database

    Dear All,
    By any chance someone has a clear configuration on how to create a multilingual database using IDS 11.5FC8 ?

    I've tried to setup a DB_LOCALE = en_US.UTF8 but does not seems to be working.

    Regards,
    Ed

  2. #2
    Join Date
    Apr 2011
    Posts
    5
    Hi,

    What platform are you on, and what errors are you getting?

    We have an 11.50 instance running on Windows with a database using the euro symbol. All that was required at the instance level was to set DB_LOCALE=EN_US.8859-15 before building the database. Depending on how you then access that database DB_LOCALE has to be set accordingly - for JDBC the url looks like this - /<server>:<port>/<database>:informixserver=<instance>;DB_LOCALE=EN_ US.8859-15
    for dbaccess just set DB_LOCALE in the environment

    You can mix as many DB_LOCALES as you want in the one instance, but you'll have to set up a separate environment to access each one.

    HTH

    Phil

  3. #3
    Join Date
    Aug 2008
    Posts
    7
    Hi Phil,
    Thank you for you reply.
    I am setting a version 11.5FC8 on AIX 6.1.
    The problem is to get a database setup in order to atorage any language (e.g arabic, asian languages, as well as european ones).

    Lets suppose the application will be receiveing any kind of language (Internet)
    Some languages need to be stored in a 2/3 bytes like asiasn ones. Therefore, the datatype on the table needs to be defined as nchar or nvarchar to accomodate the values (Multibyte values). I have tried to setup en_us.utf8 and some other possible values for Locale but it keeps saying the value is not appropriate.

    Regards,
    Ed

  4. #4
    Join Date
    Apr 2011
    Posts
    5
    I think you need to look at Global Language Support, which I'm afraid I've not had any experience of (despite working with Informix for over 20 years!). It defintely does cater for multibyte character sets. Try this link - IBM Informix Dynamic Server v11.10 Information Center

  5. #5
    Join Date
    May 2011
    Posts
    1
    Have you set CLIENT_LOCALE = en_us.utf8 in your environment varibales?
    If there is still problem, try to install ILS 3.50.MC5 package first.
    And for supporting more utf-8 characters, set GL_USEGLU=1 too.

    Quote Originally Posted by edagostini View Post
    Hi Phil,
    Thank you for you reply.
    I am setting a version 11.5FC8 on AIX 6.1.
    The problem is to get a database setup in order to atorage any language (e.g arabic, asian languages, as well as european ones).

    Lets suppose the application will be receiveing any kind of language (Internet)
    Some languages need to be stored in a 2/3 bytes like asiasn ones. Therefore, the datatype on the table needs to be defined as nchar or nvarchar to accomodate the values (Multibyte values). I have tried to setup en_us.utf8 and some other possible values for Locale but it keeps saying the value is not appropriate.

    Regards,
    Ed

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •