Date: Wed, 15 Aug 2007 11:00:20 +0200 From: VeeJay <maanjee@gmail.com> To: "Matthias Apitz" <m.apitz@oclcpica.org> Cc: FreeBSD-Questions <freebsd-questions@freebsd.org> Subject: Re: Help....How to set FreeBSD to handle UTF8 characters? Message-ID: <2cd0a0da0708150200l715806a5u4469a44084f1e56@mail.gmail.com> In-Reply-To: <20070815071410.GA3418@rebelion.Sisis.de> References: <2cd0a0da0708150004r3b6754daje12f96d55a50b596@mail.gmail.com> <20070815071410.GA3418@rebelion.Sisis.de>
next in thread | previous in thread | raw e-mail | index | archive | help
Thanks Matthias
I appreciate your help!
Actually, I have a problem. I am running MySQL, Apache on freebsd server.
First, I am unable to type the scandinavian characters even I have tried to
set the keyboard to danish/swedish etc, etc,... but no luck... but when I
give these commands
$ export LC_CTYPE=3Den_US.UTF-8
$ export LC_COLLATE=3DPOSIX
then I am able to type in the shell but not correctly, if I press one key
for example =F8, it types two... that is the problem...
Then then problem comes with MYSQL....(I don't know if you have some hands
on mysql?)
I have a database in utf encoding. I can get results * from the database an=
d
characters are shown correct formate in the IE browser with utf-8 encoding.
BUT
When I try to select some names starting with extra alphabets (=C5 =C6 =C4 =
=D6,
etc), I simply don't get required results i.e.,
if I give a select command like:
select * from employees where fname LIKE '=C5%';
I get results starting with English alphabet 'A' but not with '=C5'. Which
also exist in database.
It happens same with =C4...
Surprisingly, for =D8 I can retreive data but not for =D6. For =D6, I get r=
esults
starting with english O... :(
Here is the output of database characterset:
mysql> SHOW VARIABLES LIKE 'character_set%';
+--------------------------+----------------------------------------+
| Variable_name | Value |
+--------------------------+----------------------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/local/mysql/share/mysql/charsets/ |
+--------------------------+----------------------------------------+
8 rows in set (0.00 sec)
Operating system is FreeBSD 6.2.
MySQL 5.0
Thanks for your kind help!
On 8/15/07, Matthias Apitz <m.apitz@oclcpica.org> wrote:
>
> El d=EDa Wednesday, August 15, 2007 a las 09:04:58AM +0200, VeeJay escrib=
i=F3:
>
> > FreeBSD 6.2
> >
> > Please help!
>
> It depends what you exactly want and you should ask with more
> details;
>
> When I need UTF-8 support to edit files or view them I use:
>
> $ LANG=3Des_ES.UTF-8 xterm -T utf8 -fn 10x20
>
> and run for example 'vim' in the new xterm window;
>
> matthias
>
> --
> Matthias Apitz
> Manager Technical Support - OCLC PICA GmbH
> Gruenwalder Weg 28g - 82041 Oberhaching - Germany
> t +49-89-61308 351 - f +49-89-61308 399 - m +49-170-4527211
> e <m.apitz@oclcpica.org> - w http://www.oclcpica.org/
> http://www.UnixArea.de/
> b http://gurucubano.blogspot.com/
> OCLC PICA GmbH, Geschaeftsfuehrer: Christine Magin-Weeger, Norbert
> Weinberger
> Sitz der Gesellschaft: Oberhaching, HRB Muenchen: 113261
>
--=20
Thanks!
BR / vj
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?2cd0a0da0708150200l715806a5u4469a44084f1e56>