|We don't bite newbies here... much|
Is utf8, ascii ?by rootcho (Pilgrim)
|on Aug 07, 2007 at 17:22 UTC||Need Help??|
rootcho has asked for the wisdom of the Perl Monks concerning the following question:
I had a problem with Postgresql trying to insert some non standard characters (i think some sort of Japanese).
The DBD::Pg just died :( complaining it was not UTF8, when trying to do that. (it is a script that parses files and inserts into the the DB)
So what I've decided to do is check in some way for utf8-ness of the string before inserting. I tried with Test::utf8 and later with Encode::Guess::guess_encoding($str).
My question is ? Is this the best and fastest way to check if the string will not break the db-insert ? Will I miss some other charsets this way, which otherwise will do well.
The DB is set to UTF8 of course.