Re: viewing characters in character sets

[Peter Gulutzan]

No plan.

You could write a stored procedure. It would look vaguely like this for latin1:

create procedure pf () begin declare v int default 0; declare continue handler for sqlexception begin end; create table t (s1 char(1) character set latin1); while v <= 255 do set @v = concat('insert into t values (0x',hex(v),')'); prepare stmt1 from @v; execute stmt1; set v = v + 1; end while; select * from t where s1<>''; end//

If you are the same person as the 'antoun' who writes such helpful comments in fr.comp.applications.sgbd, then you will have no trouble writing a good procedure.

Peter Gulutzan
MySQL AB