utf8 in QB
"Taras D" <[email protected]> Tue, 30 Jan 2007 00:32:25 +1030
| Newsgroups | gmane.comp.db.mysql.mycc |
|---|---|
| Message-ID | <[email protected]> |
Hi everyone, Does QB default to utf8. Executing 'show variables like 'character_set_%'' shows that all of the variables are set to utf8 (I've created my database with utf8 as the default charset) except for server (set on latin1), and filesystem (set on binary). Having said that, why can I type in characters using MS pinyin editor into query editing area at the top, and even though the characters in the editing pane are stuffed, they get inserted correctly (checked by using HEX())? Although they get inserted correctly, when I execute select *, the chinese characters display correctly but they are rotated to the left 90 degrees (I'm using Arial MS Unicode font) - does anyone else have this problem? Also, [forums.mysql.com<http://forums.mysql.com/read.php?108,32285,32285#msg-32285>] writes that: "QB only uses utf8 internally." - what is being referred to here, the metadata? Thanks Taras