Skip site navigation (1)Skip section navigation (2)
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>