Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2010
    Location
    The Netherlands
    Posts
    20

    Unanswered: Alter column to VARGRAPHIC ends in SQL0191

    Hi,

    I want to alter VARCHAR columns to VARGRAPHIC, to support multibyte characters.
    (If I define a column as 20, I don't meen 20 bytes but 20 characters. That's why I want to use the VARGRAPHIC).

    On certain tables/columns the alter runs without any problem.
    But with one table/column I get an SQL0901 error.

    I use the command ALTER TABLE <table> ALTER COLUMN <column> SET DATATYPE VARGRAPHIC(<length>)

    The SQL0191 explains there's an improperly formed multi-byte character.

    How can I find what character/row causes the problem?

    Thanks, Tinie Sluijter

  2. #2
    Join Date
    Nov 2010
    Location
    The Netherlands
    Posts
    20

    Thumbs up Found the solution

    Found the solution myself.

    When using the statement
    select id, vargraphic(<column>) from <table> order by id" > vargraphic.txt
    the select stops if the vargraphic stops at an error.

    At that point you know where to search in the table, and solve the problem.

Posting Permissions

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