Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask
 
PerlMonks  

Re^2: How to Encode/Decode double encoded string.

by Anonymous Monk
on Sep 22, 2020 at 05:59 UTC ( [id://11122054]=note: print w/replies, xml ) Need Help??


in reply to Re: How to Encode/Decode double encoded string.
in thread How to Encode/Decode double encoded string.

Hi Haj,

Thank you for the reply.
I have basically below two strings in the postgres database

select title from TABLE; title ------------------------------------------- this is a test international ���� #This string got inserte +d in the database using perl version 5.24.1 this is a test international àáâä #This string got inserte +d in the database using oldest version of version i don't know the ex +act version but it seems it this version doesn't handle utf8 by defau +lt, this was inserted using Legacy version of the application.
How can we get around this issue, as i mentioned earlier first string get the correct result when used Encode module but second doesn't.

Thank you.

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others admiring the Monastery: (5)
As of 2024-04-23 20:48 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found