Re: mysql encoding xaraya nightmare
"Jason" <[email protected]>
| Newsgroups | gmane.comp.cms.xaraya.user |
|---|---|
| Organization | Xaraya |
| Message-ID | <[email protected]> |
"stein" <[email protected]> wrote in message news:mailman.817.1175871908.5440.xaraya_user-gn8pmO+6nsymdvSpIQae8A@public.gmane.org > I'm converting a portion of a Xaraya installation to Drupal and have a big > problem. > > Background: > PHP 4.3.9, Apache 2.0.52, mysql 4.1.20 > Xaraya base set to "Full Multilanguage" and en_US.utf-8 > > Users post content in both English and Japanese. > > Content with Japanese characters displays perfectly fine on the Xaraya > site. > > PROBLEM: > Content with Japanese characters appears as gibberish in the mysql > tables > (viewing in phpmyadmin) > and when copied into the Drupal database appears as gibberish in > Drupal... > > Example: > ?????? appears fine on the site but in the mysql database, it appears > (in > phpmyadmin) > as ã(c)ã?ã§ã-ãYã<? > > anyone have any ideas? Any help or hints would be a lifesaver :-)! The only thing I would say is: do not trust phpMyAdmin. You just don't have the proper control over encoding. It tries to be too clever and recodes characters if it sees fit, but it does not tell you that it is doing the recoding. For example, when you import and export, there is no option to tell it what character set to use in the export, or whether to recode the data or not, or what character set to use to interpret the import file. How phpMyAdmin determines when to reencode or not reencode, is something I've never quite got my head around. Try exporting and importing using the command-line tools instead. You may have more luck. -- JJ _______________________________________________ Xaraya_user mailing list [email protected] http://xaraya.com/mailman/listinfo/xaraya_user