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 o
Begin forwarded message:
> From: Napster Cao
> 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
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 don'
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
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 ap
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 '%ó%';
+--
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
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 a
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 ge
]>
Cc:
Sent: 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
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,
this is probably quite simple but I've got a text file that has non-english
characters, when I view it I see :
'Découvrez un réseau européen d'hôtels et de restaurants beignant dans
une atmosphère conviviale et familliale'
I've imported this straight into my myisam DB which is set up
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.
>
>>S
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 in
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 c:\my
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 thei
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 Paharenk
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
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 a
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` (
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
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 perfor
"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 thoug
- 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,
> hav
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 se
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 LC_ALL
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 b
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
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
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
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 w
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
---
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/man
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 sentenc
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 \
--wi
35 matches
Mail list logo