pysome has asked for the wisdom of the Perl Monks concerning the following question:
Hi Monkers,
I have use the DBD::Sybase one year or so. That's nice to work to connect SqlServer.
But recently, i came across a strange garbage issues. pls help me to check.
Thanks in advance!
I have use the DBD::Sybase one year or so. That's nice to work to connect SqlServer.
But recently, i came across a strange garbage issues. pls help me to check.
I wanna insert a Asian characters' html content into SqlServer ,
if i do it like this, it work nicely.
But if i do it by another way, i get some garbage character in test_table:$some_content = 'so long Asian character (maybe it contain single quot +ation)'; $sql = "insert into test_table(field) values ($dbh->quote($some_conten +t))"; $dbh->do($sql); # you know, this works.
What's wrong with the second method? Or it is a $dbh->quote bug in Asian character?$some_content = $dbh->quote('so long Asia character (maybe it contain +single quotation)'); $sth = $dbh->prepare("insert into test_table(field) values (?)"); $sth->execute($some_content); $sth->finish();
Thanks in advance!
|
---|
Replies are listed 'Best First'. | |
---|---|
Re: A puzzled garbage character issues by use Perl-DBI
by lostjimmy (Chaplain) on Dec 19, 2008 at 15:38 UTC | |
Re: A puzzled garbage character issues by use Perl-DBI
by afoken (Chancellor) on Jun 17, 2009 at 12:18 UTC | |
by pysome (Scribe) on Jun 18, 2009 at 02:31 UTC | |
Re: A puzzled garbage character issues by use Perl-DBI
by Anonymous Monk on Dec 19, 2008 at 05:14 UTC | |
Re: A puzzled garbage character issues by use Perl-DBI
by pysome (Scribe) on Jun 17, 2009 at 08:06 UTC |
Back to
Seekers of Perl Wisdom