UTF8 on DBI with Perl

Hi

I'm using DBI with Perl.

The default character set is 'latin1' - more particulary
'latin1_swedish_ci'.

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?

Regards
John




------------------------------------------------------------ --------------------
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

"John" píše v diskusním pøíspìvku
news:3budnRLLj-mITZLbRVnyiAA@eclipse.net.uk...
> Hi
>
> I'm using DBI with Perl.
>
> The default character set is 'latin1' - more particulary
> 'latin1_swedish_ci'.
>
> 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'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.)