Hi All,



One of my programmers just showed me this. It appears genxml does not
recognise the unicode types and prepares them as 'UNKNOWN'.



Do as follows:



1. createdb -i bowtest



2. sql bowtest << SQL_END

create table fubar (foo nchar(20),garp nvarchar(50),parp long
nvarchar);\p\g

commit;\g

\q

SQL_END



3. genxml -metadata_only -xmlfile=fubar.xml bowtest fubar



4. egrep "column_name|column_type" fubar.xml

If the problem exists you'll see them described as type
UNKNOWN.



5. destroydb bowtest

rm -f fubar.xml



We've found that this is pretty wide spread.



Martin Bowes



PS. Mike Leo...if you have a bad back, have you been doing your
deadlifts?