Non ascii characters in metadata

[Aldo Caruso-2]

Hi,

   I'm using flamerobin 0.9.0 in Ubuntu Hardy.
   I can't read neither comments nor descriptions if they have non ASCII
charactes ( accents, and so on ).
   Moreover, if a stored procedure or trigger has in its code comments
which contains those kind of characters, all the stored procedure body
is read empty.

Thanks for any help,

Aldo Caruso

------------------------------------------------------------------------------
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com
_______________________________________________
Flamerobin-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/flamerobin-devel

[Michael Hieke]

Hi,

On 08.04.2009 16:52 Aldo Caruso wrote:

> I can't read neither comments nor descriptions if they have non ASCII
> charactes ( accents, and so on ).
> Moreover, if a stored procedure or trigger has in its code comments
> which contains those kind of characters, all the stored procedure body
> is read empty.

what default character set has the database, and what connection charset
do you use?  Which tool was used to create the database?  What Firebird
version do you use now, and which version was used to create the database?

Do you have the same problems when editing the comments or descriptions
from FlameRobin?

Thanks

--
Michael Hieke


------------------------------------------------------------------------------
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com
_______________________________________________
Flamerobin-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/flamerobin-devel

[Aldo Caruso-2]

Michael,

The default character set is ISO8859_1 and is the same I use to connect to.
I used IBExpert to create the database.
I'm using Firebird 2.0 and it was used version 1.5 when it was created.
I don't have the same problem when I edit the comments from flamerobin and read it with flame robin, but when that comment ( written by FlameRobin ) is read by IBExpert, the non ascii characters are changed ( garbage  )

Thanks,
Aldo

Michael Hieke escribió:

Hi,

On 08.04.2009 16:52 Aldo Caruso wrote:

  

I can't read neither comments nor descriptions if they have non ASCII
charactes ( accents, and so on ).
Moreover, if a stored procedure or trigger has in its code comments 
which contains those kind of characters, all the stored procedure body 
is read empty.
    

what default character set has the database, and what connection charset 
do you use?  Which tool was used to create the database?  What Firebird 
version do you use now, and which version was used to create the database?

Do you have the same problems when editing the comments or descriptions 
from FlameRobin?

Thanks

  

------------------------------------------------------------------------------
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com
_______________________________________________
Flamerobin-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/flamerobin-devel

[Michael Hieke]

Aldo,

On 08.04.2009 20:45 Aldo Caruso wrote:

> The default character set is ISO8859_1 and is the same I use to
> connect to.
> I used IBExpert to create the database.
> I'm using Firebird 2.0 and it was used version 1.5 when it was
> created. I don't have the same problem when I edit the comments from
> flamerobin and read it with flame robin, but when that comment (
> written by FlameRobin ) is read by IBExpert, the non ascii characters
> are changed ( garbage )

FlameRobin 0.9.0 has bugs with non-ASCII characters in identifier names,
comments and other metadata string values, which show when the system
character set is different from the connection charset.

You could try using UTF-8 as the connection charset, but even then you
probably won't be able to edit comments and the like with FlameRobin on
Ubuntu and IBExpert on Windows without some things breaking.

Unfortunately there's not much you can do, short of updating to a
version of Ubuntu which uses a more recent FlameRobin version (compiled
from SVN trunk), or recompiling FlameRobin for yourself.  Or maybe there
is a newer FlameRobin version in some third-party package repository.

Sorry...

--
Michael Hieke


------------------------------------------------------------------------------
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com
_______________________________________________
Flamerobin-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/flamerobin-devel

[Damyan Ivanov-5]

-=| Michael Hieke, Wed, Apr 08, 2009 at 09:40:04PM +0200 |=-

> FlameRobin 0.9.0 has bugs with non-ASCII characters in identifier
> names, comments and other metadata string values, which show when
> the system character set is different from the connection charset.
>
> ...
>
> Unfortunately there's not much you can do, short of updating to a
> version of Ubuntu which uses a more recent FlameRobin version (compiled
> from SVN trunk), or recompiling FlameRobin for yourself.  Or maybe there
> is a newer FlameRobin version in some third-party package repository.

Alternatively, if you can point me to the revisions that fix the
problem in trunk, I could patch the 0.9.0 Debian package with them and
then Aldo should be able to use it.

--
dam            JabberID: [hidden email]

------------------------------------------------------------------------------
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com
_______________________________________________
Flamerobin-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/flamerobin-devel

[Damyan Ivanov-5]

-=| Damyan Ivanov, Thu, Apr 09, 2009 at 07:48:29AM +0300 |=-

> -=| Michael Hieke, Wed, Apr 08, 2009 at 09:40:04PM +0200 |=-
> > Unfortunately there's not much you can do, short of updating to
> > a version of Ubuntu which uses a more recent FlameRobin version
> > (compiled from SVN trunk), or recompiling FlameRobin for yourself.  
> > Or maybe there is a newer FlameRobin version in some third-party
> > package repository.
>
> Alternatively, if you can point me to the revisions that fix the
> problem in trunk, I could patch the 0.9.0 Debian package with them and
> then Aldo should be able to use it.

Or simply release trunk as 0.9.1 :)

--
dam            JabberID: [hidden email]

------------------------------------------------------------------------------
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com
_______________________________________________
Flamerobin-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/flamerobin-devel

[Michael Hieke]

Hi,

Damyan Ivanov wrote:

>> Alternatively, if you can point me to the revisions that fix the
>> problem in trunk, I could patch the 0.9.0 Debian package with them
>> and then Aldo should be able to use it.

these are probably too numerous, as a character set conversion object
had to be introduced in all places where string metadata is read from
the database.  Much easier to go with the trunk version in the first
place, as it has many more bug fixes and improvements.

> Or simply release trunk as 0.9.1 :)

That would be released as 0.9.2 then.  Milan, what do you think?

Thanks

--
Michael Hieke


------------------------------------------------------------------------------
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com
_______________________________________________
Flamerobin-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/flamerobin-devel

[Milan Babuskov-4]

On Thu, Apr 9, 2009 at 8:58 AM, Michael Hieke <[hidden email]> wrote:
> That would be released as 0.9.2 then.  Milan, what do you think?

Fine with me.

If everyone else agrees, I could prepare the changelog and packages later today.

--
Milan Babuskov
http://www.flamerobin.org

------------------------------------------------------------------------------
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com
_______________________________________________
Flamerobin-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/flamerobin-devel