RE: Character Set Settings

[Nikoloudis George (george.nikoloudis@intracom.gr)]

Dear Nikos
I did that I nothing.

I am sending you also the php script I run:
meta http-equiv=Content-Type content=text/html; charset=greek8

?php
   /* Connecting, selecting database */
   $link = mysql_connect(localhost, test, )
   or die(Could not connect);
   print Connected successfully;
   mysql_select_db(mysql) or die(Could not select database);

   /* Performing SQL query */
   $query = SELECT * FROM test;
   $result = mysql_query($query) or die(Query failed);

   /* Printing results in HTML */
 ?  
   table
   ?php
   while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
 ?
 
  tr
 ?php
   foreach ($line as $col_value) {?
   td
   ?php print $col_value;
   }?
   /td
   /tr
   ?php }
   ?
   /table

   /* Free resultset */
   ?php mysql_free_result($result);

   /* Closing connection */
  
   mysql_close($link);
   
?

George Nikoloudis

INTRACOM S.A.
Telecom Business Support Systems

19.5 km, Markopoulou Ave. Tel.:  +30 10 667 97 58
GR 19002 Athens   Fax: +30 10 667 97 97
Greece  Mob.: +30 972 03 60 06



-Original Message-
From: Nikolaos Georgiafentis [mailto:[EMAIL PROTECTED]]
Sent: Τετάρτη, 25 Σεπτεμβρίου 2002 11:33 πμ
To: Nikoloudis George ([EMAIL PROTECTED])
Cc: [EMAIL PROTECTED]
Subject: RE: Character Set Settings


Fear George,
try putting 'META HTTP-EQUIV=Content-Type 
CONTENT=text/html;charset=iso-8859-7' in the header section of your 
page. Keep me informed
At 10:54 AM 9/25/2002 +0300, you wrote:
Dear Nikos

I run the below --defult-character-set=ISO-8859-7 and when I insert into
the
database like
 insert into test values('ÄÕÏ');
when I select:
 mysql select * from test
 - ;
 +--+
 | data |
 +--+
 | åíá  |
 | ÅÍÁ  |
 | ÄÕÏ  |
 | äõï  |
 +--+
 4 rows in set (0.04 sec)

but the problem is in the Explorer pages where I get $%#$#$#


Any ideas, I work in Win200 system.

George Nikoloudis

INTRACOM S.A.
Telecom Business Support Systems

19.5 km, Markopoulou Ave. Tel.:  +30 10 667 97 58
GR 19002 Athens   Fax: +30 10 667 97 97
Greece  Mob.: +30 972 03 60 06



-Original Message-
From: Nikolaos Georgiafentis [mailto:[EMAIL PROTECTED]]
Sent: ÔåôÜñôç, 25 Óåðôåìâñßïõ 2002 10:41 ðì
To: Nikoloudis George ([EMAIL PROTECTED])
Cc: [EMAIL PROTECTED]
Subject: Re: Character Set Settings


Dear George,
I use to have problems with Greek Chars and after hundreds of hours of
testing i can assure you that the only solution is to compile Mysql using
as default char-set the Greek char-set.
Thus if your are using mysql for Linux you have to add to the .configure
parameters the following:(`--with-charset=greek' ,
'--with-extra-charset=greek').
Also if you have problems viewing greek characters from within a PHP page
maybe you have to define the correct encoding for the specific page.

At 10:09 AM 9/25/2002 +0300, you wrote:
 Dear support
 
 I am trying to write data in the database in ISO-8859-7 character set.
 My Questions are:
 1) How do I configure MySQL to support this character set?
 2) I am using PHP to get these infornation from the database. Do I have
to
 do something in my code to read teh data?
 
 
 Thenks a lot
 
 George Nikoloudis
 
 INTRACOM S.A.
 Telecom Business Support Systems
 
 19.5 km, Markopoulou Ave. Tel.:  +30 10 667 97 58
 GR 19002 Athens   Fax: +30 10 667 97 97
 Greece  Mob.: +30 972 03 60 06
 
 
 
 -
 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

Georgiafentis Nikolaos
Project Manager
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
iTEL LTD
409 Vouliagmenis Ave.
Ilioupoli, 16346
Tel: +30 10 9790050
Fax: +30 10 9790051

Georgiafentis Nikolaos
Project Manager
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
iTEL LTD
409 Vouliagmenis Ave.
Ilioupoli, 16346
Tel: +30 10 9790050
Fax: +30 10 9790051

-
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

Re: RE: Character Set Settings

[Nikolaos Georgiafentis]

Dear Gorge,
the page you have sent me is included in an other page?
If is not then try to put also all the required html tags (i.e 
HEAD,BODY etc.)
If it is then try to put the correct page encoding in the main page that 
includes the page you have sent me.
At 11:48 AM 9/25/2002 +0300, you wrote:
Dear Nikos
I did that I nothing.

I am sending you also the php script I run:
meta http-equiv=Content-Type content=text/html; charset=greek8

?php
/* Connecting, selecting database */
$link = mysql_connect(localhost, test, )
or die(Could not connect);
print Connected successfully;
mysql_select_db(mysql) or die(Could not select database);

/* Performing SQL query */
$query = SELECT * FROM test;
$result = mysql_query($query) or die(Query failed);

/* Printing results in HTML */
  ?
table
?php
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
  ?

   tr
  ?php
foreach ($line as $col_value) {?
td
?php print $col_value;
}?
/td
/tr
?php }
?
/table

/* Free resultset */
?php mysql_free_result($result);

/* Closing connection */

mysql_close($link);

?

George Nikoloudis

INTRACOM S.A.
Telecom Business Support Systems

19.5 km, Markopoulou Ave. Tel.:  +30 10 667 97 58
GR 19002 Athens   Fax: +30 10 667 97 97
Greece  Mob.: +30 972 03 60 06



-Original Message-
From: Nikolaos Georgiafentis [mailto:[EMAIL PROTECTED]]
Sent: Τετάρτη, 25 Σεπτεμβρίου 2002 11:33 πμ
To: Nikoloudis George ([EMAIL PROTECTED])
Cc: [EMAIL PROTECTED]
Subject: RE: Character Set Settings


Fear George,
try putting 'META HTTP-EQUIV=Content-Type
CONTENT=text/html;charset=iso-8859-7' in the header section of your
page. Keep me informed
At 10:54 AM 9/25/2002 +0300, you wrote:
 Dear Nikos
 
 I run the below --defult-character-set=ISO-8859-7 and when I insert into
the
 database like
  insert into test values('ÄÕÏ');
 when I select:
  mysql select * from test
  - ;
  +--+
  | data |
  +--+
  | åíá  |
  | ÅÍÁ  |
  | ÄÕÏ  |
  | äõï  |
  +--+
  4 rows in set (0.04 sec)
 
 but the problem is in the Explorer pages where I get $%#$#$#
 
 
 Any ideas, I work in Win200 system.
 
 George Nikoloudis
 
 INTRACOM S.A.
 Telecom Business Support Systems
 
 19.5 km, Markopoulou Ave. Tel.:  +30 10 667 97 58
 GR 19002 Athens   Fax: +30 10 667 97 97
 Greece  Mob.: +30 972 03 60 06
 
 
 
 -Original Message-
 From: Nikolaos Georgiafentis [mailto:[EMAIL PROTECTED]]
 Sent: ÔåôÜñôç, 25 Óåðôåìâñßïõ 2002 10:41 ðì
 To: Nikoloudis George ([EMAIL PROTECTED])
 Cc: [EMAIL PROTECTED]
 Subject: Re: Character Set Settings
 
 
 Dear George,
 I use to have problems with Greek Chars and after hundreds of hours of
 testing i can assure you that the only solution is to compile Mysql using
 as default char-set the Greek char-set.
 Thus if your are using mysql for Linux you have to add to the .configure
 parameters the following:(`--with-charset=greek' ,
 '--with-extra-charset=greek').
 Also if you have problems viewing greek characters from within a PHP page
 maybe you have to define the correct encoding for the specific page.
 
 At 10:09 AM 9/25/2002 +0300, you wrote:
  Dear support
  
  I am trying to write data in the database in ISO-8859-7 character set.
  My Questions are:
  1) How do I configure MySQL to support this character set?
  2) I am using PHP to get these infornation from the database. Do I have
to
  do something in my code to read teh data?
  
  
  Thenks a lot
  
  George Nikoloudis
  
  INTRACOM S.A.
  Telecom Business Support Systems
  
  19.5 km, Markopoulou Ave. Tel.:  +30 10 667 97 58
  GR 19002 Athens   Fax: +30 10 667 97 97
  Greece  Mob.: +30 972 03 60 06
  
  
  
  -
  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
 
 Georgiafentis Nikolaos
 Project Manager
 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
 iTEL LTD
 409 Vouliagmenis Ave.
 Ilioupoli, 16346
 Tel: +30 10 9790050
 Fax: +30 10 9790051

Georgiafentis Nikolaos
Project Manager
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
iTEL LTD
409 Vouliagmenis Ave.
Ilioupoli, 16346
Tel: +30 10 9790050
Fax: +30 10 9790051

Georgiafentis Nikolaos
Project Manager
[EMAIL PROTECTED] mailto:[EMAIL

RE: RE: Character Set Settings

[Nikoloudis George (george.nikoloudis@intracom.gr)]

Dear Nikos

The charset is ISO_8859-7 not greek8

In you system the greeks work fine?

George Nikoloudis

INTRACOM S.A.
Telecom Business Support Systems

19.5 km, Markopoulou Ave. Tel.:  +30 10 667 97 58
GR 19002 Athens   Fax: +30 10 667 97 97
Greece  Mob.: +30 972 03 60 06



-Original Message-
From: Nikolaos Georgiafentis [mailto:[EMAIL PROTECTED]]
Sent: Τετάρτη, 25 Σεπτεμβρίου 2002 12:19 μμ
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: RE: Character Set Settings


Dear Gorge,
the page you have sent me is included in an other page?
If is not then try to put also all the required html tags (i.e 
HEAD,BODY etc.)
If it is then try to put the correct page encoding in the main page that 
includes the page you have sent me.
At 11:48 AM 9/25/2002 +0300, you wrote:
Dear Nikos
I did that I nothing.

I am sending you also the php script I run:
meta http-equiv=Content-Type content=text/html; charset=greek8

?php
/* Connecting, selecting database */
$link = mysql_connect(localhost, test, )
or die(Could not connect);
print Connected successfully;
mysql_select_db(mysql) or die(Could not select database);

/* Performing SQL query */
$query = SELECT * FROM test;
$result = mysql_query($query) or die(Query failed);

/* Printing results in HTML */
  ?
table
?php
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
  ?

   tr
  ?php
foreach ($line as $col_value) {?
td
?php print $col_value;
}?
/td
/tr
?php }
?
/table

/* Free resultset */
?php mysql_free_result($result);

/* Closing connection */

mysql_close($link);

?

George Nikoloudis

INTRACOM S.A.
Telecom Business Support Systems

19.5 km, Markopoulou Ave. Tel.:  +30 10 667 97 58
GR 19002 Athens   Fax: +30 10 667 97 97
Greece  Mob.: +30 972 03 60 06



-Original Message-
From: Nikolaos Georgiafentis [mailto:[EMAIL PROTECTED]]
Sent: Τετάρτη, 25 
Σεπτεμβρίου 2002 11:33 πμ
To: Nikoloudis George ([EMAIL PROTECTED])
Cc: [EMAIL PROTECTED]
Subject: RE: Character Set Settings


Fear George,
try putting 'META HTTP-EQUIV=Content-Type
CONTENT=text/html;charset=iso-8859-7' in the header section of your
page. Keep me informed
At 10:54 AM 9/25/2002 +0300, you wrote:
 Dear Nikos
 
 I run the below --defult-character-set=ISO-8859-7 and when I insert into
the
 database like
  insert into test values('ÄÕÏ');
 when I select:
  mysql select * from test
  - ;
  +--+
  | data |
  +--+
  | åíá  |
  | ÅÍÁ  |
  | ÄÕÏ  |
  | äõï  |
  +--+
  4 rows in set (0.04 sec)
 
 but the problem is in the Explorer pages where I get $%#$#$#
 
 
 Any ideas, I work in Win200 system.
 
 George Nikoloudis
 
 INTRACOM S.A.
 Telecom Business Support Systems
 
 19.5 km, Markopoulou Ave. Tel.:  +30 10 667 97 58
 GR 19002 Athens   Fax: +30 10 667 97 97
 Greece  Mob.: +30 972 03 60 06
 
 
 
 -Original Message-
 From: Nikolaos Georgiafentis [mailto:[EMAIL PROTECTED]]
 Sent: ÔåôÜñôç, 25 
Óåðôåìâñßïõ 2002 10:41 ðì
 To: Nikoloudis George ([EMAIL PROTECTED])
 Cc: [EMAIL PROTECTED]
 Subject: Re: Character Set Settings
 
 
 Dear George,
 I use to have problems with Greek Chars and after hundreds of hours of
 testing i can assure you that the only solution is to compile Mysql using
 as default char-set the Greek char-set.
 Thus if your are using mysql for Linux you have to add to the
