I would really like to upgrade to SME 7, but this is holding me up:
It’s necessary for our SME server to offer a Japanese language database searchable from a web browser. We also have a page that takes customer input and sends two emails, one a confirmation to the customer and another to us.
I’m not much of a programmer, but with some PHP books and help from the Net I was able to write the scripts and have them run on SME 6.01 just fine.
With 6.01 I used “charset=Shift_JIS” on the html pages and didn’t worry about encodings or collotions in MySQL at all. It “just worked.”
With SME 7.x, it “just doesn’t work.” Switching to utf-8 helped me to kind of get the database working, or at least it will serve up Japanese data I’ve uploaded via phpMyAdmin to a web browser using utf-8. Putting Japanese into a database and pulling it back out via a browser remains an impossible dream, though. The other script emails garbage characters, whether I use utf-8, shift_JIS, you name it, in the metas or email headers, though. Why?
I know this is not about SME 7 per se, but somewhere between SME 6 and SME 7 things changed. Obviously Japanese can be used, as Horde sends Japanese OK and phpMyAdmin handles it in a database OK, too. I’m just not skilled enough to reverse engineer those products to find out how they do it.
Charlie Brady’s one-line register_globals answer to my question a while back was much appreciated. Can anyone point me in the right direction regarding double-bite characters and SME 7? (Yes, I have checked the Japanese sites.)
TIA
0 Replies
1632 Views