Re: inserting win1256 data using perl-dbi

[ahmed <ahmed at piousity dot net>]

salams -
1. i use iconv to deal with this (iconv -f windows-1256 -t utf-8
filename > output) for example.

2. i wrote a script a while back to convert the arabeyes xml files into
a particular db schema... with later versions of mysql while inserting
utf8, don't forget to do a query first of "set names 'utf8'" -- this was
often a problem i ran into.

3. if you'd like, i can send you the code (its in java written a while
back).

wsalams.
-ahmed

On Fri, 2006-06-23 at 11:41 -0400, Tasmeea Noor wrote:
> Hello,
>  
> 1) I had similar situation. I created the table in utf-8 characterset.
> So it overrides the database level configuration.
>  
> 2) Does any one know the standard method of loading Arabic data file
> into table ? When I use form to enter Arabic data it works fine. But
> this is time consuming. I tried to use comma delimited files, but it
> did not work. I used phpmyadmin.
>  
> 3) Does anyone know how to get soft copy of Arabic Quran, which I can
> load into tables ?
>  
> Thanks, Tasmeea
>  
> 
> 
>  
> On 6/23/06, uttam hoode <uttamhoode at gmail dot com> wrote: 
>         hi all,
>         i have a perl cgi form which takes arabic data and enters into
>         a table. Form is encoded in windows 1256(arabic)
>         charset.....but in the database the arabic data is stored in
>         html entity format(&#xxxx)......i want to store the data as it
>         is......... 
>         
>         attribute type is VARCHAR2 and database charset is
>         AR8MSWIN1256.....
>         
>         is there any SQL parameter to do so?....
>         
>         Regards,
>          
>         uttam 
>         
>         _______________________________________________
>         Developer mailing list
>         Developer at arabeyes dot org
>         http://lists.arabeyes.org/mailman/listinfo/developer
> 
> _______________________________________________
> Developer mailing list
> Developer at arabeyes dot org
> http://lists.arabeyes.org/mailman/listinfo/developer