.configure
 parameters the following:(`--with-charset=greek' ,
 '--with-extra-charset=greek').
 Also if you have problems viewing greek characters from within a PHP page
 maybe you have to define the correct encoding for the specific page.
 
 At 10:09 AM 9/25/2002 +0300, you wrote:
  Dear support
  
  I am trying to write data in the database in ISO-8859-7 character set.
  My Questions are:
  1) How do I configure MySQL to support this character set?
  2) I am using PHP to get these infornation from the database. Do I have
to
  do something in my code to read teh data?
  
  
  Thenks a lot
  
  George Nikoloudis
  
  INTRACOM S.A.
  Telecom Business Support Systems
  
  19.5 km, Markopoulou Ave. Tel.:  +30 10 667 97 58
  GR 19002 Athens   Fax: +30 10 667 97 97
  Greece  Mob.: +30 972 03 60 06
  
  
  
  -
  Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com

Re: RE: RE: Character Set Settings

[Nikolaos Georgiafentis]

Sorry the correct charset is ISO_8859-7.
Is the problem resolved?
At 12:45 PM 9/25/2002 +0300, you wrote:
Dear Nikos

The charset is ISO_8859-7 not greek8

In you system the greeks work fine?

George Nikoloudis

INTRACOM S.A.
Telecom Business Support Systems

19.5 km, Markopoulou Ave. Tel.:  +30 10 667 97 58
GR 19002 Athens   Fax: +30 10 667 97 97
Greece  Mob.: +30 972 03 60 06



-Original Message-
From: Nikolaos Georgiafentis [mailto:[EMAIL PROTECTED]]
Sent: Τετάρτη, 25 Σεπτεμβρίου 2002 12:19 μμ
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: RE: Character Set Settings


Dear Gorge,
the page you have sent me is included in an other page?
If is not then try to put also all the required html tags (i.e
HEAD,BODY etc.)
If it is then try to put the correct page encoding in the main page that
includes the page you have sent me.
At 11:48 AM 9/25/2002 +0300, you wrote:
 Dear Nikos
 I did that I nothing.
 
 I am sending you also the php script I run:
 meta http-equiv=Content-Type content=text/html; charset=greek8
 
 ?php
 /* Connecting, selecting database */
 $link = mysql_connect(localhost, test, )
 or die(Could not connect);
 print Connected successfully;
 mysql_select_db(mysql) or die(Could not select database);
 
 /* Performing SQL query */
 $query = SELECT * FROM test;
 $result = mysql_query($query) or die(Query failed);
 
 /* Printing results in HTML */
   ?
 table
 ?php
 while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
   ?
 
tr
   ?php
 foreach ($line as $col_value) {?
 td
 ?php print $col_value;
 }?
 /td
 /tr
 ?php }
 ?
 /table
 
 /* Free resultset */
 ?php mysql_free_result($result);
 
 /* Closing connection */
 
 mysql_close($link);
 
 ?
 
 George Nikoloudis
 
 INTRACOM S.A.
 Telecom Business Support Systems
 
 19.5 km, Markopoulou Ave. Tel.:  +30 10 667 97 58
 GR 19002 Athens   Fax: +30 10 667 97 97
 Greece  Mob.: +30 972 03 60 06
 
 
 
 -Original Message-
 From: Nikolaos Georgiafentis [mailto:[EMAIL PROTECTED]]
 Sent: Τετάρτη, 25 
 Σεπτεμβρίου 2002 11:33 πμ
 To: Nikoloudis George ([EMAIL PROTECTED])
 Cc: [EMAIL PROTECTED]
 Subject: RE: Character Set Settings
 
 
 Fear George,
 try putting 'META HTTP-EQUIV=Content-Type
 CONTENT=text/html;charset=iso-8859-7' in the header section of your
 page. Keep me informed
 At 10:54 AM 9/25/2002 +0300, you wrote:
  Dear Nikos
  
  I run the below --defult-character-set=ISO-8859-7 and when I insert into
 the
  database like
   insert into test values('ÄÕÏ');
  when I select:
   mysql select * from test
   - ;
   +--+
   | data |
   +--+
   | åíá  |
   | ÅÍÁ  |
   | ÄÕÏ  |
   | äõï  |
   +--+
   4 rows in set (0.04 sec)
  
  but the problem is in the Explorer pages where I get $%#$#$#
  
  
  Any ideas, I work in Win200 system.
  
  George Nikoloudis
  
  INTRACOM S.A.
  Telecom Business Support Systems
  
  19.5 km, Markopoulou Ave. Tel.:  +30 10 667 97 58
  GR 19002 Athens   Fax: +30 10 667 97 97
  Greece  Mob.: +30 972 03 60 06
  
  
  
  -Original Message-
  From: Nikolaos Georgiafentis [mailto:[EMAIL PROTECTED]]
  Sent: ÔåôÜñôç, 25 
 Óåðôåìâñßïõ 2002 10:41 ðì
  To: Nikoloudis George ([EMAIL PROTECTED])
  Cc: [EMAIL PROTECTED]
  Subject: Re: Character Set Settings
  
  
  Dear George,
  I use to have problems with Greek Chars and after hundreds of hours of
  testing i can assure you that the only solution is to compile Mysql using
  as default char-set the Greek char-set.
  Thus if your are using mysql for Linux you have to add to the
.configure
  parameters the following:(`--with-charset=greek' ,
  '--with-extra-charset=greek').
  Also if you have problems viewing greek characters from within a PHP page
  maybe you have to define the correct encoding for the specific page.
  
  At 10:09 AM 9/25/2002 +0300, you wrote:
   Dear support
   
   I am trying to write data in the database in ISO-8859-7 character set.
   My Questions are:
   1) How do I configure MySQL to support this character set?
   2) I am using PHP to get these infornation from the database. Do I have
 to
   do something in my code to read teh data?
   
   
   Thenks a lot
   
   George Nikoloudis
   
   INTRACOM S.A.
   Telecom Business Support Systems
   
   19.5 km, Markopoulou Ave. Tel.:  +30 10 667 97 58
   GR 19002 Athens   Fax: +30 10 667 97 97
   Greece

RE: RE: RE: Character Set Settings

[Nikoloudis George (george.nikoloudis@intracom.gr)]

Nothing I did it.
I will try to install againthe PHP.
I will come back.

Thanks a lot

George Nikoloudis

INTRACOM S.A.
Telecom Business Support Systems

19.5 km, Markopoulou Ave. Tel.:  +30 10 667 97 58
GR 19002 Athens   Fax: +30 10 667 97 97
Greece  Mob.: +30 972 03 60 06



-Original Message-
From: Nikolaos Georgiafentis [mailto:[EMAIL PROTECTED]]
Sent: Τετάρτη, 25 Σεπτεμβρίου 2002 12:58 μμ
To: Nikoloudis George ([EMAIL PROTECTED])
Cc: [EMAIL PROTECTED]
Subject: Re: RE: RE: Character Set Settings


Sorry the correct charset is ISO_8859-7.
Is the problem resolved?
At 12:45 PM 9/25/2002 +0300, you wrote:
Dear Nikos

The charset is ISO_8859-7 not greek8

In you system the greeks work fine?

George Nikoloudis

INTRACOM S.A.
Telecom Business Support Systems

19.5 km, Markopoulou Ave. Tel.:  +30 10 667 97 58
GR 19002 Athens   Fax: +30 10 667 97 97
Greece  Mob.: +30 972 03 60 06



-Original Message-
From: Nikolaos Georgiafentis [mailto:[EMAIL PROTECTED]]
Sent: Τετάρτη, 25 
Σεπτεμβρίου 2002 12:19 μμ
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: RE: Character Set Settings


Dear Gorge,
the page you have sent me is included in an other page?
If is not then try to put also all the required html tags (i.e
HEAD,BODY etc.)
If it is then try to put the correct page encoding in the main page that
includes the page you have sent me.
At 11:48 AM 9/25/2002 +0300, you wrote:
 Dear Nikos
 I did that I nothing.
 
 I am sending you also the php script I run:
 meta http-equiv=Content-Type content=text/html; charset=greek8
 
 ?php
 /* Connecting, selecting database */
 $link = mysql_connect(localhost, test, )
 or die(Could not connect);
 print Connected successfully;
 mysql_select_db(mysql) or die(Could not select database);
 
 /* Performing SQL query */
 $query = SELECT * FROM test;
 $result = mysql_query($query) or die(Query failed);
 
 /* Printing results in HTML */
   ?
 table
 ?php
 while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
   ?
 
tr
   ?php
 foreach ($line as $col_value) {?
 td
 ?php print $col_value;
 }?
 /td
 /tr
 ?php }
 ?
 /table
 
 /* Free resultset */
 ?php mysql_free_result($result);
 
 /* Closing connection */
 
 mysql_close($link);
 
 ?
 
 George Nikoloudis
 
 INTRACOM S.A.
 Telecom Business Support Systems
 
 19.5 km, Markopoulou Ave. Tel.:  +30 10 667 97 58
 GR 19002 Athens   Fax: +30 10 667 97 97
 Greece  Mob.: +30 972 03 60 06
 
 
 
 -Original Message-
 From: Nikolaos Georgiafentis [mailto:[EMAIL PROTECTED]]
 Sent: Τετάρτη, 25 
 
Σεπτεμβρίου
 2002 11:33 πμ
 To: Nikoloudis George ([EMAIL PROTECTED])
 Cc: [EMAIL PROTECTED]
 Subject: RE: Character Set Settings
 
 
 Fear George,
 try putting 'META HTTP-EQUIV=Content-Type
 CONTENT=text/html;charset=iso-8859-7' in the header section of your
 page. Keep me informed
 At 10:54 AM 9/25/2002 +0300, you wrote:
  Dear Nikos
  
  I run the below --defult-character-set=ISO-8859-7 and when I insert
into
 the
  database like
   insert into test values('ÄÕÏ');
  when I select:
   mysql select * from test
   - ;
   +--+
   | data |
   +--+
   | åíá  |
   | ÅÍÁ  |
   | ÄÕÏ  |
   | äõï  |
   +--+
   4 rows in set (0.04 sec)
  
  but the problem is in the Explorer pages where I get $%#$#$#
  
  
  Any ideas, I work in Win200 system.
  
  George Nikoloudis
  
  INTRACOM S.A.
  Telecom Business Support Systems
  
  19.5 km, Markopoulou Ave. Tel.:  +30 10 667 97 58
  GR 19002 Athens   Fax: +30 10 667 97 97
  Greece  Mob.: +30 972 03 60 06
  
  
  
  -Original Message-
  From: Nikolaos Georgiafentis [mailto:[EMAIL PROTECTED]]
  Sent: ÔåôÜñôç, 25 
 
Óåðôåìâñßïõ
 2002 10:41 ðì
  To: Nikoloudis George ([EMAIL PROTECTED])
  Cc: [EMAIL PROTECTED]
  Subject: Re: Character Set Settings
  
  
  Dear George,
  I use to have problems with Greek Chars and after hundreds of hours of
  testing i can assure you that the only solution is to compile Mysql
using
  as default char-set the Greek char-set.
  Thus if your are using mysql for Linux you have to add to the
