Re: inserting win1256 data using perl-dbi

["uttam hoode" <uttamhoode at gmail dot com>]

Dear friends,

  Thanks u for the tips.....

  i am able to solve the problem. Instead of windows 1256 charset now i am using UTF-8 encoding but atrribute type remains the same(VARCHAR,CHAR and not NVARCHAR,NCHAR........)
  is there any problem/issues if i use VARCHAR for UTF?

Regards,
uttam

On 6/25/06, ahmed < ahmed at piousity dot net> wrote:

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



_______________________________________________
Developer mailing list
Developer at arabeyes dot org
http://lists.arabeyes.org/mailman/listinfo/developer