Re: Mutated Vowels like german Ö or ä

["Mariano Glas" <glas_(at)_orgaline.de>]

try

insert into testfield values(CONCAT('H ',CHAR(xxx),'h und hot');
where xxx is the ascii code of a value that you want (e.g 252 = ü).

Murray



-----Ursprüngliche Nachricht-----
Von: Oliver Etzel <oliver.etzel_(at)_muenchen.org>
An: <mysql_(at)_lists.mysql.com>; <www-scripts_(at)_tahoenet.com>;
<mysql-de_(at)_lists.4t2.com>
Gesendet: Montag, 20. Dezember 1999 12:13
Betreff: Re: Mutated Vowels like german Ö or ä


> Hi all,
>
> I have  the a problem with the the mutated vowels, like german öäü or
> french é.
>
> I developped an internet auction on german SuSE Linux 6.1. The mutated
> vowels were interpreted as they are.
> If somebody filled out a HTML Form as "Name=Ali Öcügür", then the insert
was
> "Ali Öcügür" then.
> Now my provider has Linux RedHat. On this, the us-american verison of
mysql
> is running. This Version cannot interprete mutated vowels. Ö is
interpreted
> and inserted
> as |.
>
> Is it possible to determine the german charset when I  create a table
> (during creation process). Or even better, can I change the charset
> afterwards?
>
> Do you know about a similar case and how it was governed???
>
> Oli
>
>
>
>
>
>
>
> ----------------------------------------------------------------------
> e-Mail: oliver.etzel_(at)_muenchen.org
> Home: http://www.goodngo.com/  http://www.goodngo.de/
> Oliver Etzel
> Westendstr. 20
> D-80339 München, Germany
> Tel:   +49 (0)89 5000-9919
> Fax:  +49 (0)89 5000-9919
> oliver.etzel_(at)_fbmev.de
> oliver.etzel_(at)_mucweb.de
>
> ----- Original Message -----
> From: Oliver Etzel <oliver.etzel_(at)_muenchen.org>
> To: Oliver Etzel <oliver.etzel_(at)_muenchen.org>; <mysql_(at)_lists.mysql.com>
> Sent: Monday, December 20, 1999 1:49 AM
> Subject: Mutated Vowels like german Ö or ä
>
>
> | Hi all,
> |
> | I have  the a problem with the the mutatated vowels, like german öäü or
> | french é.
> |
> | I developped an internet auction on german SuSE Linux 6.1. The mutatated
> | vowels where interpreted as they are.
> | If somebody filled out a HTML Form as "Name=Ali Öcügür", then the insert
> was
> | "Ali Öcügür" then.
> | Now my provider has Linux RedHat. On this, the us-american verison of
> mysql
> | is running. This Version cannot interprete mutated vowels. Ö is
> interpreted
> | as |.
> |
> | What I have to do. Translate before inserting??
> | Do you know about a similar case and how it was governed???
> |
> | Oli
> |
> |
> |
> |
> |
> |
> | ----------------------------------------------------------------------
> | e-Mail: oliver.etzel_(at)_muenchen.org
> | Home: http://www.goodngo.com/  http://www.goodngo.de/
> | Oliver Etzel
> | Westendstr. 20
> | D-80339 München, Germany
> | Tel:   +49 (0)89 5000-9919
> | Fax:  +49 (0)89 5000-9919
> | oliver.etzel_(at)_fbmev.de
> | oliver.etzel_(at)_mucweb.de
> |
> | ----- Original Message -----
> | From: Oliver Etzel <oliver.etzel_(at)_muenchen.org>
> | To: <mysql_(at)_lists.mysql.com>
> | Sent: Saturday, July 31, 1999 9:04 PM
> | Subject: Literature about MySQL & Perl
> |
> |
> | |
> | | Hello T.c.X. Team,
> | |
> | | I am looking for some Books about learning MySQL and Perl.
> | | Please send me a List.
> | |
> | | Thank You,
> | |
> | | Oliver Etzel
> | |
> | |
> | | ----------------------------------------------------------------------
> | | e-Mail: oliver.etzel_(at)_muenchen.org
> | | Home: http://homepages.fbmev.de/bm752736/
> | | Oliver Etzel
> | | Westendstr. 20
> | | D-80339 München, Germany
> | | Tel:   +49 (0)89 5000-9919
> | | Fax:  +49 (0)89 5000-9919
> | | oliver.etzel_(at)_fbmev.de
> | | oliver.etzel_(at)_mucweb.de
> | |
> | |
>
> ---
> *** Abmelden von dieser Mailingliste funktioniert per E-Mail
> *** an mysql-de-request_(at)_lists.4t2.com mit Betreff/Subject: unsubscribe
>
>


---
*** Abmelden von dieser Mailingliste funktioniert per E-Mail
*** an mysql-de-request_(at)_lists.4t2.com mit Betreff/Subject: unsubscribe