.configure
  parameters the following:(`--with-charset=greek' ,
  '--with-extra-charset=greek').
  Also if you have problems

RE: RE: RE: Character Set Settings

[Dean Harding]

Hi,

Have you tried just putting greek characters directly in the page?  That way you can 
at least find out if the browser is at fault.  Then try something like:

?= some greek characters ?

to rule out whether it's PHP.  It's probably not MySQL if you can see them when just 
using the command-line client...

Dean Harding.

 -Original Message-
 From: Nikoloudis George
 [mailto:[EMAIL PROTECTED]@intracom.gr]
 Sent: Wednesday, 25 September 2002 8:24 pm
 To: Nikolaos Georgiafentis
 Cc: [EMAIL PROTECTED]
 Subject: RE: RE: RE: Character Set Settings
 
 Nothing I did it.
 I will try to install againthe PHP.
 I will come back.
 
 Thanks a lot
 
 George Nikoloudis
 
 INTRACOM S.A.
 Telecom Business Support Systems
 
 19.5 km, Markopoulou Ave. Tel.:  +30 10 667 97 58
 GR 19002 Athens   Fax: +30 10 667 97 97
 Greece  Mob.: +30 972 03 60 06
 
 
 
 -Original Message-
 From: Nikolaos Georgiafentis [mailto:[EMAIL PROTECTED]]
 Sent: Τετάρτη, 25 Σεπτεμβρίου 2002 12:58 μμ
 To: Nikoloudis George ([EMAIL PROTECTED])
 Cc: [EMAIL PROTECTED]
 Subject: Re: RE: RE: Character Set Settings
 
 
 Sorry the correct charset is ISO_8859-7.
 Is the problem resolved?
 At 12:45 PM 9/25/2002 +0300, you wrote:
 Dear Nikos
 
 The charset is ISO_8859-7 not greek8
 
 In you system the greeks work fine?
 
 George Nikoloudis
 
 INTRACOM S.A.
 Telecom Business Support Systems
 
 19.5 km, Markopoulou Ave. Tel.:  +30 10 667 97 58
 GR 19002 Athens   Fax: +30 10 667 97 97
 Greece  Mob.: +30 972 03 60 06
 
 
 
 -Original Message-
 From: Nikolaos Georgiafentis [mailto:[EMAIL PROTECTED]]
 Sent: Τετάρτη, 25 
Σεπτεμβρίου 2002 12:19 μμ
 To: [EMAIL PROTECTED]
 Cc: [EMAIL PROTECTED]
 Subject: Re: RE: Character Set Settings
 
 
 Dear Gorge,
 the page you have sent me is included in an other page?
 If is not then try to put also all the required html tags (i.e
 HEAD,BODY etc.)
 If it is then try to put the correct page encoding in the main page that
 includes the page you have sent me.
 At 11:48 AM 9/25/2002 +0300, you wrote:
  Dear Nikos
  I did that I nothing.
  
  I am sending you also the php script I run:
  meta http-equiv=Content-Type content=text/html; charset=greek8
  
  ?php
  /* Connecting, selecting database */
  $link = mysql_connect(localhost, test, )
  or die(Could not connect);
  print Connected successfully;
  mysql_select_db(mysql) or die(Could not select database);
  
  /* Performing SQL query */
  $query = SELECT * FROM test;
  $result = mysql_query($query) or die(Query failed);
  
  /* Printing results in HTML */
?
  table
  ?php
  while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
?
  
 tr
?php
  foreach ($line as $col_value) {?
  td
  ?php print $col_value;
  }?
  /td
  /tr
  ?php }
  ?
  /table
  
  /* Free resultset */
  ?php mysql_free_result($result);
  
  /* Closing connection */
  
  mysql_close($link);
  
  ?
  
  George Nikoloudis
  
  INTRACOM S.A.
  Telecom Business Support Systems
  
  19.5 km, Markopoulou Ave. Tel.:  +30 10 667 97 58
  GR 19002 Athens   Fax: +30 10 667 97 97
  Greece  Mob.: +30 972 03 60 06
  
  
  
  -Original Message-
  From: Nikolaos Georgiafentis [mailto:[EMAIL PROTECTED]]
  Sent: Τετάρτη, 25
  
Σεπτεμβρίου
 2002 11:33 πμ
  To: Nikoloudis George ([EMAIL PROTECTED])
  Cc: [EMAIL PROTECTED]
  Subject: RE: Character Set Settings
  
  
  Fear George,
  try putting 'META HTTP-EQUIV=Content-Type
  CONTENT=text/html;charset=iso-8859-7' in the header section of your
  page. Keep me informed
  At 10:54 AM 9/25/2002 +0300, you wrote:
   Dear Nikos
   
   I run the below --defult-character-set=ISO-8859-7 and when I insert
 into
  the
   database like
insert into test values('ÄÕÏ');
   when I select:
mysql select * from test
- ;
+--+
| data |
+--+
| åíá  |
| ÅÍÁ  |
| ÄÕÏ  |
| äõï  |
+--+
4 rows in set (0.04 sec)
   
   but the problem is in the Explorer pages where I get $%#$#$#
   
   
   Any ideas, I work in Win200 system.
   
   George Nikoloudis
   
   INTRACOM S.A.
   Telecom Business Support Systems
   
   19.5 km, Markopoulou Ave. Tel.:  +30 10 667 97 58
   GR 19002 Athens   Fax: +30 10 667 97 97
   Greece  Mob.: +30 972 03

re: Re: 4.6.3 Adding a New Character Set

[Egor Egorov]

bhushan,
Wednesday, September 18, 2002, 5:32:04 PM, you wrote:

b Can anybody tell me source for getting information on 
b 4.6.3 Adding a New Character Set in MySQL.

b I read the manual, it's not clear to me.
b The steps there does not give enough information to start.

Some info you can also find in the /sql/share/charsets/README file of
the source distribution.



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com




-
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

Re: 4.6.3 Adding a New Character Set

[bhushan]

Hi,

Can anybody tell me source for getting information on 
4.6.3 Adding a New Character Set in MySQL.

I read the manual, it's not clear to me.
The steps there does not give enough information to start.


Thanks,
Bhushan.






-
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

Character set

[National Theater of Greece]

Hi.
I have installed SuSE Linux 8.0 Proffessional and the MySQL that came with
it. If anyone of you has done the same he must have realized that many of
the files are quite different than the files of MySQL that came with the
standard installation described in the maual.
My problem is that I have to change the character set to greek because all
the 'select' commands including 'order by' do not display the elements in
the correct order. The MySQL manual doesn't help me because the SuSE MySQL
deamon starts with 'rcmysql start' (instead 'mysql') and the
'--default-character-set=greek' parameter isn't doing anything...
Has anyone else faced the same problem (in any other language than english)?
I'm quite new in Linux and I may have done some other mistakes when
installing so I would be very greatfull to anyone who could help me...

Achilles


-
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

Character set

[Achilleas Maroulis]

Hi.
I have installed SuSE Linux 8.0 Proffessional and the MySQL that came with
it. If anyone of you has done the same he must have realized that many of
the files are quite different than the files of MySQL that came with the
standard installation described in the maual.
My problem is that I have to change the character set to greek because all
the 'select' commands including 'order by' do not display the elements in
the correct order. The MySQL manual doesn't help me because the SuSE MySQL
deamon starts with 'rcmysql start' (instead 'mysql') and the
'--default-character-set=greek' parameter isn't doing anything...
Has anyone else faced the same problem (in any other language than english)?
I'm quite new in Linux and I may have done some other mistakes when
installing so I would be very greatfull to anyone who could help me...

Achilles


-
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

Re: Character set

[Rafal Jank]

 Hi.
 I have installed SuSE Linux 8.0 Proffessional and the MySQL that came with
 it. If anyone of you has done the same he must have realized that many of
 the files are quite different than the files of MySQL that came with the
 standard installation described in the maual.
 My problem is that I have to change the character set to greek because all
 the 'select' commands including 'order by' do not display the elements in
 the correct order. The MySQL manual doesn't help me because the SuSE MySQL
 deamon starts with 'rcmysql start' (instead 'mysql') and the
 '--default-character-set=greek' parameter isn't doing anything...
 Has anyone else faced the same problem (in any other language than english)?
 I'm quite new in Linux and I may have done some other mistakes when
 installing so I would be very greatfull to anyone who could help me...

Put 
default-character-set=greek
in your my.cnf file (you may have to create it if it doesn't exist)

-- 
_/_/  _/_/_/  - Rafa Jank [EMAIL PROTECTED] -
 _/  _/  _/  _/   _/ Wirtualna Polska SA   http://www.wp.pl 
  _/_/_/_/  _/_/_/ul. Traugutta 115c, 80-237 Gdansk, tel/fax. (58)5215625
   _/  _/  _/ ==*  http://szukaj.wp.pl *==--

-
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

Re: Character set

[Thomas Spahni]

On Thu, 5 Sep 2002, National Theater of Greece wrote:

 Hi.
 I have installed SuSE Linux 8.0 Proffessional and the MySQL that came with
 it. If anyone of you has done the same he must have realized that many of
 the files are quite different than the files of MySQL that came with the
 standard installation described in the maual.
 My problem is that I have to change the character set to greek because all
 the 'select' commands including 'order by' do not display the elements in
 the correct order. The MySQL manual doesn't help me because the SuSE MySQL
 deamon starts with 'rcmysql start' (instead 'mysql') and the
 '--default-character-set=greek' parameter isn't doing anything...
 Has anyone else faced the same problem (in any other language than english)?
 I'm quite new in Linux and I may have done some other mistakes when
 installing so I would be very greatfull to anyone who could help me...
 
 Achilles

Achilles,

in case you have to recompile: SuSE give the arguments they used for
./configure in /usr/share/doc/packages/mysql/README.SuSE

Recompiling from source works like a charm as long as you are using the
same directory structure.

Thomas


-
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

Re: Character set

[nick gatsis]

I had the same problem with greek characters. I set
field as binary and the problem corrected.


 --- National Theater of Greece [EMAIL PROTECTED] : 
Hi.
 I have installed SuSE Linux 8.0 Proffessional and
 the MySQL that came with
 it. If anyone of you has done the same he must have
 realized that many of
 the files are quite different than the files of
 MySQL that came with the
 standard installation described in the maual.
 My problem is that I have to change the character
 set to greek because all
 the 'select' commands including 'order by' do not
 display the elements in
 the correct order. The MySQL manual doesn't help me
 because the SuSE MySQL
 deamon starts with 'rcmysql start' (instead 'mysql')
 and the
 '--default-character-set=greek' parameter isn't
 doing anything...
 Has anyone else faced the same problem (in any other
 language than english)?
 I'm quite new in Linux and I may have done some
 other mistakes when
 installing so I would be very greatfull to anyone
 who could help me...
 
 Achilles
 
 

-
 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
  


Do You Yahoo!?
   @yahoo.grhttp://www.otenet.gr

-
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

Re: Re: Character set

[Victoria Reznichenko]

Volkan,
Friday, August 09, 2002, 4:53:56 PM, you wrote:

Vy   I have already writen
Vy --default-character-set=..
Vy   sorry about that i just wrote it wrongly in my  
Vy   message.

Vyelse
Vy If i write 
Vy mysqld --default-character-set latin5
Vyit gives the error message:
Vy Can't start server: Bind on TCP/IP port:Adress
Vy already in use.

Check if you have another mysqld server running.
  http://www.mysql.com/doc/en/Starting_server.html




-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com




-
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

Re: Character set

[yýldýz]

  Hii Sinisa, 

  I have already writen 
--default-character-set=..
  sorry about that i just wrote it wrongly in my  
  message.

   If i write 
mysqld --default-character-set Latin5
   it gives the error message:
   Character set Latin5 is not an compiled character
set, and is not specified in
'usr/share/mysql/shareset/Index' 

   else
If i write 
mysqld --default-character-set latin5
   it gives the error message:
Can't start server: Bind on TCP/IP port:Adress
already in use.

   And i have also tried
  mysql set Character Set latin5 ;
  then it gives the error message 
   Unknown character set... But it is in the shared 
  folder.

   





__
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com

-
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

Re: Re: MySQL bug? - problems with character-set

[Victoria Reznichenko]

Andis,
Friday, August 02, 2002, 9:07:54 AM, you wrote:

A It's just a simple example, because I don't want send latvian-specific
A symbols. This problem occurs with latvian-specific symbols only.
A Configuration file I cheked some 4-5 times. I'm confused now.

To convert correctly from upper case to lower case and vice versa you should specify 
proper character set.

If you look into *.conf files in the charsets dir you can see 4 arrays there. Two of 
them,
to_lower[] and to_upper[], contain the lowercase and uppercase
characters corresponding to each member of the character set.

What character set do you use in MySQL? And what character set is used for Latvian 
language?




-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com




-
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

Re: Re: MySQL bug? - problems with character-set

[Andis]

I created character-set myself. Here, in Latvia, we use windows-1257.
Problem is, when I use MySQL under Linux, conversation occurs better. Under
windows98 I have problems as I wrote before. Cheracter-set I created myself,
because included isn't correct.

Andis



- Original Message -
From: Victoria Reznichenko [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, August 02, 2002 1:05 PM
Subject: Re: Re: MySQL bug? - problems with character-set


 Andis,
 Friday, August 02, 2002, 9:07:54 AM, you wrote:

 A It's just a simple example, because I don't want send latvian-specific
 A symbols. This problem occurs with latvian-specific symbols only.
 A Configuration file I cheked some 4-5 times. I'm confused now.

 To convert correctly from upper case to lower case and vice versa you
should specify proper character set.

 If you look into *.conf files in the charsets dir you can see 4 arrays
there. Two of them,
 to_lower[] and to_upper[], contain the lowercase and uppercase
 characters corresponding to each member of the character set.

 What character set do you use in MySQL? And what character set is used for
Latvian language?




 --
 For technical support contracts, goto https://order.mysql.com/?ref=ensita
 This email is sponsored by Ensita.net http://www.ensita.net/
__  ___ ___   __
   /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
  / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
 /_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
___/   www.mysql.com




 -
 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

Re: Re: Re: MySQL bug? - problems with character-set

[Victoria Reznichenko]

Andis,
Friday, August 02, 2002, 1:57:12 PM, you wrote:

A I created character-set myself. Here, in Latvia, we use windows-1257.
A Problem is, when I use MySQL under Linux, conversation occurs better. Under
A windows98 I have problems as I wrote before. Cheracter-set I created myself,
A because included isn't correct.

Seems, your to_lower[] array is not correct. Unfortunately, I don't
know Latvian language and can't tell you what is wrong :(

You say that included character set is not correct. Do you mean
cp1257 ? If so, can you explain what is wrong with character set?
Can you provide your own character set with explanation of changes
that you did?




-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com




-
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

Re: Re: Re: MySQL bug? - problems with character-set latvian.conf [1/3]

[Andis]

From: Andis [EMAIL PROTECTED]
To: [EMAIL PROTECTED],
	Victoria Reznichenko [EMAIL PROTECTED]
References: 001d01c2394e$85803740$[EMAIL PROTECTED] [EMAIL PROTECTED] 003601c239ea$f0f7d720$[EMAIL PROTECTED] [EMAIL PROTECTED] 001001c23a13$5ba93280$[EMAIL PROTECTED]   Victoria Reznichenko [EMAIL PROTECTED] [EMAIL PROTECTED]
Subject: Re: Re: Re: MySQL bug? - problems with character-set
Date: Fri, 2 Aug 2002 17:57:53 +0300
MIME-Version: 1.0
Content-Type: multipart/mixed;
	boundary==_NextPart_000_002C_01C23A4E.20042D80
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2600.
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.

This is a multi-part message in MIME format.

--=_NextPart_000_002C_01C23A4E.20042D80
Content-Type: text/plain;
	charset=iso-8859-4
Content-Transfer-Encoding: 7bit

Here is my conf file. Also I send my Excel file, where with yellow is marked
symbols which is used in Latvian language. Of course, also we use such
symbols as W, X, Y etc. This means, for right sorting all symbols with ascii
code from 32 to 255 better is include in character-set definition. I hope,
that you'll see xls file as I see :)).

Andis

- Original Message -
From: Victoria Reznichenko [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, August 02, 2002 3:41 PM
Subject: Re: Re: Re: MySQL bug? - problems with character-set


 Andis,
 Friday, August 02, 2002, 1:57:12 PM, you wrote:

 A I created character-set myself. Here, in Latvia, we use windows-1257.
 A Problem is, when I use MySQL under Linux, conversation occurs better.
Under
 A windows98 I have problems as I wrote before. Cheracter-set I created
myself,
 A because included isn't correct.

 Seems, your to_lower[] array is not correct. Unfortunately, I don't
 know Latvian language and can't tell you what is wrong :(

 You say that included character set is not correct. Do you mean
 cp1257 ? If so, can you explain what is wrong with character set?
 Can you provide your own character set with explanation of changes
 that you did?




 --
 For technical support contracts, goto https://order.mysql.com/?ref=ensita
 This email is sponsored by Ensita.net http://www.ensita.net/
__  ___ ___   __
   /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
  / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
 /_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
___/   www.mysql.com




 -
 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



--=_NextPart_000_002C_01C23A4E.20042D80
Content-Type: application/octet-stream;
	name=latvian.conf
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment;
	filename=latvian.conf

# Configuration file for the latvian character set.
# Created for case-sensitive record search=0A=
# Created accord with windows-1257 (iso-8859-4) codepage=0A=
# Created by Andis Grasis  Rihards Grasis=0D e-mail:[EMAIL PROTECTED]=0A=

# The ctype array must have 257 elements.
  00
  20  20  20  20  20  20  20  20  20  28  28  28  28  28  20  20
  20  20  20  20  20  20  20  20  20  20  20  20  20  20  20  20
  48  10  10  10  10  10  10  10  10  10  10  10  10  10  10  10
  84  84  84  84  84  84  84  84  84  84  10  10  10  10  10  10
  10  81  81  81  81  81  81  01  01  01  01  01  01  01  01  01
  01  01  01  01  01  01  01  01  01  01  01  10  10  10  10  10
  10  82  82  82  82  82  82  02  02  02  02  02  02  02  02  02
  02  02  02  02  02  02  02  02  02  02  02  10  10  10  10  20
  01  20  10  20  10  10  00  00  20  10  20  10  20  10  10  10
  20  10  10  10  10  10  10  10  20  00  20  10  20  10  10  20
  48  20  10  10  10  20  10  10  10  10  01  10  10  10  10  01
  10  10  10  10  10  10  10  10  10  10  02  10  10  10  10  02
  01  01  01  01  01  01  01  01  01  01  01  01  01  01  01  01
  01  01  01  01  01  01  01  10  01  01  01  01  01  01  01  02
  02  02  02  02  02  02  02  02  02  02  02  02  02  02  02  02
  02  02  02  02  02  02  02  10  02  02  02  02  02  02  02  10

# The to_lower array must have 256 elements.
  00  01  02  03  04  05  06  07  08  09  0A  0B  0C  0D  0E  0F
  10  11  12  13  14  15  16  17  18  19  1A  1B  1C  1D  1E  1F
  20  21  22  23  24  25  26  27  28  29  2A  2B  2C  2D  2E  2F
  30  31  32  33  34  35  36  37  38  39  3A  3B  3C  3D  3E  3F
  40  61  62  63  64  65  66  67  68  69  6A  6B  6C  6D  6E  6F
  70  71  72  73  74  75  76  77  78  79  7A  5B  5C  5D  5E  5F
  60  61  62  63  64  65  66  67  68  69  6A  6B  6C  6D  6E  6F
  70  71  72  73  74  75  76  77  78  79  7A  7B  7C  7D  7E  7F
  80  81  82  83  84  85  86  87  88  89  8A  8B  8C  8D  8E  8F
  90  91  92  93  94  95  96  97  98  99  9A

MySQL bug? - problems with character-set

[Andis Grasis]

Hi!

I tested MySQL 3.23.51 under Windows and 3.23.49 under Linux RedHat 7.3 with
such SQL:

select lcase('HERE I TIPED IN SPECIFIC MY LANGUAGE CHARACTERS')

and recieved different results (of course, I used same config file with
case-sensitive configuration).
Result under Linux looks better, under window - wrong, because result
contain lower-case and upper-case symbols together
It's loks like this:'HErE I tIPED MY LaNGUaGE CHaraCtERS'

Now I feel confused, hov I can test, is my conf file.

Andis Grasis



-
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

Re: MySQL bug? - problems with character-set

[Andis]

Hi!

It's just a simple example, because I don't want send latvian-specific
symbols. This problem occurs with latvian-specific symbols only.
Configuration file I cheked some 4-5 times. I'm confused now.

Regards from Latvia!

Andis Grasis

- Original Message -
From: Victoria Reznichenko [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, August 01, 2002 4:41 PM
Subject: Re: MySQL bug? - problems with character-set


 Andis,
 Thursday, August 01, 2002, 2:28:12 PM, you wrote:

 AG I tested MySQL 3.23.51 under Windows and 3.23.49 under Linux RedHat
7.3 with
 AG such SQL:

 AG select lcase('HERE I TIPED IN SPECIFIC MY LANGUAGE CHARACTERS')

 AG and recieved different results (of course, I used same config file
with
 AG case-sensitive configuration).
 AG Result under Linux looks better, under window - wrong, because result
 AG contain lower-case and upper-case symbols together
 AG It's loks like this:'HErE I tIPED MY LaNGUaGE CHaraCtERS'
 AG Now I feel confused, hov I can test, is my conf file.

 Strange ..
 on my w2k and RedHat 7.1 box I got correct results:

 mysql select lcase('HERE I TIPED IN SPECIFIC MY LANGUAGE CHARACTERS');
 +--+
 | lcase('HERE I TIPED IN SPECIFIC MY LANGUAGE CHARACTERS') |
 +--+
 | here i tiped in specific my language characters  |
 +--+
 1 row in set (0.00 sec)


 What Windows do you use? How did you install MySQL from binary or from
source?

 --
 For technical support contracts, goto https://order.mysql.com/?ref=ensita
 This email is sponsored by Ensita.net http://www.ensita.net/
__  ___ ___   __
   /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
  / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
 /_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
___/   www.mysql.com




 -
 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

Re: Czech complex character set

[MrQuinn]

  Hi,
 
  I would like to get the Chech complex character set.
  Where can I find it?
 
  Thanks,
  Daniel
 
  SQL
 


 If you need a Windows ASCII dump, is little lower.

 http://pisma.webz.cz/  is link for download some czech fonts -
 (I think, that is already needed too for right mapping)

 MrQuinn

 1 

 2 
 3 
 4 
 5 
 6 
 7 
 8 
 9  
 10 
 
 11
 12
 13 
 
 14 
 15 
 16 
 17 
 18 
 19 
 20 
 21 
 22 
 23 
 24 
 25 
 26 
 27 
 28 
 29 
 30 
 31 
 32
 33 !
 34 
 35 #
 36 $
 37 %
 38 
 39
 40 (
 41 )
 42 *
 43 +
 44 ,
 45 -
 46 .
 47 /
 48 0
 49 1
 50 2
 51 3
 52 4
 53 5
 54 6
 55 7
 56 8
 57 9
 58 :
 59 ;
 60 
 61 =
 62 
 63 ?
 64 @
 65 A
 66 B
 67 C
 68 D
 69 E
 70 F
 71 G
 72 H
 73 I
 74 J
 75 K
 76 L
 77 M
 78 N
 79 O
 80 P
 81 Q
 82 R
 83 S
 84 T
 85 U
 86 V
 87 W
 88 X
 89 Y
 90 Z
 91 [
 92 \
 93 ]
 94 ^
 95 _
 96 `
 97 a
 98 b
 99 c
 100 d
 101 e
 102 f
 103 g
 104 h
 105 i
 106 j
 107 k
 108 l
 109 m
 110 n
 111 o
 112 p
 113 q
 114 r
 115 s
 116 t
 117 u
 118 v
 119 w
 120 x
 121 y
 122 z
 123 {
 124 |
 125 }
 126 ~
 127 
 128 ?
 129 
 130 ,
 131 f
 132 
 133 .
 134 ?
 135 ?
 136 ^
 137 ?
 138 S
 139 
 140 S
 141 T
 142 Z
 143 Z
 144 
 145 '
 146 '
 147 
 148 
 149 .
 150 -
 151 -
 152 ~
 153 T
 154 s
 155 
 156 s
 157 t
 158 z
 159 z
 160
 161 ?
 162 ?
 163 L
 164 ¤
 165 A
 166 ¦
 167 §
 168 ¨
 169 ©
 170 S
 171 «
 172 ¬
 173 ­
 174 ®
 175 Z
 176 °
 177 ±
 178 ?
 179 l
 180 ´
 181 µ
 182 ¶
 183 ·
 184 ¸
 185 a
 186 s
 187 »
 188 L
 189 ?
 190 l
 191 z
 192 R
 193 Á
 194 Â
 195 A
 196 Ä
 197 L
 198 C
 199 Ç
 200 C
 201 É
 202 E
 203 Ë
 204 E
 205 Í
 206 Î
 207 D
 208 D
 209 N
 210 N
 211 Ó
 212 Ô
 213 O
 214 Ö
 215 ×
 216 R
 217 U
 218 Ú
 219 U
 220 Ü
 221 Ý
 222 T
 223 ß
 224 r
 225 á
 226 â
 227 a
 228 ä
 229 l
 230 c
 231 ç
 232 c
 233 é
 234 e
 235 ë
 236 e
 237 í
 238 î
 239 d
 240 d
 241 n
 242 n
 243 ó
 244 ô
 245 o
 246 ö
 247 ÷
 248 r
 249 u
 250 ú
 251 u
 252 ü
 253 ý
 254 t
 255 ?




-
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

Czech complex character set

[Daniel Kiss]

Hi,

I would like to get the Chech complex character set.
Where can I find it?

Thanks,
Daniel

SQL


-
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

The Character Set Used for Data and Sorting

Hello, MySQLman!

I've got a question.

I've installed standart MySQL binaries which are compiled with  
--with-extra-charsets=complex.

The fact that I speak Russian means necessity for using --default-character-set 
koi8_ru (I need it for order by construction).

I've red chapter in MySQL manual called 4.6.1 The Character Set Used for Data and 
Sorting and I've made an attempt to reconfigure special mysql files for setting 
koi8_ru as a --default-character-set without recompiling or compiling it but I 
failed... 

Checking all the paths, I edited /etc/my.cnf in such a way

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
 
[mysql.server]
user=mysql
basedir=/var/lib
character-sets-dir=/usr/share/mysql/charsets
default-character-set=koi8_ru

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

But it had no result... The sorting order was not changed.

There is a koi8_ru.conf in /usr/share/mysql/charsets

What to do?
Compile with ./configure --with-charset=koi8_ru line?
Anything else?

-
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

Re: 0xADA1 in ujis character set

[Warren Pollans]

Neglected to mention the version (changing is not an option - sorry)

Ver 11.15 Distrib 3.23.43, for sgi-irix6.5 (mips)  -- (from mysql -V)


On Wed, 22 May 2002 15:43:31 +
Warren Pollans [EMAIL PROTECTED] wrote:

 A colleague who is connecting to mysqld started as /u/local/mysql/bin/safe_mysqld 
--user=mysql --safe-show-database --default-character-set=ujis -O 
wait_timeout=$WAITTIMEOUT -O max_connections=$MAXCONNECTIONS  has encountered the 
following problem:
 
 
 We could not add data which contains 0xADA1 (2 byte char that shows circled '1').  
The char seemed to be stored as '?' into the table.
 
 
 Any ideas about what the problem is? Or perhaps the appropriate forum in which to 
ask this question?
 
 Thanks,
 
 Warren
 
 -
 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

0xADA1 in ujis character set

[Warren Pollans]

A colleague who is connecting to mysqld started as /u/local/mysql/bin/safe_mysqld 
--user=mysql --safe-show-database --default-character-set=ujis -O 
wait_timeout=$WAITTIMEOUT -O max_connections=$MAXCONNECTIONS  has encountered the 
following problem:


We could not add data which contains 0xADA1 (2 byte char that shows circled '1').  
The char seemed to be stored as '?' into the table.


Any ideas about what the problem is? Or perhaps the appropriate forum in which to ask 
this question?

Thanks,

Warren

-
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

Problems with Greek character set

[Nikolaos Georgiafentis]

Hi to all,
I am using MySQL Version 4.0.1 and some of my problems are:
1) Full text search operators does not work correctly
2) The * operator does not work at all
2) Some Greek chars are returned erroneusly by the LIKE statement
3) There is not an Exact Phrase operator
4) Stressed chars are considered different chars from the corresponding 
not stressed chars
e.t.c
Has anybody experienced similar problems? Any Ideas?
P.S I made an extensive search threw the List and i found that some members 
had in the past similar problems:
1) Achilleas Mantzios
2) Nikos Balanis
3) Kostas Assimakopoulos
4) Boril Yonchev
If they are still members i am begging them for help

