Beefy Boxes and Bandwidth Generously Provided by pair Networks RobOMonk
Welcome to the Monastery
 
PerlMonks  

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. http://dev.mysql.com/doc/refman/5.0/en/configure-options.html 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 );
JamesNC


Comment on Re: Perl Character Set
Download Code

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others musing on the Monastery: (11)
As of 2014-04-18 11:31 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    April first is:







    Results (466 votes), past polls