Anderson,

Take a look: http://www.firebase.com.br/fb/artigo.php?id=1892

Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br

AF> Hi all,


AF> I have this FB1.5 database which I'm trying to move to FB2.1. The database
AF> has default characater set ISO8859_1 to be able to use portuguese language
AF> (accents and so on).

AF> I've done a backup of it using FB1.5 and restored using FB2.1, that was all.
AF> Since then we've started testing our system againt this Fb2.1 database. So
AF> far so good.

AF> But when trying to edit one of our SPs we just found no tool (IBExpert,
AF> Flamerobin) could get the SP text -- with a Firebird error complaning about
AF> "cound no transtate character set";

AF> This procedure has some comments in portuguese (using accents) and that's
AF> where I think the problem is. Other procs without comments (having accents)
AF> have no problem at all.

AF> I was able to get proc text only using ISQL.

AF> So, my question is, can't I have accents inside SPs on FB2.1 or it just
AF> won't work since the DB came from FB 1.5? The correct way to work this out
AF> is re-creating these procedures on FB2.1??


AF> Regrads,
AF> Anderson Farias



AF> ------------------------------------

AF> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

AF> Visit http://www.firebirdsql.org and click the Resources item
AF> on the main (top) menu. Try Knowledgebase and FAQ links !

AF> Also search the knowledgebases at http://www.ibphoenix.com

AF> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
AF> Yahoo! Groups Links