Georgiafentis Nikolaos


-
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

RE: Using multi-byte character set

[zlab1]

Hi,
I'm a visual foxpro programmer:

-Original Message-
From: ÅÇ´f¼Ù (Borus.Kung) [mailto:[EMAIL PROTECTED]] 
Sent: Monday, April 29, 2002 10:00
To: [EMAIL PROTECTED]
Subject: Using multi-byte character set


 Hi,

 I am using double byte character set  (big5) under mandrake linux with
MySQL  everything seemed ok after building the DB and tables  after some
time of testing I found some characters cannot be inserted, like those
characters include the back slash '\'. it was simply disappeared as
MySQL treat it as an invalid escape sequence. I can tackle the problem
to add another back slash to the string when I am doing sth using C API.
e.g. try to insert 1234\po, then I modify the string to 1234\\po
then 1234\po can be retrieved from DB. But it seemed difficult to do
using ODBC since I am using ASP and VB for the front end.

So I am searching for a one time solution for the problem.

Is it necesary for me to add big5 to the character set?
but I don't need the to sort any double byte character field.

 what should I do?

 thanks for reading

 Borus

--

It require you to convert all string before talking with ODBC in you
programming langauge.
If you got a better idea, pleae let me know.


-
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

Using multi-byte character set

[(Borus.Kung)]

Hi,

