I have some Japanese characters in an article I'm editing and noticed
that the UTF-8 I paste into the form gets converted to question marks
after I post it. I did a little bit of poking around and believe this
is the result of the c4lj database having a default character set of
latin1.
mysql> show create database c4lj;
+----------+-----------------------------------------------------------------+
| Database | Create Database |
+----------+-----------------------------------------------------------------+
| c4lj | CREATE DATABASE `c4lj` /*!40100 DEFAULT CHARACTER SET latin1 */ |
+----------+-----------------------------------------------------------------+
1 row in set (0.00 sec)
I just thought I'd mention it in case it hasn't come up before.
//Ed
Not knowing much about character sets, is your recommendation that we
change the setting in MySQL to UTF-8? Will that have any consequences
for our existing articles that were created with the latin1 setting?
I would want to back up the Wordpress database before making any
change -- so probably not until Saturday if we decide to do this.
Tom
> --
> You received this message because you are subscribed to the Google Groups "Code4Lib Journal-discuss" group.
> To post to this group, send email to c4lj-d...@googlegroups.com.
> To unsubscribe from this group, send email to c4lj-discuss...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/c4lj-discuss?hl=en.
>
>
I'm not actually recommending anything. charset issues can be thorny.
Just pointing out something you all may have known already.
//Ed
-Tod
-Tod