Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine

Re: Perl Character Set

by JamesNC (Chaplain)
on Nov 02, 2005 at 01:18 UTC ( #504792=note: print w/replies, xml ) Need Help??

in reply to Perl Character Set

On MySQL's site you can read the docs for your database. shows how to config for different encodings. You don't say what datatype you are using, but I use varbinary for any data I think might need unicode support. You really just have to hanker down with the docs. Also, there are other ways to be more specific about the way you bind to your place holders where you tell DBI what datatype to use ( look for :sql_type in the perldoc on DBI, for example you might do something like this for your query:
use DBI qw/:sql_types/; #... $query->bind_param(1, 'A ', SQL_VARBINARY );

Log In?

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

How do I use this? | Other CB clients
Other Users?
Others perusing the Monastery: (7)
As of 2016-10-27 22:23 GMT
Find Nodes?
    Voting Booth?
    How many different varieties (color, size, etc) of socks do you have in your sock drawer?

    Results (371 votes). Check out past polls.