I am using double byte character set  (big5) under mandrake linux with MySQL
everything seemed ok after building the DB and tables
after some time of testing
I found some characters cannot be inserted, like those characters include
the
back slash '\'. it was simply disappeared as MySQL treat it as an invalid
escape sequence.
I can tackle the problem to add another back slash to the string
when I am doing sth using C API.
e.g. try to insert 1234\po, then I modify the string to 1234\\po
then 1234\po can be retrieved from DB.
But it seemed difficult to do using ODBC since I am using ASP and VB for
the front end.

So I am searching for a one time solution for the problem.

Is it necesary for me to add big5 to the character set?
but I don't need the to sort any double byte character field.

what should I do?

thanks for reading

Borus

-
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

Using multi-byte character set

[(Borus.Kung)]

 Hi,

 I am using double byte character set  (big5) under mandrake linux with
MySQL
 everything seemed ok after building the DB and tables
 after some time of testing
I found some characters cannot be inserted, like those characters include
the
back slash '\'. it was simply disappeared as MySQL treat it as an invalid
escape sequence.
I can tackle the problem to add another back slash to the string
when I am doing sth using C API.
e.g. try to insert 1234\po, then I modify the string to 1234\\po
then 1234\po can be retrieved from DB.
But it seemed difficult to do using ODBC since I am using ASP and VB for
the front end.

So I am searching for a one time solution for the problem.

Is it necesary for me to add big5 to the character set?
but I don't need the to sort any double byte character field.

 what should I do?

 thanks for reading

 Borus


-
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

Determining character set from table data

[Matt Culbreth \(EIDMySql support\)]

Hello,

I am wondering if there is any way to determine the character set used for
data in a table.

For example, a single database has 10 tables, six with 'latin1' characters,
two with 'cp1251' characters, and two with 'greek' characters.  The
character_set variable is set to 'latin1' on this database because most of
the data is in the latin1 character set.

However, the client programs will want to display the data from the
non-latin1 tables correctly when they do a SQL query.  Is there a way to
determine the type of
character used for data in a table apart from the character_set variable?

Thanks,

Matt Culbreth




-
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

How can I change my default character set without ./configure??

[Gokce AKKAYA]

I have a table within turkish characters. 
I know which set I must use: latin5
But I couldn' t set it.
 
Thanks

SQL,Sql,sql

Edakom Internet Sorumlusu
  Gokce Akkaya



-
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

Re: How can I change my default character set without ./configure??

[Egor Egorov]

Gokce,
Friday, April 19, 2002, 12:51:34 PM, you wrote:

GA I have a table within turkish characters. 
GA I know which set I must use: latin5
GA But I couldn' t set it.

Run mysqld with --default-character-set=latin5 option or edit my.cnf.
Look at:
 http://www.mysql.com/doc/C/h/Character_sets.html

GA Thanks
GA Edakom Internet Sorumlusu
GA   Gokce Akkaya



-- 
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com



-
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

swe7 character set - strange mappings?

[Philip Semanchuk]

Hi everyone,
I am trying to understand what's going on here and I hope you can help me.
The swe7 characters set in swe7.conf has some really strange mappings in it.
For instance, the to_upper array maps ASCII 0x7E (a tilde) to 0x5E (a hat
aka Ctrl character). Why doesn't a tilde remain a tilde?

Stranger still is the entry in the sort_order array that maps tilde (0x7E)
to Y (0x59). And worst of all, the last letters in the Swedish alphabet (ä,
å and ö == 0xE4, 0xE5 and 0xF6) map to themselves which means that MySQL
sorts them case sensitively while the rest of the alphabet is sorted
case-INsensitively. Similar problems are present in the to_upper and
to_lower arrays so that lower('Ö') (e.g.) returns a capital letter.

I realize that I can make my own character set and I will do so in order to
fix the problems I am seeing. But first I want to make sure that the
problems I describe above are indeed problems due to a buggy character set
and not user error on my part. 

There's a good reference to the ISO-8859 character set that Swedish uses
here:
http://czyborra.com/charsets/iso8859.html#ISO-8859-1

I am using version 3.23.41.

Thanks in advance
Philip

filter fodder: sql query

-
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

RE: swe7 character set - strange mappings?

[savaidis]

Will you never put your files on the net? If so, what will you expect to
find at the remote server? Your character set?
IMO forget character mapping and use BINARY option at fields creation,
usally the contains will be upercase or lowercase, not both. The only
exeption I can think is to index - or search- a text file.

Makis


 -Original Message-
 From: Philip Semanchuk [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 02, 2002 7:21 PM
 To: [EMAIL PROTECTED]
 Cc: 'Ken Menzel'; savaidis
 Subject: swe7 character set - strange mappings?


 Hi everyone,
 I am trying to understand what's going on here and I hope you can help me.
 The swe7 characters set in swe7.conf has some really strange
 mappings in it.
 For instance, the to_upper array maps ASCII 0x7E (a tilde) to
 0x5E (a hat
 aka Ctrl character). Why doesn't a tilde remain a tilde?

 Stranger still is the entry in the sort_order array that maps tilde (0x7E)
 to Y (0x59). And worst of all, the last letters in the Swedish
 alphabet (ä,
 å and ö == 0xE4, 0xE5 and 0xF6) map to themselves which means that MySQL
 sorts them case sensitively while the rest of the alphabet is sorted
 case-INsensitively. Similar problems are present in the to_upper and
 to_lower arrays so that lower('Ö') (e.g.) returns a capital letter.

 I realize that I can make my own character set and I will do so
 in order to
 fix the problems I am seeing. But first I want to make sure that the
 problems I describe above are indeed problems due to a buggy character set
 and not user error on my part.

 There's a good reference to the ISO-8859 character set that Swedish uses
 here:
 http://czyborra.com/charsets/iso8859.html#ISO-8859-1

 I am using version 3.23.41.

 Thanks in advance
 Philip

 filter fodder: sql query


-
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

Character Set Problem

[[EMAIL PROTECTED]]

I use mysql  php. I created a table.. I entered some record. I want to
order by name as asc. But I have turkish character like ,..
 
How can I set turkish character to mysql?
 
Thanks..

Edakom Internet Sorumlusu
  Gokce Akkaya


-
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

Character Set Problem

[Victoria Reznichenko]

admin,
Friday, March 29, 2002, 4:13:26 PM, you wrote:

aect I use mysql  php. I created a table.. I entered some record. I want to
aect order by name as asc. But I have turkish character like ,..
aect How can I set turkish character to mysql?
 
You should set latin5 character set: run mysqld with
--default-character-set=latin5 option.

aect Thanks..
aect Edakom Internet Sorumlusu
aect   Gokce Akkaya




-- 
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com




-
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

Re: Character Set Problem

[Ken Menzel]

Hi,
  As I understand it Turkish has some unique features.  There is no
current turkish character set in the source tree.  I am not sure if
anyone has one.   You could look at the other character sets and pick
on that may also work.  These can be found in the source
./sql/share/charsets.  There is information on adding a charset in the
manual
http://www.mysql.com/doc/A/d/Adding_character_set.html
and in Leon Atkinsen's book 'Core MySQL'.

If you decide to make a turkish charset please submit the results so
that it can be added.  Sounds like it might be fun!

I hope this helps,
Ken
- Original Message -
From: [EMAIL PROTECTED] [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, March 29, 2002 9:13 AM
Subject: Character Set Problem


 I use mysql  php. I created a table.. I entered some record. I want
to
 order by name as asc. But I have turkish character like ,..

 How can I set turkish character to mysql?

 Thanks..

 Edakom Internet Sorumlusu
   Gokce Akkaya


 
-
 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

Re: Character Set Problem

[Ken Menzel]

Victor is right,  latin5 is for turkish,  it's commented at the top of
the character set!
Ken
- Original Message -
From: Victoria Reznichenko [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, March 29, 2002 9:26 AM
Subject: Character Set Problem


 admin,
 Friday, March 29, 2002, 4:13:26 PM, you wrote:

 aect I use mysql  php. I created a table.. I entered some record.
I want to
 aect order by name as asc. But I have turkish character like ,..
 aect How can I set turkish character to mysql?

 You should set latin5 character set: run mysqld with
 --default-character-set=latin5 option.

 aect Thanks..
 aect Edakom Internet Sorumlusu
 aect   Gokce Akkaya




 --
 For technical support contracts, goto https://order.mysql.com/
 This email is sponsored by Ensita.net http://www.ensita.net/
__  ___ ___   __
   /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
  / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
 /_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
___/   www.mysql.com




 
-
 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

SET CHARACTER SET cp1251_koi8 mediumtext problem?

[Dmitry Grigoryev]

Hello

I have followed problem:

Table:
CREATE TABLE test (
field1 mediumtext
);

Insert:
INSERT INTO test VALUES ('222(100 Kb of '2')222');

Select1:
SELECT field1 FROM test;
OK. I get 100 Kb of '2'.

Select2:
SET CHARACTER SET cp1251_koi8;
SELECT field1 FROM test;
??? I get only 34465 byte.

I use mysql 3.23.33, 4.0.0-alpha on FreeBSD 4.3, 4.4.

If I use text instead mediumtext Select2 work correctly. But I use string 65 Kb.
If I use longtext, longblob or mediumblob problem repeat.

Can I use long string with SET CHARACTER SET cp1251_koi8 option?

---
Dmitry Grigoryev


-
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

Character Set Problem in MySQL!

[[EMAIL PROTECTED]]

Actually I hadn' t this kind of problem. But now I can' t display turkish
characters in mysql queries.
Can anyone help me?

Edakom Internet Sorumlusu
  Gokce Akkaya


-
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

Re: adding messages and a character set for shift-jis

[Joel Rees]

Michael Widenius wrote:


  "Joel" == Joel Rees [EMAIL PROTECTED] writes:

 Joel But comp_err doesn't seem to be in the win32 distribution. So I am
thinking,
 Joel I should be able to load mysql into openBSD and do the conversion
there. Or
 Joel is the comp_err tool available for MSWindows?

 Sorry for the delayed response.

No problem. Things aren't going very fast here, either. Higher priority
projects came in, so this one is on back burner #3.

 Yes, you can do the conversion on openBSD.

Great! Thanks.

Will I need to download something in addition to the standard source
distribution?

 We will look into adding a
 separate windows distribution of some common tools we use to build and
 maintain the MySQL distributions.  Miguel, could you please put this
 on your todo ?

No, wait! I _want_ an excuse to do this on openBSD.

;-)

Of course, my manager would think she would be happy about the MSWindows
tools. :-(

Joel Rees
Alps Giken Kansai Systems Develoment
Suita, Osaka






-
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

Wrong sorting order using cp1257 character set.

[kestas]

Description:
  There are a few errors in characters sorting order 
  in sql/share/charsets/cp1257.conf file.

  Characters 0xE0 0x5A 0x7A 0xDE 0xFE are treated equaly.
  But accoding Lithuanian standart LST 1285:1993 (if you interested :)
  character 0xE0 should be between 0x61 (a) and 0x62 (b),
  and after 0x5A (Z), 0x7A (z)  should go 0xDE, 0xFE.
  

Fix:

--- sql/share/charsets/cp1257.conf.sv   Wed Feb 27 12:35:52 2002
+++ sql/share/charsets/cp1257.conf  Wed Feb 27 12:36:46 2002
@@ -61,14 +61,14 @@
   20  21  22  23  24  25  26  27  28  29  2A  2B  2C  2D  2E  2F
   30  31  32  33  34  35  36  37  38  39  3A  3B  3C  3D  3E  3F
   40  41  43  44  46  47  4A  4B  4C  4D  50  51  52  53  54  55
-  56  57  58  59  5B  5C  5F  60  61  4E  FF  62  63  64  65  66
-  67  41  43  44  46  47  4A  4B  4C  4D  50  51  52  53  54  55
-  56  57  58  59  5B  5C  5F  60  61  4E  FF  68  69  6A  6B  FF
+  56  57  58  59  5B  5C  5F  60  61  4E  62  64  65  66  67  68
+  69  41  43  44  46  47  4A  4B  4C  4D  50  51  52  53  54  55
+  56  57  58  59  5B  5C  5F  60  61  4E  62  6A  6B  6C  6D  FF
   FF  FF  FF  FF  FF  FF  FF  FF  FF  FF  FF  FF  FF  FF  FF  FF
   FF  FF  FF  FF  FF  FF  FF  FF  FF  FF  FF  FF  FF  FF  FF  FF
   FF  FF  FF  FF  FF  FF  FF  FF  FF  FF  FF  FF  FF  FF  FF  FF
   FF  FF  FF  FF  FF  FF  FF  FF  FF  FF  FF  FF  FF  FF  FF  FF
   42  4F  FF  FF  FF  FF  48  FF  45  FF  FF  49  FF  FF  FF  FF
-  5A  FF  FF  FF  FF  FF  FF  FF  5E  FF  FF  5D  FF  FF  FF  FF
-  FF  4F  FF  FF  FF  FF  48  FF  45  FF  FF  49  FF  FF  FF  FF
-  5A  FF  FF  FF  FF  FF  FF  FF  5E  FF  FF  5D  FF  FF  FF  FF
+  5A  FF  FF  FF  FF  FF  FF  FF  5E  FF  FF  5D  FF  FF  63  FF
+  42  4F  FF  FF  FF  FF  48  FF  45  FF  FF  49  FF  FF  FF  FF
+  5A  FF  FF  FF  FF  FF  FF  FF  5E  FF  FF  5D  FF  FF  63  FF

 Here I also put characters: { | } ~ ... after
 0xDE, 0xFE which are last alphabet characters. 
 It's more acceptable I think.
 

Submitter-Id:  
Originator:Kestas
Organization:
MySQL support: none
Synopsis:  
Severity:  non-critical
Priority:  low
Category:  mysql
Class: change-request
Release:   mysql-3.23.49 (Source distribution)

-
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

character set

[Egor Egorov]

Michal,
Wednesday, February 27, 2002, 11:41:14 AM, you wrote:

MD Hello,

MD is possible to change encoding (character set) while conecting to
MD mysql from php ?? (In postgre is SET client_encoding = 'latin2').

Character set is set when mysqld is started. If you want to use
different character sets you should to restart, or start another
instance of mysqld.

MD Thank you.
MD Lampa aka Michal





-- 
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com



-
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

Re: Wrong sorting order using cp1257 character set.

[Sinisa Milivojevic]

[EMAIL PROTECTED] writes:
 Description:
   There are a few errors in characters sorting order 
   in sql/share/charsets/cp1257.conf file.
 
   Characters 0xE0 0x5A 0x7A 0xDE 0xFE are treated equaly.
   But accoding Lithuanian standart LST 1285:1993 (if you interested :)
   character 0xE0 should be between 0x61 (a) and 0x62 (b),
   and after 0x5A (Z), 0x7A (z)  should go 0xDE, 0xFE.
   
   

Thanks for your contribution.

-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Fulltime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   ___/   www.mysql.com


-
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

problems with default-character-set=cp1251

Hi.
I use mysql 3.26.47, established on Windows 2000 Server Russian.
After I set property - default-character-set = cp1251, web-server on a
beginning to give out a massage - File ' c:\mysql \\ share\charsets
\?.conf ' not found (Errcode: 2) Character set ' .) 14 'is not a
compiled character set and is not specified in the' c:\mysql \\ share\charsets\Index ' 
file   
If to set default-character-set = latin1, all ok. But I for correct
sorting need cp1251. What it is necessary to make? 

It is my file my.ini from the catalogue winnt

# Example mysql config file.
# Copy this file to c:\my.cnf to set global options
# 
# One can use all long options that the program supports.
# Run the program with --help to get a list of available options

# This will be passed to all mysql clients
[client]
#password=my_password
port=3306
#socket=MySQL

# Here is entries for some specific programs
# The following values assume you have at least 32M ram

# The MySQL server
[mysqld]
port=3306
#socket=MySQL
skip-locking
character-sets-dir=c:/server/usr/mysql/share/charsets/
default-character-set=cp1251
set-variable = key_buffer=16M
set-variable = max_allowed_packet=1M
set-variable = thread_stack=128K
set-variable = flush_time=1800

# Uncomment the following rows if you move the MySQL distribution to another
# location
basedir = c:/server/usr/mysql/
datadir =C:/server/usr/mysql/data

# Uncomment the following rows if you are using InnoDB tables
# Create the directories ibdata and iblogs before to start the server.
# If necessary, modify the size of the files

#innodb_data_file_path = ibdata1:200M
#innodb_data_home_dir = c:\ibdata
#set-variable = innodb_mirrored_log_groups=1
#innodb_log_group_home_dir = c:\iblogs
#set-variable = innodb_log_files_in_group=3
#set-variable = innodb_log_file_size=30M
#set-variable = innodb_log_buffer_size=8M
#innodb_flush_log_at_trx_commit=1
#innodb_log_arch_dir = c:\iblogs
#innodb_log_archive=0
#set-variable = innodb_buffer_pool_size=80M
#set-variable=lower_case_table_names =0
#set-variable = innodb_additional_mem_pool_size=10M
#set-variable = innodb_file_io_threads=4
#set-variable = innodb_lock_wait_timeout=50

# Uncomment the following row if you are using a Max server and you don't want the
# InnoDb tables

#skip-innodb

[mysqldump]
quick
set-variable = max_allowed_packet=16M

[mysql]
no-auto-rehash

[isamchk]
set-variable= key=16M

[client_fltk]
help_file= c:\mysql\sql_client\MySQL.help
client_file= c:\mysql\MySQL.options
history_length=20
database = test
queries_root= c:\mysql\queries
last_database_file= c:\mysql\lastdb
[WinMySQLAdmin]
Server=C:/server/usr/mysql/bin/mysqld-max-nt.exe

Best regards,
 Ilya  mailto:[EMAIL PROTECTED]
   http://www.ilysha.i-am.ru



-
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

problems with default-character-set=cp1251

[Victoria Reznichenko]

éÌØÑ,

Wednesday, February 13, 2002, 8:48:52 AM, you wrote:

éåë Hi.
éåë I use mysql 3.26.47, established on Windows 2000 Server Russian.
éåë After I set property - default-character-set = cp1251, web-server on a
éåë beginning to give out a massage - File ' c:\mysql \\ share\charsets
éåë \?.conf ' not found (Errcode: 2) Character set ' .) 14 'is not a
éåë compiled character set and is not specified in the' c:\mysql \\ 
share\charsets\Index ' file   
éåë If to set default-character-set = latin1, all ok. But I for correct
éåë sorting need cp1251. What it is necessary to make? 

éåë It is my file my.ini from the catalogue winnt
 [skip]

 Find your answers at: http://www.mysql.com/doc/P/r/Problems_with_character_sets.html




-- 
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com




-
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

Re: problems with default-character-set=cp1251

[Miguel Angel Solorzano]

At 09:48 13/02/2002 +0300, =?koi8-r?B?6czY0SDl18fFztjF18neIOvP0s/Cz9c=?= wrote:

Hi!

I did the test with default-character-set=cp1251 and was not be able
to repeat your problem:

Microsoft Windows 2000 [Versão 5.00.2195]
(C) Copyright 1985-2000 Microsoft Corp.

C:\cd\server\usr\mysql\bin

C:\server\usr\mysql\binmysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 3.23.47-max-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql show variables like %character%;
++--

---+
| Variable_name  | Value

|
++--

---+
| character_set  | cp1251

|
| character_sets | latin1 big5 czech euc_kr gb2312 gbk sjis tis620 ujis 
dec8 dos
  german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia 
hunga
rian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 |
++--

---+
2 rows in set (0.06 sec)

Regards,
Miguel



Hi.
I use mysql 3.26.47, established on Windows 2000 Server Russian.
After I set property - default-character-set = cp1251, web-server on a
beginning to give out a massage - File ' c:\mysql \\ share\charsets
\?.conf ' not found (Errcode: 2) Character set ' .) 14 'is not a
compiled character set and is not specified in the' c:\mysql \\ 
share\charsets\Index ' file
If to set default-character-set = latin1, all ok. But I for correct
sorting need cp1251. What it is necessary to make?

