Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"
 
PerlMonks  

Re: Encoding issue from DBI to string

by karlgoethebier (Monsignor)
on Jan 03, 2013 at 17:06 UTC ( #1011489=note: print w/replies, xml ) Need Help??


in reply to Encoding issue from DBI to string

Did you set try to set...

default-character-set=utf8 default-collation=utf8_unicode_ci

...in your my.cnf and restart mysqld?

OK, i'm guessing again. 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://1011489]
help
Chatterbox?
[Corion]: Text::CSV_XS for all your CSV file parsing needs. Other than that, what problems do you have with perlre, and capturing everything after the comma? Also, index and substr would also work.
[choroba]: my ($value) = $string =~ /.*,(.*)/
[choroba]: The .* at the beginning matches the longest possible substring, so it eats any previous commas
[choroba]: But for CSV, use appropriate modules

How do I use this? | Other CB clients
Other Users?
Others scrutinizing the Monastery: (8)
As of 2018-05-27 08:54 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Notices?