[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
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
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
]
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
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
-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
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
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
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
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
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
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
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
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
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
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
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
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
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
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,
[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
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
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
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
/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
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
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
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
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
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
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
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:
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
-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
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
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
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
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
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
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
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:
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?
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),
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
[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
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
éÌØÑ,
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
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
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
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:
*
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
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:
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
).
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
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
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
ok 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
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
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
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
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
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
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
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
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
brock" [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
man
201 - 280 of 280 matches
Mail list logo