Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked
 
PerlMonks  

Re^3: Encoding issue from DBI to string

by ev0lution (Initiate)
on Jan 03, 2013 at 20:57 UTC ( #1011518=note: print w/ replies, xml ) Need Help??


in reply to Re^2: Encoding issue from DBI to string
in thread Encoding issue from DBI to string

Even after adding in the default-collation=utf8_unicode_ci, I'm still getting all question marks for multibyte characters. What a headache.

Not sure if anyone who have the answer here, but assuming the DB is set up appropriate with all UTF-8 encoding and data appearing valid in the tables, it wouldn't really matter how it's getting into the database to begin with, right?

We're using a 3rd party program as a scraper, and its underlying Java is dumping the data to the DB. I haven't looked into it much just because the data appears right in the DB with all UTF-8 encoding configured, so I assumed it wasn't the issue.


Comment on Re^3: Encoding issue from DBI to string
Download Code
Re^4: Encoding issue from DBI to string
by karlgoethebier (Curate) on Jan 04, 2013 at 10:02 UTC
    "Even after adding in the default-collation..."

    S**t!

    "...it wouldn't really matter how it's getting into the database to begin with, right?

    To be honest, i'm not shure about this.

    BTW, what happens if you fire up your query using mysql client?

    Regards, Karl

    «The Crux of the Biscuit is the Apostrophe»

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others examining the Monastery: (5)
As of 2014-10-22 06:03 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    For retirement, I am banking on:










    Results (113 votes), past polls