var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Alter column to VARGRAPHIC ends in SQL0191
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
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.