RE: finding non ascii characters in the database

Yea Gumby, thanks for the condolences. It'll take us ~5 years to fully be off of Informix, so I have a while to grow to .. er.. love..cough, oracle. It seems that with our en_US.819 character set, multibyte characters get stored as single byte. IOW a 25 char name that has some multibyte characters in it, stores well in a char(25) field. But when we bring that data over with our oracle ODI etl process ( basically select table to table ), it won't fit in a char(25) field on oracle, because of the multi-byte characters. I'll check out the isalpha and isalnum. thanks, floyd ----- Original Message ----- From: "Ian Michael Gumby" >;im_gumby@hotmail.com