Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2013

    Unanswered: fetching multilanguage data by stored procedure

    Can we fetch the the data of chinese or some other language using stored procedure in db2??? please help me out

  2. #2
    Join Date
    Apr 2006
    Provided Answers: 11
    why would this be language dependent ? as long as all is configured correctly..
    what is the real problem ? db2level /platform ?
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5-V11 Fundamentals- DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified

  3. #3
    Join Date
    Sep 2013
    I just want to write a store procedure which will retunr the chinese data from the database is made in UTF-8 code set,so can you please suggest me the syntax for the stored procedure and where should i declare the unicode thing to fetch the multi language data.????

  4. #4
    Join Date
    Apr 2012
    Provided Answers: 27
    Study the documentation.
    No special syntax is necessary.
    You need to understand the concept of an "application code page".
    When the client application (which performs the 'connect') has the same code page as the database, then no character set conversion happens to result-sets returned from stored procedures or queries.
    So *if* the application is designed and coded properly for variable-length encodings (like utf-8) then you will have no issues.

  5. #5
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    Quote Originally Posted by kiara jeckson View Post
    Can we fetch the the data of chinese or some other language using stored procedure in db2??? please help me out
    It would help a lot if you could let use know what version (and fixpack) of DB2 you are using to run the stored procedure. There are several different products called DB2, and they behave differently under certain circumstances.

    In general, if your database is using UTF-8, then as long as all of the code that handles the character data between the database and the display is "UTF aware", then that character data ought to arrive intact. If you can post the code that is failing, then we might see something that would let us help you.

    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

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