Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl: the Markov chain saw
 
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 meditating upon the Monastery: (9)
As of 2014-08-21 17:00 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (138 votes), past polls