forcing utf8 on selected values




There are several to-do items regarding utf8 that would be
great, but aren't here yet.

My database has utf8 columns, server/client character sets and
collation. Yet when I call fetchrow, resulting Perl scalars do
not have the utf8 flag set. That's really annoying. Am I
supposed to call

map { utf8::upgrade($_) } $every,$stupid,$little,$scalar

every time I do a select statement? Or map through the results
of any selectall_*ref's? This fixes the display problems when
printing a page to a browser with charset utf-8.

Is there an easier way to do this? Please tell me there is.

Mark
.



Relevant Pages

  • Re: forcing utf8 on selected values
    ... For proper Unicode support on Oracle, you should use at least Oracle 9 on both client and server, and you should read http://search.cpan.org/~timb/DBD-Oracle-1.16/Oracle.pm#Unicode at least twice. ... There are several to-do items regarding utf8 that would be great, ... server/client character sets and collation. ...
    (perl.dbi.users)
  • RE: forcing utf8 on selected values
    ... What database are you using? ... forcing utf8 on selected values ... There are several to-do items regarding utf8 that would be ... server/client character sets and ...
    (perl.dbi.users)
  • Re: latin1_german2_ci, utf-8
    ... dem Webserver sind in UTF-8 und dementsprechend die SQL-Anfragen ebenso. ... Unangenehmerweise gibt es keine deutsche Collation für UTF8. ... UTF8 verwenden. ... Alternativ kannst du bei jeder Vergleichsoperation in latin1 wandeln ...
    (de.comp.datenbanken.mysql)
  • Re: Unicode Kollation
    ... Für Griechisch gibt es wohl noch keine Collation. ... Die ist aber für Charset=greek und nicht für utf8. ... > erst in die Datenbank zu schreiben? ... Ich verstehe bei Griechisch immer nur Spanisch;-) kann das also nicht ...
    (de.comp.datenbanken.mysql)
  • Re: mysql, php, Kollationen und Tschechisch
    ... Ich rate jetzt mal ins Blaue: du willst eine PHP-Webapplikation ... *alles* in UTF8 zu encodieren. ... Collation zu verwenden. ...
    (de.comp.datenbanken.mysql)