I'm using MySQL administrator and Toad for Mysql; both are giving the same problem. I'm pretty sure that this is not a viewing problem. I did a trial to update the table (doFields) with utf-8 text using an update statement. Surprisingly, the text is saved and viewed correctly!. I guess the problem is somehow related the database connector that Fedora uses.
Thank you and best regards, Mohammed Abo Ouda -----Original Message----- From: Peter Cliff [mailto:[email protected]] Sent: Wednesday, July 14, 2010 4:39 PM To: Dar Cc: [email protected] Subject: Re: [Fedora-commons-users] Problem while ingesting UTF-8 Foxml Hello! You don't say what you are using to view the Fedora DB, but this sounds like it may be a problem with viewing the contents of the database rather than what is in it. If, for example, you were exploring the DB via phpmyadmin, you'd need to unsure your browser has the correct character encoding selected (UTF8 in this case). Dunno if that helps? Pete On 14 Jul 2010, at 14:00, Dar wrote: > Dear All, > > I’m trying to add a Foxml contains “UTF-8” characters (Arabic characters). > the object is ingested correctly into Fedora. > > My issue is; when I explore the Fedora DB (which is MySQL in my case) the > doFields table (which holds the DC fields) I found that all fields data are > encoded incorrectly (question marks instead of the original Arabic text) > although I set the table DEFAULT CHARACTER SET to utf8, DEFAULT COLLATE to > utf8_general_ci and the db connection string in fedora.fcfg sets the > characterEncoding=utf8 > > Could you please help ? > > > Thank you and best regards, > > Mohammed Abo Ouda > Bibliotheca Alexandrina > > > > ------------------------------------------------------------------------------ > This SF.net email is sponsored by Sprint > What will you do first with EVO, the first 4G phone? > Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first<Mail > Attachment.txt> ------------------------------------------------------------------------------ This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first _______________________________________________ Fedora-commons-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/fedora-commons-users
