Help....How to set FreeBSD to handle UTF8 characters?

[VeeJay]

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=en_US.UTF-8
    $ export LC_COLLATE=POSIX

then I am able to type in the shell but not correctly, if I press one key
for example ø, 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 and
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 (Å Æ Ä Ö,
etc), I simply don't get required results i.e.,
if I give a select command like:

select * from employees where fname LIKE 'Å%';
I get results starting with English alphabet 'A' but not with 'Å'. Which
also exist in database.
It happens same with Ä...

Surprisingly, for Ø I can retreive data but not for Ö. For Ö, I get results
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 at oclcpica.org> wrote:
>
> El día Wednesday, August 15, 2007 a las 09:04:58AM +0200, VeeJay escribió:
>
> > 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=es_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 at 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
>



-- 
Thanks!

BR / vj