It is my file my.ini from the catalogue winnt

# Example mysql config file.
# Copy this file to c:\my.cnf to set global options
#
# One can use all long options that the program supports.
# Run the program with --help to get a list of available options

# This will be passed to all mysql clients
[client]
#password=my_password
port=3306
#socket=MySQL

# Here is entries for some specific programs
# The following values assume you have at least 32M ram

# The MySQL server
[mysqld]
port=3306
#socket=MySQL
skip-locking
character-sets-dir=c:/server/usr/mysql/share/charsets/
default-character-set=cp1251
set-variable = key_buffer=16M
set-variable = max_allowed_packet=1M
set-variable = thread_stack=128K
set-variable = flush_time=1800

# Uncomment the following rows if you move the MySQL distribution to another
# location
basedir = c:/server/usr/mysql/
datadir =C:/server/usr/mysql/data

# Uncomment the following rows if you are using InnoDB tables
# Create the directories ibdata and iblogs before to start the server.
# If necessary, modify the size of the files

#innodb_data_file_path = ibdata1:200M
#innodb_data_home_dir = c:\ibdata
#set-variable = innodb_mirrored_log_groups=1
#innodb_log_group_home_dir = c:\iblogs
#set-variable = innodb_log_files_in_group=3
#set-variable = innodb_log_file_size=30M
#set-variable = innodb_log_buffer_size=8M
#innodb_flush_log_at_trx_commit=1
#innodb_log_arch_dir = c:\iblogs
#innodb_log_archive=0
#set-variable = innodb_buffer_pool_size=80M
#set-variable=lower_case_table_names =0
#set-variable = innodb_additional_mem_pool_size=10M
#set-variable = innodb_file_io_threads=4
#set-variable = innodb_lock_wait_timeout=50

# Uncomment the following row if you are using a Max server and you don't 
want the
# InnoDb tables

#skip-innodb

[mysqldump]
quick
set-variable = max_allowed_packet=16M

[mysql]
no-auto-rehash

[isamchk]
set-variable= key=16M

[client_fltk]
help_file= c:\mysql\sql_client\MySQL.help
client_file= c:\mysql\MySQL.options
history_length=20
database = test
queries_root= c:\mysql\queries
last_database_file= c:\mysql\lastdb
[WinMySQLAdmin]
Server=C:/server/usr/mysql/bin/mysqld-max-nt.exe

Best regards,
  Ilya  mailto:[EMAIL PROTECTED]
http://www.ilysha.i-am.ru



-
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

-- 
For technical support contracts, goto https://order.mysql.com/
__  ___ ___   __
   /  |/  /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED

[Bug in replications] set character set don't work

[pavel]

Description:
Using set character set cp1251_koi8 before updates insert right
data on master server (cp1251 from client recode to koi8 on server),
but replication on slave server wrong (data dosn't recode from
cp1251 to koi8).
How-To-Repeat:
Setup replication with master and slave servers
Do with Master server:
set character set cp1251_koi8;
insert into test (test) values ('[text at cp1251 codepage]');
select test from test;
You will see text, recoded from cp1251 to koi8
Do with Slave server:
select test from test;
You will see text, *dosn't* recoded
Fix:
Binary log on master (I see it with mysqlbinlog) is right:
query set character set cp1251_koi8 is present. So, problem
with *slave* only.

Submitter-Id:  submitter ID
Originator:Pavel Andreew
Organization:  Ekaterinburg Telegraph
MySQL support: none
Synopsis:  set character set cp1251_koi8 don't work on slave server
Severity:  serious
Priority:  low
Category:  mysql
Class: sw-bug
Release:   mysql-3.23.47 (Source distribution)
Server: /usr/bin/mysqladmin  Ver 8.23 Distrib 3.23.47, for pc-linux-gnu on i686
Copyright (C) 2000 MySQL AB  MySQL Finland AB  TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version  3.23.47-log
Protocol version10
Connection  Localhost via UNIX socket
UNIX socket /var/run/mysqld/mysqld.sock
Uptime: 4 hours 14 min 6 sec

Threads: 2  Questions: 178  Slow queries: 0  Opens: 12  Flush tables: 1  Open tables: 
6 Queries per second avg: 0.012
Environment:

System: Linux collage 2.4.17 #1 Tue Dec 25 12:39:34 YEKT 2001 i686 unknown
Architecture: i686

Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs
gcc version 2.95.4  (Debian prerelease)
Compilation info: CC='gcc'  CFLAGS=''  CXX='c++'  CXXFLAGS=''  LDFLAGS=''
LIBC: 
lrwxrwxrwx1 root root   13 äÅË  6 10:31 /lib/libc.so.6 - libc-2.2.4.so
-rwxr-xr-x1 root root  1171196 äÅË  3 23:07 /lib/libc-2.2.4.so
-rw-r--r--1 root root  2669312 äÅË  3 23:07 /usr/lib/libc.a
-rw-r--r--1 root root  178 äÅË  3 23:07 /usr/lib/libc.so
Configure command: ./configure  --prefix=/usr --exec-prefix=/usr 
--libexecdir=/usr/sbin --datadir=/usr/share --sysconfdir=/etc/mysql 
--localstatedir=/var/lib/mysql --includedir=/usr/include --infodir=/usr/share/info 
--mandir=/usr/share/man --enable-shared --with-libwrap --enable-assembler 
--with-berkeley-db --with-innodb --enable-static --enable-shared --with-raid 
--enable-thread-safe-client --without-readline 
--with-unix-socket-path=/var/run/mysqld/mysqld.sock --with-mysqld-user=mysql 
--without-bench --with-client-ldflags=-lstdc++ --with-extra-charsets=all


-
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

howto change character set

[Kristian Hyllestad]

Newbie here!

How to change characterset from default latin1 to danish on a remote site 
connecting through SSH Secure Shell?

Case locally:
* MySql installed on Win2k
* has changed character from default latin1 to danish by creating c:\my.cnf - 
works great!

Case remote on a shared webhotel:
* MySql installed on a FreeBSD 4.1.1-STABLE
* using SSH Secure Shell to start mysql or mysqladmin

The support on the website could not help.

Thanks...
Kristian Hyllestad
SPINE AS ( http://spine.no )
Telf: 72 55 93 33 Faks: 72 55 93 83


-
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

Change character set for client

[Jindo Soul]

Hi,

How do  I use a characeter set different from the server default?
Server is configured to use latin1 as default character set.
But for some occasions, I'd like to switch to big5 characeter set.

I tried to edit ~/.my.cnf and added

[mysql]
default-character-set=big5

But show variables still says: character set  latin1.  Insertions of
certain Chinese characeter that has \ in it cannot be properly escaped
and end up being garbled.

Please shed some lights here.  Thanks

Regards,

Jindo

-
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

GRRRRRRR!!!! Character set

[Domenico Rotolo]

Hi everybody!

This is my problem:

1) Environment:

OS:sun4u sparc SUNW,Ultra-250
MySQL:3.22.32


2) What I do:

I make an excerpt of a table using   select
lpad(my_field,5,'0') into outfile 'my_file_path' from my_table ...


3) What I would like:

I'm in Italy, so in my DB there are characters like  è,é,à,ò and
many others. I expected that in the file my_file_path I find again
è,é,à,ò .


4) What I obtain:

In  my_file_path, instead of   è,é,à,ò, I have something like
this:   \345, \267, \330  (these values are invented).


Please, help me!  What can I do?


Thanks and best regards,

  Domenico




