[Israel.pm] MySQL, Class::DBI and hebrew?

[Shmuel Fomberg]

Hi Shlomi.

>> I have a table in MySQL, that I access using Class::DBI, which contains
>> names.
>
>First of all a question - is there any reason you prefer Class::DBI over
>DBIx::Class which is:
>
>1. Similar.
>
>2. Newer.
>
>3. Better.
>
>4. Generally considered preferable - see
>http://www.perlmonks.org/?node_id=557402 .

But Class::DBI is easier to setup, and enough to my needs. 

>I was able to get DBIx::Class to work with Unicode by using the advice
>here:
>http://dev.mysql.com/tech-resources/articles/4.1/unicode.html and the
>following script:

Thanks for the link. Another great idea in the link you posted was the
hiding a string in the form parameters, and analyzing it to see that the
browser is actually submitting utf8. I wonder if it's that simple, (just two
options) or maybe every encoding make other result. If it is more
complicated, then there should be a module about it.

And thanks for the code. I'm using it.

Shmuel.