Hi Folks,

I'm in the process of migrating my database to character set win1252.

To do this, I've extracted the metadata using isql.

Added a default character set to the create statement.

Added set names win1252 to the script.

Everything runs fine.

However, when I try to extract the metadata of a couple of stored procedures using ibexpert or database workbench, I get the dreaded "cannot transliterate between character sets error".

The two procedures include strings embedded in them such as
' !"£$%^&*()_-+={}[]:;@''~#|\/?><.,'

So my question is, should I use set name in the database connection script? or do I need to declare my stored procedures differently?

Regards
Ian