On Monday 03 September 2007 21:31, Ignacio Fernández Galván wrote: > Hi all, > > I have installed Knoda and mysql in a couple of computers and I would like > to use them for a personal database. I have, however, encountered a couple > of problems. > > 1. I have a server running Mandriva 2007.1, which is configured to use the > utf8 encoding. In the my.cnf file I have "default-character-set = utf8" > and if I connect with the mysql client I can see the non-ASCII characters > just fine from the server itself or for another client which is using > latin1. But with Knoda, I cannot see characters from the utf8 server, I > see two boxes instead of non-ASCII characters. I have tried different > options in my.cnf, but none seemed to work. If I connect from the latin1 > client, I could get it to work by adding "character-set-server = latin1". > Is there something I'm missing? Am I doing anything wrong? Is this a bug > in Knoda/hk_classes?
Problems like this exist for me, as well. My system (Ubuntu 6.06 Dapper) is entirely configured as UTF-8_it. If I use special characters in stored data, they'll show as wrong characters in other applications. E.g. if I use an "à" (lowercase "a" with a grave accent on top) in Knoda, and then I browse the database thorough PHPadmin, or connect to it through Openoffice Base, it will show as "Ã" (that is, a uppercase "A" with a curled accent on top). The weird thing is, table names including special characters (tabkes created with knoda) will show the correct special character e.g. in Openoffice. Only the data in the tables will be affected by the problem. Other way around, if I use e.g. Openoffice base for designing forms and input data for my MySQL database, each special character will appear as a couple of rectangles when I browse the database with Knoda. It's frustrating! Actually, I cannot be sure it depends on Knoda. It might also be a problem related with the database "collation2, even if I've made lots of experiment and nothing chenged. Sorry I have really little experience with databases, so I don't know if this report will help. Thanks Paolo > Thanks > Ignacio > > PS. I'm using mysql version 5.0.24a and Knoda/hk_classes version 0.8.3 in > the server. The other client (the latin1 one) has Knoda/hk_classes 0.7.2. > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Splunk Inc. > Still grepping through log files to find problems? Stop. > Now Search log events and configuration files using AJAX and a browser. > Download your FREE copy of Splunk now >> http://get.splunk.com/ > _______________________________________________ > Hk-classes-discuss mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/hk-classes-discuss -- Paolo ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Hk-classes-discuss mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/hk-classes-discuss
