Re: Storing Arabic and English in the same table ( Mysql )

[Michelle Konzack <linux4michelle at freenet dot de>]

Am 2006-03-22 16:25:07, schrieb Tasmeea Noor:
> Thanks Usef, I tried, this is what I got ....
> I must be doing something wrong....
> 
> CREATE TABLE t1_test
> (
>     c1_utf8 VARCHAR(50) CHARACTER SET utf8,
> c2_eng VARCHAR(50)  );

Hmmmm, I use heavily PostgreSQL and this goes wrong here.

I think, you need to create the DATABASE in UTF-8 and
not (!!!) the table column.

My Database (160 GByte) is UTF-8 and has no problems to
store/show arabic, chinese or latin chars...

Oh yes, if I insert Data (Latin) into a table, PostgreSQL
converts automaticaly into UTF-8.  A function, which does
not work in MySQL (v5 I do not know currently)
 
Greetings
    Michelle Konzack
    Systemadministrator
    Tamay Dogan Network
    Debian GNU/Linux Consultant


-- 
Linux-User #280138 with the Linux Counter, http://counter.li.org/
##################### Debian GNU/Linux Consultant #####################
Michelle Konzack   Apt. 917                  ICQ #328449886
                   50, rue de Soultz         MSM LinuxMichi
0033/3/88452356    67100 Strasbourg/France   IRC #Debian (irc.icq.com)