Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot
 
PerlMonks  

Re^2: Trouble with Perl MySQL Arabic

by rminner (Chaplain)
on Aug 20, 2006 at 09:03 UTC ( [id://568412]=note: print w/replies, xml ) Need Help??


in reply to Re: Trouble with Perl MySQL Arabic
in thread Trouble with Perl MySQL Arabic

i agree with graff, that it's probably a problem that ocurrs while recoding data between charsets. It might fail at either of the two points: reading or writing.
You should try to determine which charset the data ist you get from your dbi call. It might be correctly converted to utf8, or erroneously be treated as utf8 even though it isn't.
If it is converted to utf8 correctly, then an explicit recode might be required for writing back the data (utf8 to cp1256).
If it reads the input data as correct unicode data, it might also be that the viewer you are using is only showing questionmarks, because you inserted unicode data and the viewer can't handle it.
Check the codepage of the data you are getting and the codepage you want to write it back with. Judging by your problem it seems to be required that you recode your data at least once, and for that you'll have to know the input codepage and the desired output codepage.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://568412]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (8)
As of 2024-04-23 10:35 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found