Mailing List Archive


Back to the month index Back to the list index
Steve Ivy (steve@artlabeurope.com)
Thu, 02 Jan 1997 23:25:51 +0000 

Date: Thu, 02 Jan 1997 23:25:51 +0000
From: Steve Ivy <steve@artlabeurope.com>
Subject: [mSQL] 8-bit troubles
Message-Id: <MailDrop1.2d7dPPC.970102232551@cruiser.artlabeurope.com>

Greeting sand Happy New Year all-

     I posted something about this a week or so back but have been
fiddling with it since and still haven't gotten it down. I have been
having some problems with a perl script i'm using with Msqlperl...

     mostly it runs fine, but i ran into some problems with 8-bit
characters, meaning the ü,ö, and ä. I have a page where users can look
up equipment dealers by postal code (using a "like" operator in msql and
the first three characters of the code - "181%") or by name of the city.
The postal code part works fine. And when I try the city it works fine
if there are no funky German characters in it. If I try, say,
"Karlsrühe" i get no results, though I know that there is an entry
there.

     I figured there are several pieces to this puzzle:

     1) The Client Machine: a Mac. I don't know if the input method
matters, but anything's possible.

     2) The Browser: in this case Netscape. It takes the umlauts just
fine, but I don't know how it's encoding them.

     3) The Server: Apache 1.1.something. I think it's taking things
fine- I have a "you searched for xxx" thingy in the script and it
returns the umlauts just fine too.

     4) The Script: Msqlperl and Perl 5.0.3. I think I'm doing things
correctly, but not sure. I take the argument passed to the script and
run it thru the Msql->quote() method to escape anything interesting. See
above: It _seems_ to be working.

     5) The mSQL Server: I am told msql is 8-bit but cannot confirm
this. Performing the query- "select * from dealers where Ort =
'Karlsrühe'" in the mSQL monitor doesn't work- either telnetted into the
server from a Mac or directly on the server, including with a German
keyboard configuration.

     I am stumped, folks. Any ideas out there?

     Thanks-
          --steve

------------------------------------------------------------------------
-
relevant stats follow:
------------------------------------------------------------------------
-
Version Details :-

        msqladmin version 2.0 Beta 1
        mSQL server version 2.0 Beta 1
        mSQL protocol version 22
        mSQL connection Localhost via UNIX socket
        Target platform FreeBSD-2.1.0-RELEASE-i386

Configuration Details :-

        Default config file /usr/local/Hughes/msql.conf
        TCP socket 1114
        UNIX socket /usr/local/Hughes/msql2.sock
        mSQL user msql
        Admin user root
        Install directory /usr/local/Hughes
        PID file location /usr/local/Hughes/msql2d.pid

------------------------------------------------------------------------
        "And if you hold on tight To what you think is your thing
               You may find you're missing all the rest..."

             Dave Matthews Band - "The Best Of What's Around"
           Steve Ivy -- ArtLab Europe -- Altensteig -- Germany

--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!