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