Hi Makis,
default-character-set  = greek

Try that, best wishes,
Ken

P.S.  also for anyone else asking here are all the charsets included
in MySQL by default.  You can also create your own.

mysql> show variables like "char%";
+----------------+----------------------------------------------------
----------------------------------------------------------------------
---------------------------------+
| Variable_name  | Value
|
+----------------+----------------------------------------------------
----------------------------------------------------------------------
---------------------------------+
| character_set  | latin1
|
| character_sets | latin1 dec8 dos german1 hp8 koi8_ru latin2 swe7
usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr
win1251ukr greek win1250 croat cp1257 latin5 |
+----------------+----------------------------------------------------
----------------------------------------------------------------------
---------------------------------+
2 rows in set (0.00 sec)



----- Original Message -----
From: "savaidis" <[EMAIL PROTECTED]>
To: "Ken Menzel" <[EMAIL PROTECTED]>; "Philip Semanchuk"
<[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, March 28, 2002 12:40 PM
Subject: RE: SELECT w/LIKE on Swedish character ö finds ], why?


> Is there something similar for Greeks too?
> (not that matters very much as I run on internet host but in case..)
>
>
> Makis
>
>
> > -----Original Message-----
> > From: Ken Menzel [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, March 26, 2002 10:25 PM
> > To: Philip Semanchuk
> > Cc: [EMAIL PROTECTED]
> > Subject: Re: SELECT w/LIKE on Swedish character ö finds ], why?
> >
> >
> > Hi Philip,
> >   before running your test next time try this:
> >
> > vi /etc/my.cnf
> >
> > insert into this file:
> >
> > [mysqld]
> > default-character-set  = swe7
> >
> > then stop mysql (mysqladmin shutdown)
> >
> > and restart (safe_mysqld&)
> >
> > then try your test again.  It worked fine for me.
> >
> > Ken
> >
> >
> > > Philip Semanchuk wrote:
> > > >
> > > > Hi everyone,
> > > > I am having a little trouble with searching for Swedish
> > characters. When I
> > > > SELECT using LIKE I get matches that I do not expect. I have
> > created a
> > > > simple test case that is entirely reproduced below. To
summarize,
> > I insert
> > > > one row into a single-column table that contains the right
square
> > bracket
> > > > character (ASCII 0x5d). When I search for the Swedish letter ö
> > (ISO-8859-1
> > > > 0xf6) I find the row containing the right bracket.
> > > >
> > > > We're running RedHat 7.2 with nothing fancy added in as we're
> > Linux novices
> > > > and just playing around with the system to see how it works.
> > MySQL -V
> > > > produces this:
> > > > mysql  Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu (i386)
> > > >
> > > > Here's my test:
> > > >
> > > > mysql> create database swedish_character_test;
> > > > Query OK, 1 row affected (0.00 sec)
> > > >
> > > > mysql> use swedish_character_test;
> > > > Database changed
> > > > mysql> create table simple (name varchar(255) NOT NULL);
> > > > Query OK, 0 rows affected (0.00 sec)
> > > >
> > > > mysql> insert into simple (name) values (']');
> > > > Query OK, 1 row affected (0.00 sec)
> > > >
> > > > mysql> select name from simple where name like '%ö%';
> > > > +------+
> > > > | name |
> > > > +------+
> > > > | ]    |
> > > > +------+
> > > > 1 row in set (0.00 sec)
> > > >
> > > > I'd appreciate any help understanding why ö = ] in this case.
> >
> >
> >
>
> --------------------------------------------------------------------
-
> > Before posting, please check:
> >    http://www.mysql.com/manual.php   (the manual)
> >    http://lists.mysql.com/           (the list archive)
> >
> > To request this thread, e-mail
<[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php
> >
>
>
> --------------------------------------------------------------------
-
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php
>
>


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to