Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic
 
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 browsing the Monastery: (19)
As of 2015-07-29 14:54 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (263 votes), past polls