Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2014
    Posts
    1

    Exclamation Unanswered: How to Support Multibyte characters without increasing the Column size

    I believe that any multibyte character like entrée requires an extra byte in the Column space.

    Is there any alternative to support/store the Multibyte characters in a Column in DB2?

    An alternative could be to use the Vargraphic? Any impact of using the Vargraphic and any other alternatives?

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    If you choose an 8 bit character set that includes the glyph for all of the characters from the multibyte character set, you can store each of the characters using only a single byte of storage.

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

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by SatishPala View Post

    An alternative could be to use the Vargraphic? Any impact of using the Vargraphic and any other alternatives?
    And how many bytes do you think are used to store one graphic character?

    Your question basically amounts to "how do I store two bytes in one-byte column".
    ---
    "It does not work" is not a valid problem statement.

Tags for this Thread

Posting Permissions

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