-
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

character set latin1_de : several questions

[Matthias Ragaz]

Hi

I have installed mysql 4.0 from source with

   ./configure \
 --with-charset=latin1_de
 --with-extra-charsets=all

Question 1: Is it true that the above does not make latin1_de my default 
character set for sorting?

When I tried to set the default character set to latin1_de in /etc/my.cnf I 
got an error saying that
the character set does not exist. As a matter of fact there was an entry in 
charsets/Index giving
latin1_de number 31 but there was no latin1_de.conf in the directory charsets.

Bug1: latin1_de.conf missing

Bug2 (Documentation): the history for 4.0.0 mentions a character set 
latin_de instead of latin1_de

Question 2: What does correct German sorting mean and what is the 
difference between charsets german1 and latin1_de

Actually correct german sorting is far from being trivial and in 
computing usually approximations are used:

One rule is:

   An umlaut character (diaeresis) has the same ordering value as its 
corresponding base character with
   the exception that if two words differ only by a diaeresis on a 
character the one with the diaeresis
   comes after the one without (this is still a little simplified).

An example makes it clearer:

   bar
   Bär
   Bären
   Barenboim
   bärtig

The character U+00DF (ß) is treated like two letters 's' but her it comes 
_before_ 'ss'
if everything else is identical.

Sincerely

Matthias

--
Matthias Ragaz
Informatik - Entwicklung
Schweizerische Bibliothek für Blinde und Sehbehinderte
Albisriederstasse 399
CH-8047 Zürich
Schweiz
Tel.:   +41 1 491 25 55
Fax:+41 1 492 64 75
--


-
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

character set

[safora dinary]

Dear Sir/Madam
I want change mysql character set because I have
problems in Data sort and search in persian language.
I have studied mysql help but I don't understand it.
please help me.
Yours Sincerely
S. Dinary


__
Do You Yahoo!?
Get email alerts  NEW webcam video instant messaging with Yahoo! Messenger. 
http://im.yahoo.com

-
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

Can one use more than one character set with one server instance?

[Goeran Zängerlein]

Hello helpful list!

For one of our customers we have to store russian and german text in a
database. Is is somehow possible to do this with one server instance or do I
have to split the data to be stored in two databases on two server
instances?

Thanks you very much,
Goeran Zaengerlein


-
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

setting a character set

[Tadej Guzej]

I'm trying to use a charset different than latin1.
I did this:

I created a file - c:\my.cnf - and inserted the following text into it:
[client]
default-character-set=win1250
  
 I restarted mysql server and I still have latin1. What am I doing wrong ?
 
 
 Thanks, 
 Tadej

P.S.
For the filter: database,sql,query,table
How about including 'mysql' in filter words ???


-
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

Re: setting a character set

[Sinisa Milivojevic]

Tadej Guzej writes:
 I'm trying to use a charset different than latin1.
 I did this:
 
 I created a file - c:\my.cnf - and inserted the following text into it:
 [client]
 default-character-set=win1250
   
  I restarted mysql server and I still have latin1. What am I doing wrong ?
  
  
  Thanks, 
  Tadej
 
 P.S.
 For the filter: database,sql,query,table
 How about including 'mysql' in filter words ???
 


May be you can try putting it under [mysqld] options header. 

Kak je v Sloveniji ??

-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   ___/   www.mysql.com


-
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

--default-character-set

[pascal barbedor]

Hi

there is no UTF-8 possibility for 
--default-character-set mysqld starting option.

How can I tell mysql to send to clients utf-8 if everything on the database is latin-1 
?


if 
--default-character-set=UTF-8  would exists in shared/charsets, 
does it mean I have to recode all the content of my database or 
does it mean mysql would convert it dynamically when sending something to a client ?

has anyone got the same problem ?

looked in the docs, but not a word on utf-8.

thanks

pascal barbedor

Re: character set

[Tonu Samuel]

dodge wrote:

 I've problem with sorting table rows, thats why i need to get mysql
 work with my character set.
 can you explain better about ctype array when defining character set.
 I really did not understand about elements in this array. The rest
 ones to_lower, to_upper, sort it's simple just simbol codes in
 hexadecimal...


I think answer you need is here:

http://www.mysql.com/doc/C/h/Character_arrays.html


   Tõnu


-
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

character set

[dodge]

Hi,

I've problem with sorting table rows, thats why i need to get mysql
work with my character set.
can you explain better about ctype array when defining character set.
I really did not understand about elements in this array. The rest
ones to_lower, to_upper, sort it's simple just simbol codes in
hexadecimal...


-- 
Best regards,
 dodge  mailto:[EMAIL PROTECTED]  

-- 
Best regards,
 dodge  mailto:[EMAIL PROTECTED]


-
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

Re: Character set insensitive terms?

[Sinisa Milivojevic]

Mark W. de Raad writes:
 Good afternoon,
 
 We have an not-so-unusual problem where people are accessing a database from
 different countries (in this example, Germany and the UK). One of the search
 terms commonly used is: gehäuse (housing), which the UK types in as gehause
 and Germany (rightly of course) insists the word is not valid without the
 umlaut :)
 
 I realise that I can use the german1 character set to ensure that the SORT
 order is not thrown out by the character with the umlaut - but I wish to
 have a character set insensitive SELECT so that a=ä=ae and u=ü=ue (the ue
 may be a pushing things a bit).
 
 Is there a way to do this using a character set so that a query
 automatically equates the characters as equal? Or does there need to be a
 pre-query parser implemented with a rather large [aaeä...]?
 
 Thanks for any assistance.
 
 Regards,
 
 Mark
 --- 
 Mark W. de Raad 
 System Administrator
 I-Nex Corporation Pty. Ltd. 
 [EMAIL PROTECTED]


Hi!

At present moment a single  MySQL server supoprts one character set.

Current German set has few flaws, but a corrected version is on the
way.


-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   ___/   www.mysql.com

-
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

Character set insensitive terms?

[Mark W. de Raad]

Good afternoon,

We have an not-so-unusual problem where people are accessing a database from
different countries (in this example, Germany and the UK). One of the search
terms commonly used is: gehäuse (housing), which the UK types in as gehause
and Germany (rightly of course) insists the word is not valid without the
umlaut :)

I realise that I can use the german1 character set to ensure that the SORT
order is not thrown out by the character with the umlaut - but I wish to
have a character set insensitive SELECT so that a=ä=ae and u=ü=ue (the ue
may be a pushing things a bit).

Is there a way to do this using a character set so that a query
automatically equates the characters as equal? Or does there need to be a
pre-query parser implemented with a rather large [aaeä...]?

Thanks for any assistance.

Regards,

Mark
--- 
Mark W. de Raad 
System Administrator
I-Nex Corporation Pty. Ltd. 
[EMAIL PROTECTED]

-
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

Re: Need Japanese character set files

[Timothy Smith]

On 2001 Jun 06, Anatole [EMAIL PROTECTED] wrote:
 
 I brought down mysqld and restarted as before with safe_mysqld
 --default-character-set=sjis and get the following error message when php
 tries to connect:
 
 Can't initialize character set 13 (path: default) in
 /usr/local/apache/sites/gaijinpot.com/php/common.inc

Ah, the vital clue.  You're using PHP, and probably used the
mysql that is bundled with PHP (an older version, too), and
not an external MySQL library.  The PHP version only comes
with the latin1 character set.  What you need to do is configure
PHP using their --with-mysql=/path/to/your/mysql option, and
make and install the new PHP.

Yes, this is kind of a pain, but that's how it goes.  If you
have trouble with this process, a PHP list is probably the best
place to get help.

Oh, you might be able to get around this by just using the most
recent version of PHP.  We added a hack to ignore the error you
are getting, since the client doesn't have to do much with the
character sets.  But I'm not sure if it will work when the server
is using a multi-byte character set - it might just break.  The
way to be sure that things work is to follow my instructions
above.  If you just upgrade your PHP, and things don't work, let
me know the error you get so maybe I can find a work-around.

Tim

-- 
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Tim Smith [EMAIL PROTECTED]
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Development Team
/_/  /_/\_, /___/\___\_\___/   Boone, NC  USA
   ___/   www.mysql.com

-
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

Need Japanese character set files

[Narendra Phadke]

Hi,

I am storing Japanese data inside MySQL.
MySQL supports all the Europian languages and other languages like korian
and Hebru, and you have all the character set files for all these languages
inside the C:\mysql\share\charsets directory.
But this directory does not contain Japanese character set files. Where can
I get these files?

Waiting for the reply.

Thanks,

Narendra Phadke


-
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

Re: Need Japanese character set files

[Timothy Smith]

On 2001 Jun 04, Narendra Phadke [EMAIL PROTECTED] wrote:
 
 I am storing Japanese data inside MySQL.
 MySQL supports all the Europian languages and other languages like korian
 and Hebru, and you have all the character set files for all these languages
 inside the C:\mysql\share\charsets directory.
 But this directory does not contain Japanese character set files. Where can
 I get these files?

Only single-byte character sets with simple sorting rules can be
described by the *.conf files.  More complex character sets must
be compiled into the server.

The binaries that MySQL distributes have all supported character
sets included.  You can see what character sets are available
with this command:

mysql show variables like 'character_sets';

You should notice ujis and sjis there, if you are using one of our
binaries.  If you compile MySQL yourself, you must specify the
character sets you want when you run 'configure', like this:

sh configure --with-charset=sjis --with-extra-charsets=ujis,gbk

