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

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.