From owner-freebsd-questions@FreeBSD.ORG Wed Aug 15 09:00:20 2007 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id D45B316A419 for ; Wed, 15 Aug 2007 09:00:20 +0000 (UTC) (envelope-from maanjee@gmail.com) Received: from rv-out-0910.google.com (rv-out-0910.google.com [209.85.198.189]) by mx1.freebsd.org (Postfix) with ESMTP id A853B13C4B6 for ; Wed, 15 Aug 2007 09:00:20 +0000 (UTC) (envelope-from maanjee@gmail.com) Received: by rv-out-0910.google.com with SMTP id l15so108159rvb for ; Wed, 15 Aug 2007 02:00:20 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=qo5BZV5LnRcGbeQrFXe5s9hREmodKZeUweK3B29bxuiVOvTrGSWXTaHVfxtrVNGifDo4pD3/EA9Oo5tuGzH2zIuxSmsoPzQ8072X068S6lYVB0N5PMD75dUMKjXOJYUCIXwo4x98/preg24L8P3LIuF2+v0nDArOT1Gtkom2V8s= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=R5nvA+XdCrBXQ4pDKVULyuJIPCllg8a2LPT0Ul59Wjxvd7jpGdCbnhJmxHmXSo+FA33r2jTI26hpq2ibj85ccALioixLs3CrVf/zse3MAOj+ax2qHGlIEDYmkdLrJb2bK68NpBBf2KgfbBymBjwCLO199XiVsOeRM3z2tticbew= Received: by 10.114.77.1 with SMTP id z1mr309012waa.1187168420300; Wed, 15 Aug 2007 02:00:20 -0700 (PDT) Received: by 10.114.131.14 with HTTP; Wed, 15 Aug 2007 02:00:20 -0700 (PDT) Message-ID: <2cd0a0da0708150200l715806a5u4469a44084f1e56@mail.gmail.com> Date: Wed, 15 Aug 2007 11:00:20 +0200 From: VeeJay To: "Matthias Apitz" In-Reply-To: <20070815071410.GA3418@rebelion.Sisis.de> MIME-Version: 1.0 References: <2cd0a0da0708150004r3b6754daje12f96d55a50b596@mail.gmail.com> <20070815071410.GA3418@rebelion.Sisis.de> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Cc: FreeBSD-Questions Subject: Re: Help....How to set FreeBSD to handle UTF8 characters? X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 15 Aug 2007 09:00:21 -0000 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 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 - 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