Begin forwarded message:
From: Napster Cao tx...@hotmail.com
Subject: character set problem
Date: June 11, 2013 11:04:18 PM GMT+08:00
To: mysql@lists.mysql.com
Hi Guys,
I installed a new CentOS server (6.4 x86_64), and when I try to log into
phpmyadmin, there's an ERROR:
Can't
independent how often you re-post it will not become magically
a MySQL problem if you have messed up your OS environment
Am 12.06.2013 15:27, schrieb Napster Cao:
BTW: Everytime I logged into system, I got:
-bash: warning: setlocale: LC_CTYPE: cannot change locale (UTF-8): No such
file or
Hi,
I want to search from a table , I have a table with a column that each
record filled with different character set ,is it possible
to know what are their character set and then is it possible to change all
of them
to a character set ,how can I do that?
these records show like below that I
Hi. I just installed MySQL 4.1.20 for the UTF-8 support it offers. I'm
trying to set the charcter set collation at the database level but
can't get it to work.
It works by setting it at the server level (in my.cnf) but I want to
set it at the database level because I'll be hosting the web
From: Spiros Philopoulos Sent: 06 July 2006 13:32
Hi. I just installed MySQL 4.1.20 for the UTF-8 support it
offers. I'm
trying to set the charcter set collation at the database level but
can't get it to work.
It works by setting it at the server level (in my.cnf) but I want to
set
Hy
I have a table datas like that :
name
Mester József
Job György
Czibere Lajos
If I create :
select name from dolgozok where name like '%jó%' ;
then all data will be shown.
But I wolud like see datas which really contain ó character (only Mester
József).
Joe
Hello.
Perhaps it is an issue of your collation:
mysql select a from ts where a like '%ó%' collate utf8_bin ;
++
| a |
++
| Mester József |
++
1 row in set (0.00 sec)
mysql select a from ts where a like binary '%ó%';
hi,
we've got an old mysql-3.23.58 and a new mysql-4.1.10a and we'de like to
migrate our data, but it doesn't seems to be so easy:-(
out old server has a latin2 database. after we dump it and try tp import
into the new ones we always got errors or the spical accented hungarian
characters are
hi,
we've got an old mysql-3.23.58 and a new mysql-4.1.10a and we'de
like to
migrate our data, but it doesn't seems to be so easy:-(
out old server has a latin2 database. after we dump it and try tp
import
into the new ones we always got errors or the spical accented
hungarian
characters
: Tuesday, May 03, 2005 1:42 PM
Subject: Re: Character Set Problem
Hello,
Is the MySQL server that you are using MySQL4.1.x or MySQL5.0.x?
As for most binarys of PHP and MySQL, the default charset of
the MySQL connection client is set as 'latin1'. Therefore, if charset
with the server
Hello,
this is probably quite simple but I've got a text file that has non-english
characters, when I view it I see :
'Dcouvrez un rseau europen d'htels et de restaurants beignant dans
une atmosphre conviviale et familliale'
I've imported this straight into my myisam DB which is set up with
Hello,
Is the MySQL server that you are using MySQL4.1.x or MySQL5.0.x?
As for most binarys of PHP and MySQL, the default charset of
the MySQL connection client is set as 'latin1'. Therefore, if charset
with the server is not 'latin1', it is necessary to set the MySQL
connection client properly.
Hello.
If you can reproduce this problem on several different installations, you
may open a new bug (because #312 is closed) and leave there a note about bug
#312.
Stephen Moretti (cfmaster) [EMAIL PROTECTED] wrote:
Gleb Paharenko wrote:
Thanks for the reply.
See:
Gleb Paharenko wrote:
Thanks for the reply.
See:
http://dev.mysql.com/doc/mysql/en/problems-with-character-sets.html
Yeah Thanks - seen that already.
Check that you have the charsets directory in c:\mysql\share.
Again, thanks, but that doesn't actually solve the issue.
There are entries
Hello.
See:
http://dev.mysql.com/doc/mysql/en/problems-with-character-sets.html
I've read through all the supposed fixes and other posts all over the
place, but, to be honest, I'm confused. I'm not really sure what the
fix is.
Check that you have the charsets directory in
Hi there,
I'm on mysql 4.1.10a on Windows 2003 Server.
I'm getting :
File 'c:\mysql\share\charsets\?.conf' not found (Errcode: 22) Character
set '#33' is not a compiled character set and is not specified in the
'c:\mysql\share\charsets\Index' file
when some PHP applications try accessing
Hello.
The value of the character_set_system in this
case doesn't have affect in this case. You table
has latin2 as default character set, and all
your character_set_xxx variables have a latin1 value.
Ian Gibbons [EMAIL PROTECTED] wrote:
On 12 Feb 2005 at 14:09, Gleb Paharenko
Hello.
Please tell us, what output the following statement produces:
SHOW VARIABLES LIKE '%char%';
You can use hexademical values for inserting the data. See:
http://dev.mysql.com/doc/mysql/en/hexadecimal-values.html
Ian Gibbons [EMAIL PROTECTED] wrote:
Hi List,
I am
On 12 Feb 2005 at 14:09, Gleb Paharenko wrote:
Hello.
Please tell us, what output the following statement produces:
SHOW VARIABLES LIKE '%char%';
Hi Gleb,
mysql SHOW VARIABLES LIKE '%char%';
+--++
| Variable_name| Value
Hi List,
I am having a strange problem on Linux Fedora Core 3 with MySQL 4.1.7 ( offical
mysql rpms). The data was originally stored in MySQL 3.something and was placed
into the database via a MySQLDump file. It is too late to reload the data.
I have a table called fees:
CREATE TABLE `fees` (
Hi,
I have just found a major problem with my site.
This is my problem:
My server has been running on a redhat 7.3 distro without any problems for
some time now. I then purchased a new server, which is running Redhat Linux
ES 3.0 with the same basic settings and same install options.
When
The first things you should check:
1. Do \s from the mysql client to be sure its using the character set you
told it to use with default-character-set=latin1. Be sure its the same one
you used on your old server.
2. Since you have the Norwegian keyboard set up try typing Norwegian
characters
Hardy [EMAIL PROTECTED]
To: Marcin Giedz [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, September 18, 2003 11:34 AM
Subject: Re: Character set problem Linux - Windows
Hi Marcin,
have you tried using unicode?
Not yet Adam but though about it!!!
If I change to unicode how to change
Hi Marcin,
have you tried using unicode?
Adam
On 09/17/2003 02:02 PM Marcin Giedz wrote:
Hi all,
My company(situated in Poland) produce cross platform software based on
Borland Delphi/Kylix. We also use mysql server to store all our date.Server
is configured with latin2 character set. Nowadays
- Original Message -
From: Adam Hardy [EMAIL PROTECTED]
To: Marcin Giedz [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, September 18, 2003 11:34 AM
Subject: Re: Character set problem Linux - Windows
Hi Marcin,
have you tried using unicode?
Not yet Adam but though about
Hi all,
My company(situated in Poland) produce cross platform software based on
Borland Delphi/Kylix. We also use mysql server to store all our date.Server
is configured with latin2 character set. Nowadays several users work on
Linux boxes(Debian + XFree 4.3.1 + KDE 3.1.3 + iso 8859-2 with
Hello there...
I have a problem with sort order. I use greek and
english characters.
The manual says to put the following lines to my.cnf:
[client]
character-sets-dir=/usr/local/mysql/share/mysql/charsets
default-character-set=greek
i restart the demon but the problem still exist.
I have 3.23.49
At 10:23 + 11/6/02, nick gatsis wrote:
Hello there...
I have a problem with sort order. I use greek and
english characters.
The manual says to put the following lines to my.cnf:
[client]
character-sets-dir=/usr/local/mysql/share/mysql/charsets
default-character-set=greek
i restart the demon
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 with
- 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
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
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:
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:
---
35 matches
Mail list logo
