I can confirm the same behavior on a default installation, when inserting Romanian characters, with [mysqld] default-character-set=utf8 in my.cnf. On mysql shell data looks ok with default latin1 encoding, but when changing it to utf8 special characters looks garbled (like accessing http://www.google.ro/webhp?hl=ro with ISO-8859-1 encoding).
On Thu, 2010-03-11 at 22:16 -0800, __bliss wrote: > > > Massimiliano Pala-2 wrote: > > > > Can you check if the data in the DB is correctly stored as UTF-8 ? > > Just using the mysql shell should work... > > > > Let me know, > > Max > > > > > > On 03/10/2010 04:55 PM, __bliss wrote: > > [...] > >> One final note, Massimiliano. The codepage problem is nothing new to > >> russian-speaking users. Say, Catalyst framework (perl, too) wants to be > >> explicitly pointed to get database fields in utf8. Maybe, > >> encode_utf8/decode_utf8 ? > > > > > > > > > > ------------------------------------------------------------------------------ > > Download Intel® Parallel Studio Eval > > Try the new software tools for yourself. Speed compiling, find bugs > > proactively, and fine-tune applications for parallel performance. > > See why Intel Parallel Studio got high marks during beta. > > http://p.sf.net/sfu/intel-sw-dev > > _______________________________________________ > > Openca-Users mailing list > > Openca-Users@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/openca-users > > > > > Looks like data in database saved in latin1 or some other codepage. When I > use default mysql client encoding (latin1), cyrillic symbols are partly > displayed (some symbols are still displayed as unreadable marks) ( > http://old.nabble.com/file/p27873771/demo11.png demo11.png ), but after I > say 'set names "utf8"' all previously partly displayed symbols become > totally unreadable ( http://old.nabble.com/file/p27873771/demo12.png > demo12.png ) ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ Openca-Users mailing list Openca-Users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/openca-users