I've just tried connecting staging machine to dev DB and in didn't work. "?????" all over the place.
| [reply] |
You never explicitly encode your output when you print it, so my guess is that you either have different locales on the machines, or use different terminal settings between the two machines. You can check whether the output of your program is good by hexdumping the output instead of printing raw bytes:
perl -w myprogram | od -x
If the output is the same between the two environments, then the problem is in your terminal settings, installed fonts or something like that. If the output is different, one problem happens somewhere earlier, maybe when writing to the database, reading from the database or outputting the data from your program. | [reply] [d/l] [select] |
OK, so locales checked = same, I've set the script to write into a text file. On dev machine I got correct chinese characters, but on staging I got question marks again
Interesting part is that spanish and german special characters work on both machines
| [reply] |
On both machines DBD::mysql is 4.018 and as for locals both have the pretty much the same, but the dev machine has DB locally and DB for staging is on another DB dedicated machine. Hm, I'll try to play with using different DBs just to see what will come of it.
| [reply] |