From owner-freebsd-questions@FreeBSD.ORG  Thu Dec  8 03:17:34 2005
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
X-Original-To: freebsd-questions@freebsd.org
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 1062E16A41F
	for <freebsd-questions@freebsd.org>;
	Thu,  8 Dec 2005 03:17:34 +0000 (GMT)
	(envelope-from dopplecoder@gmail.com)
Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.207])
	by mx1.FreeBSD.org (Postfix) with ESMTP id D56A543D72
	for <freebsd-questions@freebsd.org>;
	Thu,  8 Dec 2005 03:17:28 +0000 (GMT)
	(envelope-from dopplecoder@gmail.com)
Received: by zproxy.gmail.com with SMTP id 9so518637nzo
	for <freebsd-questions@freebsd.org>;
	Wed, 07 Dec 2005 19:17:27 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition;
	b=iaWn8FSs4yLxKtJlBc0PXT8W9KIWVwNsvtas/shPPn5E1mg0CJrewFsxKLh/p0OXNibrYWzVALZI1CWDjeNgCi9okYf4uPU5oh6ra4IIoUtgsUQReDWDe3Z/0UzUCDmn9bWpHnD59Cnxw6tCiOh5HjduTGCVq0fKLAMVXrL1Jq0=
Received: by 10.36.108.16 with SMTP id g16mr2179812nzc;
	Wed, 07 Dec 2005 19:17:27 -0800 (PST)
Received: by 10.36.132.16 with HTTP; Wed, 7 Dec 2005 19:17:27 -0800 (PST)
Message-ID: <45d750d20512071917k76ac173ci286eb2e1f5bb0c49@mail.gmail.com>
Date: Wed, 7 Dec 2005 22:17:27 -0500
From: Aaron Peterson <dopplecoder@gmail.com>
To: FreeBSD Questions <freebsd-questions@freebsd.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Subject: console characters/keyboard
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Thu, 08 Dec 2005 03:17:34 -0000

I have been working with a database recently that contained values
with special characters.  A lower case "n" with a tilde over it for
instance.  Anyway, during the conversion of the database from mysql to
sqlite these special characters got corrupted.  I ended up fixing them
by hand since there weren't many, but during the process I realized
these things:

1) My console does not print these characters, but empty box characters ins=
tead

2) I have no good way of entering these characters (that I know of)
with my standard keyboard layout and language settings.

So the obvious questions follow:

1) Can I somehow alter my console or add fonts so these characters are
displayed properly

2) I ended up writing a perl program and giving it html entities to
decode back to the special character and insert into the database, but
this is very roundabout.  How can I set my FreeBSD box up to be able
to enter such characters manually?

Thanks in advance for any assistance,
Aaron