UTF8 on DBI with Perl

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View


I'm using DBI with Perl.

The default character set is 'latin1' - more particulary

I need one field to be UTF8.

I've tried

Example text CHARACTER SET utf8

but it dies not pick up the European characters.

Any ideas?


I am using the free version of SPAMfighter for private users.
It has removed 99334 spam emails to date.
Paying users do not have this message in their emails.
Try SPAMfighter for free now!

Re: UTF8 on DBI with Perl

Quoted text here. Click to load it
I'm not familiar  with MySQL5 (if you yse ver.5) but is better to change
table to character ser you want. In other word do "alter table ... " and set
utf8 as default charset for this table.
Other way is to set one filed as binary but in this case forget to searching
anything in this field ;-)

Petr Vileta, Czech republic
(My server rejects all messages from Yahoo and Hotmail. Send me your mail
from another non-spammer site please.)

Site Timeline