Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Location
    Egypt
    Posts
    61

    Unanswered: data codepage stored by web applications

    Hi,

    i have DB2 8.1.5 running under AIX 5.1.5 with utf-8 codepage collating using system

    as far as i know, the DB engine should store the data according to UTF-8 codepage, but using ASP web application with windows-1256 codepage, data is stored into tables using 1256 codepage !

    on the other hand, trying to read same data using PHP web application using unixODBC DSN, it fails to read 1256 codepage from DataBase

    is there any parameter to set in db2 / CLI configuration file that handle this ?
    or
    is there any parameter in ODBC DSN related to codepage ?

    thnaks
    hany heggy,
    IBM certified Professional, AIX system support
    www.melodyhits.tv

  2. #2
    Join Date
    Jan 2005
    Posts
    191
    1) how do you know that the data is being stored using codepage 1256 - have you, for example, used HEX(colname) to verify?
    2) is it being stored in a CHAR FOR BIT DATA column? (yes, I know this is unlikely)
    3) run an application snapshot. confirm that the server thinks the application has a codepage of 1256 (codepage_id). Use GET DB CFG to confirm that the server has codepage 1208.
    4) what error do you get from unixODBC? (don't know this product)

    James Campbell

Posting Permissions

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