Is is possible to have utf8 data in a utf8 table, but the data is outputtet by mysql as latin1?
It should be possible, but IMHO that's not worth the trouble.
Really, charset issues are ugly to work with, and increasing the ugliness by using a terminal with a different encoding than you work with is just plain insane.
I tried that for a while, end then I switched everything to UTF-8 - my files, terminal, locales, cgi output, screen, irssi - you name it.
So my advice is:
- Get a clean environment with utf-8 locales
- dump your databases, and delete them
- Set any charset related configuration variable in mysql to utf-8
- Import the data, if possible use Encode::Guess to check if the data is utf-8 or latin1. If it is latin1, recode.
- Have fun!
mysql's charset handling is rather mysterious to me, and seemingly fragile, so I advise not to fiddle with it in complicated ways. (But if you find somebody who can tell you how to get it to work, you can use that route, of course).
Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
Read Where should I post X? if you're not absolutely sure you're posting in the right place.
Please read these before you post! —
Posts may use any of the Perl Monks Approved HTML tags:
- a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
| |
For: |
|
Use: |
| & | | & |
| < | | < |
| > | | > |
| [ | | [ |
| ] | | ] |
Link using PerlMonks shortcuts! What shortcuts can I use for linking?
See Writeup Formatting Tips and other pages linked from there for more info.