SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Member
    Join Date
    Nov 2009
    Posts
    5
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    DB2: There is no available conversion for the source code page

    I'm usind db2 8. Try to connect to the database (on the remotee computer, using vpn).
    While connecting I have an error:

    SQL0332N There is no available conversion for the source code page "1251" to the target codepage "UNKNOWN". Reason Code "1". SQLSTATE=57017

    I tried to set DISABLEUNICODE=1 in db2cli.ini, and aslo tried to set db2set DB2CODEPAGE=1251. But it did not help.

    What shall I do in order to connect to the database?

  2. #2
    SitePoint Member
    Join Date
    Nov 2009
    Posts
    5
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    The problem is solved.
    As database I wish to connect to is situated in US, I set DB2CODEPAGE=1252,
    where 1252 is value for codepage in US.


Tags for this Thread

Bookmarks

Posting Permissions

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