When you start mysqld, you use the --default-character-set=ujis
option to change the character set being used.  Our binaries use
latin1 by default.  With the configuration line from above, the
default would be sjis, but you could specify ujis, gbk, or any
of the simple character sets in share/charsets/*.conf.

Tim

-- 
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Tim Smith [EMAIL PROTECTED]
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Development Team
/_/  /_/\_, /___/\___\_\___/   Boone, NC  USA
   ___/   www.mysql.com

-
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

Re: Need Japanese character set files

[Anatole]

 Only single-byte character sets with simple sorting rules can be
 described by the *.conf files.  More complex character sets must
 be compiled into the server.
 
 The binaries that MySQL distributes have all supported character
 sets included.  You can see what character sets are available
 with this command:
 
   mysql show variables like 'character_sets';
 
 You should notice ujis and sjis there, if you are using one of our
 binaries.

 When you start mysqld, you use the --default-character-set=ujis
 option to change the character set being used.  Our binaries use
 latin1 by default.  With the configuration line from above, the
 default would be sjis, but you could specify ujis, gbk, or any
 of the simple character sets in share/charsets/*.conf.

I installed MySQL from an RPM file on Linux. When I use the mysqlshow
variables like 'character_sets'; as you mentioned above, I do, indeed, show
sjis. So, I shutdown mysql and restarted it like this:
safe_mysqld --default-character-set=sjis

This resulted in an error message (sorry I forgot the one however something
it to do with missing charsets I believe). I had a look around and I noticed
the following charsets in /usr/share/mysql/charsets:

./croat.conf*greek.conf*  latin1.conf*   win1251.conf*
../   danish.conf*   hebrew.conf* latin2.conf*
win1251ukr.conf*
Index*dec8.conf* hp8.conf*latin5.conf*
README*   dos.conf*  hungarian.conf*  swe7.conf*
cp1251.conf*  estonia.conf*  koi8_ru.conf*usa7.conf*
cp1257.conf*  german1.conf*  koi8_ukr.conf*   win1250.conf*

Alas, no sjis, but I imagine that is because it a double-byte character set.

So, I'm left with the following question:
1. What do you mean by
More complex character sets must
 be compiled into the server.
And how would I go about doing this?

TIA

Anatole


-
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

Re: Need Japanese character set files

[Timothy Smith]

On 2001 Jun 06, Anatole [EMAIL PROTECTED] wrote:
 
 I installed MySQL from an RPM file on Linux. When I use the mysqlshow
 variables like 'character_sets'; as you mentioned above, I do, indeed, show
 sjis.

This means that the sjis character set is compiled into the server
already, so you do not need to recompile MySQL in order to use the
sjis character set.

 So, I shutdown mysql and restarted it like this:
 safe_mysqld --default-character-set=sjis
 
 This resulted in an error message (sorry I forgot the one however something
 it to do with missing charsets I believe).

I would need to know the error message in order to guess what is
going wrong.

 I had a look around and I noticed the following charsets in
 /usr/share/mysql/charsets:

cut

 Alas, no sjis, but I imagine that is because it a double-byte character set.

Yes.  If you had the source distribution, you would see the file
called strings/ctype-sjis.c, which contains the code needed to
handle the sjis character set.

 So, I'm left with the following question:
 1. What do you mean by
 More complex character sets must
  be compiled into the server.

In order to use the more complex character sets, such as sjis,
extra code must be linked into the mysqld binary.  When we build
our binary distributions, we do link in the extra code for all of
the more complex character sets.

 And how would I go about doing this?

You do not need to do this, since you are using a standard binary
that already includes all of the more complex character sets.

Tim

-- 
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Tim Smith [EMAIL PROTECTED]
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Development Team
/_/  /_/\_, /___/\___\_\___/   Boone, NC  USA
   ___/   www.mysql.com

-
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

Re: Need Japanese character set files

[Anatole]

Hi Tim,

Thanks for taking the time to write. You answered many questions that I
haven't been able to figure out so far about character sets.

The only thing I have left is...

 This resulted in an error message (sorry I forgot the one however something
 it to do with missing charsets I believe).
 
 I would need to know the error message in order to guess what is
 going wrong.

I brought down mysqld and restarted as before with safe_mysqld
--default-character-set=sjis and get the following error message when php
tries to connect:

Can't initialize character set 13 (path: default) in
/usr/local/apache/sites/gaijinpot.com/php/common.inc


Thanks again for your help!

Anatole


-
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

Character Set

[Huy, Tran Le Huy]

Hello,

I am working with a MySQL 3.22.32 on Sun.When I run my application on
it(Jakatatomcat + Apache + DataBase MySQL), I can not show character set is
French. But When I change by run Jakatatomcat + Apache on my client(WINNT
40) and Database MySQL on Sun , I can show character set french.

Please help me as soon as possiable

 

Thank you 

HuyTL

Tran Le Huy 
VietSoftware company 
1 Yet kieu, Ha noi, VietNam 
Tel  : 84 (4) 9420709 
Fax : 84 (4) 9420708 

 

character set works via web but not at command line?

[Ian Corner]

Hi (if needed you can find my environment setup below)
I wish to load some data files at the mysql command prompt but seem to be 
failing due to Swedish characters being incorporated. Here is the error:
ERROR 1064: You have an error in your SQL syntax near 'insert into category 
(categoryid,description,xsectionid) values (
"HÓstar sÓljes"' at line 3

I was suprised as my web interface manages to place and retrieve Swedish 
characters with no problems. Yet when I review table information at the 
command prompt the Swedish characters are not visable.

Having read many messages and the "Languge" page in the document I still 
have no answer as to why I can via the web, and why I cant via the data load 
files?

I read a message dated early 2000 that compiling character sets was not 
going to be need shortly as support for character sets was being developed. 
Have I missed something?

I tried the "default-character-set" tag and I got an error that #10 was not 
a compiled language? #10 being swe7 in the index file... and I figure 
meaning Swedish. Whats happening and how do I resolve this.

In summary, I need to data load Swedish character files at the command line.

Thanks for any help.

Regards,
Ian
mySQL/Java environment -
os: w2000
mySQL server: v3.23.36
mySQL client: v3.23.33
IBM JVM 1.3
Web solution: JSP/Beans
Web server: Jakarta Tomcat (from Apache project)
Web JDBC: mm.mysql-2.0.4 and Poolman


_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.


-
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

RE: character set works via web but not at command line?

[Ben Dimmock]

Ian,

I may be way off the mark here, but I've found MySQL usually starts quoting
the line from the place at which the error occurred, thus indicating it
didn't like the "insert" part. Not being able to see the preceding lines I
can only suggest it may not have an active database to write to.

When importing a mysqldump, make sure you specify the db name (I'm sorry if
this is too simplistic and obvious to you :-)

$ mysql dbname -u username -p  mysqldump.file
provide password

If this is not the case, and the contents of your database are not
sensitive, I'm willing to take a look and try it on my machine.

Hope this helps,

Ben

-Original Message-
From: Ian Corner [mailto:[EMAIL PROTECTED]]
Sent: 08 April 2001 22:32
To: [EMAIL PROTECTED]
Subject: character set works via web but not at command line?


Hi (if needed you can find my environment setup below)
I wish to load some data files at the mysql command prompt but seem to be
failing due to Swedish characters being incorporated. Here is the error:
ERROR 1064: You have an error in your SQL syntax near 'insert into category
(categoryid,description,xsectionid) values (
"Hstar sljes"' at line 3

I was suprised as my web interface manages to place and retrieve Swedish
characters with no problems. Yet when I review table information at the
command prompt the Swedish characters are not visable.

Having read many messages and the "Languge" page in the document I still
have no answer as to why I can via the web, and why I cant via the data load
files?

I read a message dated early 2000 that compiling character sets was not
going to be need shortly as support for character sets was being developed.
Have I missed something?

I tried the "default-character-set" tag and I got an error that #10 was not
a compiled language? #10 being swe7 in the index file... and I figure
meaning Swedish. Whats happening and how do I resolve this.

In summary, I need to data load Swedish character files at the command line.

Thanks for any help.

Regards,
Ian
mySQL/Java environment -
os: w2000
mySQL server: v3.23.36
mySQL client: v3.23.33
IBM JVM 1.3
Web solution: JSP/Beans
Web server: Jakarta Tomcat (from Apache project)
Web JDBC: mm.mysql-2.0.4 and Poolman


_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.


-
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

changing character set used for data and sorting

[Kirill Magdalinin]

Hello,

can anyone help me to solve the following problem:

I've installed MySQL server Ver 8.0 Distrib 3.22.32 from
FreeBSD 4.1 ports while installing OS.

Now I need to make the server sort data strings encoded
in koi8-ru in SELECT .. ORDER BY .. statements correctly.
At this stage I don't need any other extra functionality
other than sorting strings in russian language correctly.

I looked through the manuals and mail lists and figured
out eventually that MySQL server must be started with
--default-character-set=koi8_ru.

The first problem is that there is no share/mysql/charsets/
directory installed. And the second  - server doesn't
understand this option if I put it in /etc/my.cfn like

[mysqld]
default-character-set=koi8_ru

There is error message in log file saying:

/usr/local/libexec/mysqld: unrecognized option
`--default-character-set=koi8_ru'

What the server does understand is

[mysqld]
language=russian

but it has nothing to do with the data sorting.

Why does the server fail to start with the
default-character-set=koi8_ru option in /etc/my.cfn?
Do I have to compile it from the sources with
--with-charset=koi8_ru option in order to solve the
problem or I just can copy share/mysql/charsets/ from
appropriate tarball distribution and restart the server?
In case I have to compile it, I have to recompile php,
apache and DBI as well, don't I?

Please send your responses directly to my email address
because I'm not subscribed to this list.

Best regards,

Kirill Magdalinin
[EMAIL PROTECTED]
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.


-
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

Re: changing character set used for data and sorting

[Sergei Golubchik]

Hi!

On Feb 21, Kirill Magdalinin wrote:
 Hello,
 
 can anyone help me to solve the following problem:
 
 I've installed MySQL server Ver 8.0 Distrib 3.22.32 from
  ^^^
 FreeBSD 4.1 ports while installing OS.

Here's your problem. I don't know why FreeBSD Port Collection
still has MySQL-3.22, while 3.23 is officially released as stable.

Nevertheless, for 3.22 you should build MySQL with koi8 charset from
sources.

But if you're planning to build MySQL yourself anyway, I *strongly*
recommend to use latest 3.23 tarball. It works ok on FreeBSD
(I am, personally, using FreeBSD) - you will need gmake (from
ports, e.g.) though.

MySQL-3.23 is faster and has *a lot of* new features.
And - to mention - all the bugfixes goes only to MySQL-3.23,
MySQL-3.22 are no longer supported.

Regards,
Sergei

--
MySQL Development Team
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik [EMAIL PROTECTED]
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, http://www.mysql.com/
/_/  /_/\_, /___/\___\_\___/  Osnabrueck, Germany
   ___/

-
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

Re: Arabic character set

[Llorenc Sole]

   we are setting up an Arabic web site using PHP with MySQL 3.23.22.
  Our problem is that we can not sort data correctly when retreiving it
  from Arabic text fields. This seems to be a character set problem.

   Has anyone any idea about using the Arabic character set with MySQL?

Hi,

This is an interesting issue I've just begun to investigate for a
project where I plan to use mySQL to store text in different
languages and charsets. Take a look at chapter 10.1 (What Languages
Are Supported by mySQL?) on the mySQL manual, available online at:
http://www.mysql.com/documentation/index.html
http://www.mysql.com/Downloads/Manual/manual.pdf (this is the one I will refer)

There are a number of things to check when using other than the
default character set (ISO-8859-1 or Latin1), among them: mySQL
version, character sets available and compiled, multi-byte support,
client support and language specific features and bugs.

I also found this info on section 4.7.3 (Typical configure Options)

"By default, MySQL uses the ISO-8859-1 (Latin1) character set. To
change the default set, use the --with-charset option:
shell ./configure --with-charset=CHARSET

CHARSET may be one of big5, cp1251, cp1257, czech, danish, dec8, dos,
euc_kr, gb2312, gbk, german1, hebrew, hp8, hungarian, koi8_ru,
koi8_ukr, latin1, latin2, sjis, swe7, tis620, ujis, usa7, or
win1251ukr. See Section 10.1.1 [Character sets], page 328).

If you want to convert characters between the server and the client,
you should take a look at the SET OPTION CHARACTER SET command. (See
Section 7.33 [SET OPTION], page 270).

Warning: If you change character sets after having created any
tables, you will have to run myisamchk -r -q on every table. Your
indexes may be sorted incorrectly otherwise. (This can happen if you
install MySQL, create some tables, then reconfigure MySQL to use a
different character set and reinstall it.)".

I'd would appreciate if anyone could share any comment or experience
related to this issue.

HTH,

Lloren Sol
Maresme Netcom, S.L.
tel +34 937 411 047
fax +34 937 411 048
url http://www.maresme.net

-
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

Re: Arabic character set

[Boril Yonchev]

I have too this problem with cp1251 and write 3 time about this, but nobody
don't know correct answer :-(

BY

- Original Message -
From: "medianova" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, February 05, 2001 1:51 PM
Subject: Arabic character set


 Hi,

 we are setting up an Arabic web site using PHP with MySQL 3.23.22.
 Our problem is that we can not sort data correctly when retreiving it
 from Arabic text fields. This seems to be a character set problem.

 Has anyone any idea about using the Arabic character set with MySQL?

 Many thanks.
 Ghaleb



 -
 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

Re: Arabic character set

[Eran Boudjnah]

Hi,

am having the exact same problem with Hebrew...

Best regards,
-Eran

medianova wrote:

 Hi,

 we are setting up an Arabic web site using PHP with MySQL 3.23.22.
 Our problem is that we can not sort data correctly when retreiving it
 from Arabic text fields. This seems to be a character set problem.

 Has anyone any idea about using the Arabic character set with MySQL?

 Many thanks.
 Ghaleb

 -
 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

MyODBC can't initialize character set problem ...

[Bartlomiej Czardybon]

Hi

I'm trying to compile to MySQL latin2 sorting and cp1250_latin2 
character set conversion.

I've compiled mysql-3.23.31 with these configure options:
--without-debug \
--without-readline \
--enable-shared \
--with-extra-charsets=complex \
--without-bench \
--localstatedir=/var/lib/mysql \
--with-unix-socket-path=/var/lib/mysql/mysql.sock \
--with-mysqld-user="mysql" \
--with-extra-charsets=all \
--with-charset=latin2

I #define DEFINE_ALL_CHARACTER_SETS in convert.cc.

I connect to the server with MyODBC 2.50.36 and I get error:

--
[TCX] [MyODBC] Can't initialize character set 9 
(path: c:\mysql\share\charsets) (#2019)
--

and I can't connect - of course.

There is no directory c:\mysql in default MyODBC Win95 installation ... 

What am I doing wrong ?
-- 
Bartlomiej Czardybon, Dzial obslugi serwerow   PIK-Net Sieci Rozlegle
Toszecka 102, Gliwice Poland, +48 32 338-33-00 czar AT pik-net.pl

-
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

Re: MyODBC can't initialize character set problem ...

[Bart Czardybon]

On Wed, Jan 31, 2001 at 02:25:14PM +0100, Bartlomiej Czardybon wrote:
 
 --
 [TCX] [MyODBC] Can't initialize character set 9 
 (path: c:\mysql\share\charsets) (#2019)
 --
 
 There is no directory c:\mysql in default MyODBC Win95 installation ... 
 

In MyODBC Readme file there is a sentence:
---
Some common problems:
[cut]
- If you are connecting to a server with a character set that isn't compiled
  into the MySQL client library (the defaults are:
  latin1 big5 czech euc_kr gb2312 gbk sjis tis620 ujis
  ) then you need to install the mysql character definitions from the
  charsets directory into the c:\mysql\share\charsets.
---

What does the author mean by 'you need to install the mysql character
definitions fro the charsets directory into the c:\mysql\share\charsets ?

I've just done it (copied 'charsets' directory from unix
server path: /usr/share/mysql/charsets) but it still does not work ... :(

TIA for any help,
-- 
Bartlomiej Czardybon PIK-Net Sieci Rozlegle
e-mail: czar AT pik-net.pl   BC374-RIPE

-
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

Re: Change character set

[Richard Ellerbrock]

Firstly, upgrade to 3.23.x as with 3.22 you will need to compile from sources to 
change character sets. Next, read the following section in the manual:

http://www.mysql.com/doc/L/a/Languages.html

--
Richard Ellerbrock
[EMAIL PROTECTED]

 [EMAIL PROTECTED] 2001/01/25 01:50:33 
Hello,

I am working with a MySQL 3.22.32 on Linux.
I would like to change the character set of
MySQL from latin1 to greek because it doesn't
work right with the greek words and data. 
(sorting is not functioning well)

Can you tell me how I can change the default character
set from latin1 to greek.

Thank you

Spyridon N Kaparelis
Computer Engineer



-
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

Re: Change character set

[Boril Yonchev]

This problem is with charset support not by languages. I have also this
problem, but at the moment nobody doesn't say anything about this.

I am sure so this is a problem in new MySQL 3.23.xx, with oldes version
everything was fine.

Boril

- Original Message -
From: "Richard Ellerbrock" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, January 25, 2001 2:06 PM
Subject: Re: Change character set


Firstly, upgrade to 3.23.x as with 3.22 you will need to compile from
sources to change character sets. Next, read the following section in the
manual:

http://www.mysql.com/doc/L/a/Languages.html

--
Richard Ellerbrock
[EMAIL PROTECTED]

 [EMAIL PROTECTED] 2001/01/25 01:50:33 
Hello,

I am working with a MySQL 3.22.32 on Linux.
I would like to change the character set of
MySQL from latin1 to greek because it doesn't
work right with the greek words and data.
(sorting is not functioning well)

Can you tell me how I can change the default character
set from latin1 to greek.

Thank you

Spyridon N Kaparelis
Computer Engineer



-
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