Superscript 2 character set issue

Godsrock37 has asked for the wisdom of the Perl Monks concerning the following question:

I have a string with a superscript 2 in the following form: \xB2

The character set is supposed to be utf-8 for all the data i'm dealing with but i cant confirm that for this particular character. When I go to insert the string into a mysql database i get the following error:

Thread 15 terminated abnormally: DBD::mysql::st execute failed: Incorrect string value: '\xB2 [22-...' for column 'Attribute8Value' at row 1

I'm completely baffled. I did: use utf8; do i have to convert it? TIA

Comment on Superscript 2 character set issue

Replies are listed 'Best First'.
Re: Superscript 2 character set issue by moritz (Cardinal) on Jul 29, 2008 at 17:47 UTC
`use`utf8 only affects string literals in your program code, not data that comes from the outside. Maybe you have to run it through Encode::decode first. See also: Encodings and Unicode in Perl, perluniintro, Encode, perlunicode, perlunifaq.	[reply] [d/l]
Re^2: Superscript 2 character set issue by Godsrock37 (Sexton) on Jul 29, 2008 at 18:10 UTC
Thanks for the help there. That cleared up some things for me. removed use utf8; and encode('utf8', $string) took care of it thanks again!	[reply]