Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2008
    Posts
    3

    Unanswered: Unicode use in informix

    I am new to using unicode/multi-language in informix. I cant store and retieve unicode to database. What i see just "??????"...

    I have set my client's and db server as below in order to support unicode:

    Client's setnet:-
    CLIENT_LOCALE=en_US.UTF8
    DB_LOCALE=en_US.UTF8

    DB Server's setnet:-
    CLIENT_LOCALE=en_US.UTF8
    DB_LOCALE=en_US.UTF8

    ODBC:-
    Client locale: de_DE.819
    Database locale: de_DE.819
    Use Server database locale: checked


    And I amm using IBM Informix ODBC driver 3.00 TC1

    Any idea? Please help

  2. #2
    Join Date
    Apr 2007
    Location
    Jundiai / SP - Brasil
    Posts
    311
    I don't remember the details.. but..
    Database locale never change... so, your ODBC database locale must be en_US.UTF8

    And need exists a conversion code-set file to this work. To check this you need look in the $INFORMIXDIR/gls/cv* directory . Look for *.cv files.
    Will need to exists the conversion from en_US.UTF8 to de_DE.819 and vice-versa .

    Looking for this conversion code-set on the IDS 11.50 UC1DE , I found the file e01c0333.cvo and 0333e01c.cvo , they are the respective conversion..

    Read the GLS User Manual...
    ________________________________________
    César Inacio Martins
    Jundiai / SP - Brasil
    http://www.imartins.com.br/informix - em Português
    http://www.imartins.com.br/informix - English (translated by Google).
    ________________________________________

Posting Permissions

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