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
Database has:
DEFAULT CHARACTER SET - latin1
DEFAULT COLLATION : latin1_swedish_ci
We need to convert this to
DEFAULT CHARACTER SET - utf8
DEFAULT COLLATION : utf8_general_ci
Note that this has to be done on a database that has *existing data* in
it .
Hence just by doing
Uma,
I apologize in advance if this is redundant ,because I did not
click on any of Ewen's link. Nonetheless, this is the approach I would
take.
start your mysql server with different --character-set-server and
---collation-server options
Type SHOW COLLATION; in your mysql shell to determine
fortuneewen.fort...@gmail.com; mysql@lists.mysql.com
Subject: Re: Best way to convert character set from latin1 to utf8 for
existing database?
Uma,
I apologize in advance if this is redundant ,because I did not
click on any of Ewen's link. Nonetheless, this is the approach I would
take
Hi All,
I have read many blogs suggesting some examples for this.
But suggestions from you guys who have ACTUALLY worked on such a scenario
would help me out the best.
Current Database has:
DEFAULT CHARACTER SET - latin1
DEFAULT COLLATION : latin1_swedish_ci
We need to convert this to
DEFAULT
Uma,
On Mon, Jun 1, 2009 at 8:41 AM, Uma Bhat bhat@gmail.com wrote:
Hi All,
I have read many blogs suggesting some examples for this.
But suggestions from you guys who have ACTUALLY worked on such a scenario
would help me out the best.
Current Database has:
DEFAULT CHARACTER SET
Hi, I just tried this on a local copy of the table with ~500.000 rows:
execute 'ALTER TABLE users MODIFY email VARCHAR(255) CHARACTER
SET latin1 NOT NULL'
The old character set was UTF8. We're doing this to make the index
smaller. This took around 45 minutes to complete. In production
this on a local copy of the table with ~500.000 rows:
execute 'ALTER TABLE users MODIFY email VARCHAR(255) CHARACTER SET latin1
NOT NULL'
The old character set was UTF8. We're doing this to make the index smaller.
This took around 45 minutes to complete. In production, we have about
1.000.000 rows
When the memory can not load our application,the error occurs.
080630 17:32:38 [ERROR] /usr/local/mysql/bin/mysqld: Out of memory (Needed
1651540 bytes)
And there are some data displayed ? in my database.
For example.
mysql select * from passport where name like '%??%' limit 1\G
Is this data comming from application or loaded using LOAD DATA command. Can
u please check the character set of the db and columns.
On 6/30/08, Moon's Father [EMAIL PROTECTED] wrote:
When the memory can not load our application,the error occurs.
080630 17:32:38 [ERROR] /usr/local/mysql/bin
Yeah,they came from .net application and not using load data infile
statement.
The character set of my db and columns is both utf8;
Some wield thing is that the data is normal yesterday ,but they displayed
today after the error happened.
On Mon, Jun 30, 2008 at 7:01 PM, Ananda Kumar [EMAIL
try to optimize the table and see if the error goes away
On 7/1/08, Moon's Father [EMAIL PROTECTED] wrote:
Yeah,they came from .net application and not using load data infile
statement.
The character set of my db and columns is both utf8;
Some wield thing is that the data is normal
If you create all your databases and tables with utf8,then every thing is
fine.
On Mon, Apr 28, 2008 at 1:43 AM, Velen [EMAIL PROTECTED] wrote:
Hi,
I'm storing some ascii codes in a table. When I do a dump using mysqldump
from the server and then restoring it on another station, the ascii
Hi Sulo,
Open the file you are importing as it is probably that it contains
references of another character set in the table creation. If so replace
that character set for '' or 'utf8'.
I hope it helps,
Leandro
sulochan acharya wrote:
Hello all,
here is my problem:
I am trying to set
To: mysql@lists.mysql.com
Subject: Problem with character set and connection collation
Hello all,
here is my problem:
I am trying to set mysql to unicode character, so that i can get my
dictionary application to look at words in Nepali.
here is my setting:
mysql charset: utf-8 unicode
when i make
On Mon, 28 Apr 2008, Jerry Schwartz [EMAIL PROTECTED] wrote:
A week or so ago I explored this in depth because I was having the
same problems. (It was affecting an English file that had some
Windows (CP-1252) characters that didn't directly map to UTF-8. That
message is at
Well, if latin1 is not CP-1252, then that explains why it didn't fix my
problem; but here's what 5.0.45-community-nt says:
mysql show character set;
+--+-+-++
| Charset | Description | Default collation | Maxlen
Hello all,
here is my problem:
I am trying to set mysql to unicode character, so that i can get my
dictionary application to look at words in Nepali.
here is my setting:
mysql charset: utf-8 unicode
when i make a new database:
mysql connection collation is utf8-general-ci
and my new database
Hi,
I'm storing some ascii codes in a table. When I do a dump using mysqldump from
the server and then restoring it on another station, the ascii codes in the
table has changed.
But if i'm accessing the table from another station the code is good. Even if
I insert it from a station, it
When you create a table, you can specify a character set for a column. How
can you tell what character set was used when the column was created?
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX
When you create a table, you can specify a character set for a column. How
can you tell what character set was used when the column was created?
SHOW CREATE TABLE. If no character set is shown for the column,
it uses the table default character set.
Example:
mysql create table t (c1 char(5
-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 16, 2008 10:25 AM
To: Jerry Schwartz; 'Mysql'
Subject: Re: CHARACTER SET
When you create a table, you can specify a character set for a column.
How
can you tell what character set was used when the column was created?
SHOW
On Wed, Apr 16, 2008 at 7:24 AM, Paul DuBois [EMAIL PROTECTED] wrote:
When you create a table, you can specify a character set for a column. How
can you tell what character set was used when the column was created?
SHOW CREATE TABLE. If no character set is shown for the column
www.giiexpress.com
www.etudes-marche.com
-Original Message-
From: Rob Wultsch [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 16, 2008 11:50 AM
To: Paul DuBois
Cc: Jerry Schwartz; Mysql
Subject: Re: CHARACTER SET
On Wed, Apr 16, 2008 at 7:24 AM, Paul DuBois [EMAIL PROTECTED] wrote:
When you
At 8:49 AM -0700 4/16/08, Rob Wultsch wrote:
On Wed, Apr 16, 2008 at 7:24 AM, Paul DuBois [EMAIL PROTECTED] wrote:
When you create a table, you can specify a character set for a column. How
can you tell what character set was used when the column was created?
SHOW CREATE TABLE
Hi,
Try this.
set session collation_database=latin1_swedish_ci;
set session character_set_database=latin1;
regards
anandkl
On 10/29/07, Dušan Pavlica [EMAIL PROTECTED] wrote:
Are you sure your file is coded in utf8? Character set of your file must
be same as charset of your database
Are you sure your file is coded in utf8? Character set of your file must
be same as charset of your database.
Dusan
Caleb Racey napsal(a):
Does anyone know how to get the load data infile command to load utf8 data?
I have setup a database as utf8 with a collation of utf8_general_ci
-character-set=utf8
[mysqld]
default-character-set=utf8
init-connect='SET NAMES utf8'
And you might want to add these also:
collation_server=utf8_unicode_ci
character_set_server=utf8
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
Does anyone know how to get the load data infile command to load utf8 data?
I have setup a database as utf8 with a collation of utf8_general_ci, the
mysqld server is started with --character-set-server=utf8. Server variables
say character_set_database = utf8. I use the sql below
LOAD DATA
Caleb Racey wrote:
Does anyone know how to get the load data infile command to load utf8 data?
I have setup a database as utf8 with a collation of utf8_general_ci, the
mysqld server is started with --character-set-server=utf8. Server variables
say character_set_database = utf8. I use the sql
Caleb Racey wrote:
Does anyone know how to get the load data infile command to load utf8 data?
I have setup a database as utf8 with a collation of utf8_general_ci, the
mysqld server is started with --character-set-server=utf8. Server variables
say character_set_database = utf8. I use the sql
Caleb Racey wrote:
On 10/26/07, Baron Schwartz [EMAIL PROTECTED] wrote:
Caleb Racey wrote:
It is indeed buggy and badly documented. It depends on the current
database's character set instead. Try this:
SET NAMES utf8;
SET character_set_database=utf8;
LOAD DATA INFILE...
Baron
Thanks
Hello.
I have a question about the behavior of SELECT ... LIKE and dealing with
the Korean language. For those who don't know anything about the way the
language's characters are formulated, I'll give you a quick crash course:
Korean has its own alphabet, just like Japanese, Chinese and most
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
Jerry Schwartz [EMAIL PROTECTED]:
Columns can have character set definitions, also. In this case, I
hope not.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: Chris White
Hi,
We are deploying a software upgrade and need to convert the MySQL database
of all installations from their previous character set (default) to UTF-8.
I have read the instructions at
http://dev.mysql.com/doc/refman/5.0/en/charset-conversion.html and the
discussion at http://bugs.mysql.com
if you have to concentrate on
the screen all the time ;-).
If somebody knows of a smart tool that is doing the hart work feel
free to speak ;-)
Best regards
Nils Valentin
Quoting Jerry Schwartz [EMAIL PROTECTED]:
Columns can have character set definitions, also. In this case, I hope
I did a DB conversion before that with ALTER DATABASE db_name
CHARACTER SET utf8
That worked wonderfully, except not as expected. ;-)
It basically converted only the database itself. so I had to do a
separate ALTER TABLE ... for each table.
The database encoding more establishes the default
Columns can have character set definitions, also. In this case, I hope not.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: Chris White [mailto:[EMAIL PROTECTED]
Sent
Hello fellow MySQL friends,
I recently had the fun to convert some 60 tables within a DB f.e.
from latin1 to UTF8.
I did a DB conversion before that with ALTER DATABASE db_name
CHARACTER SET utf8
That worked wonderfully, except not as expected. ;-)
It basically converted only the database
companies (
c1 VARCHAR(30) CHARACTER SET utf8,
c2 VARCHAR(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci,
c3 VARCHAR(30) CHARACTER SET latin1,
c4 VARCHAR(30) CHARACTER SET latin1 COLLATE latin1_general_ci,
c5 VARCHAR(30) CHARACTER SET dec8
On Thursday 07 December 2006 10:09, Ed wrote:
Hi all,
I need a database that is able to handle french characters.
Sorry about that, it's probably due to my OS rather than MySQL.
$ echo Fête
Fête
$ touch Fête
$ ls -l
-rw-r--r-- 1 me me 0 Dec 7 14:20 F?te
$ rm Fête
Hmmm, back
My programm connect to MYSQL server(4.1.12), set it's character set by
set NAMES gbk,
the variables when client programm started is
character_set_client gbk
character_set_connection gbk
character_set_databasegbk
My programm connect to MYSQL server, adn set it's charactor set by set
NAMES gbk, after a long while, like
one night, I found the client charactor set have been changed to latin, it
seems related to some timeout value.
why the characotor set would be changed? My programm use MYSQL C API.
Hey all, got a simple question:
Is there a quick way to convert all the data in my database to a specific
character set? I want to convert all the text to UTF-8.
-Charlie
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
Hola.
With mySQL 4.0.27 I'm trying to create this table
--
CREATE TABLE `test`.`user` (
`user_id` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
`email` TEXT CHARACTER SET COLLATE NULL ,
`firstname` TEXT CHARACTER SET COLLATE NOT NULL ,
)
--
but I get this error:
--
#1064 - You have
Hello Thomas
You have an error in your SQL syntax.
Please try this :
CREATE TABLE test.user
( user_id INT UNSIGNED NOT NULL AUTO_INCREMENT, PRIMARY KEY(user_id),
email text CHARACTER SET 'latin1' COLLATE 'latin1_swedish_ci',
firstname text CHARACTER SET 'latin1' COLLATE 'latin1_swedish_ci
app on a
third-party web hosting server, where likely I won't have access to
server level settings via my.cnf (is there a way around this?).
I perform the following query:
ALTER DATABASE my schema name DEFAULT CHARACTER SET utf8 COLLATE
utf8_general_ci;
After the query a dump of the relevant
it at the database level because I'll be hosting the web app on a
third-party web hosting server, where likely I won't have access to
server level settings via my.cnf (is there a way around this?).
I perform the following query:
ALTER DATABASE my schema name DEFAULT CHARACTER SET utf8
On Mon, Jul 03, 2006 at 01:55:26PM +0400, Timur Izhbulatov wrote:
I'm following the instructions [1] to convert character set. Unfortunately I
get
warnings about truncated data for some rows in several columns. All the
truncated columns are text type.
Assuming the `col' column is text type
On Tue, Jul 04, 2006 at 01:55:30PM +0400, Timur Izhbulatov wrote:
After some additional investigations I found the cause. It was some exotic
non-ASCII characters like '–' (long dash). At the same time Russian letters
don't cause any problems.
Sorry, I was wrong concerning Russian letters.
Hi all,
I'm following the instructions [1] to convert character set. Unfortunately I get
warnings about truncated data for some rows in several columns. All the
truncated columns are text type.
Assuming the `col' column is text type and actually contains correct utf8 data
but has wrong character
From: He, Gang
Sent: Wednesday, April 12, 2006 8:43 PM
To: '[EMAIL PROTECTED]'
Subject: Mysql C API character set
Hi,
I install MySQL server 4.1.12 in Redhat Linux in Japanese environment (
env LANG=ja_JP.UTF-8 ),
I setup MySQL server utf8
Hi Sean,
I used to have similar problems with different character sets and my
solution is:
1) dump all data using mysql dump utility
2) check if data are OK - view your data with viewer which suports correct
character set
3) if data are not OK try to dump data in different character set
4
Hi,
I am having character set problems while trying to migrate my data
from a server running 4.0.25-standard to a server running 4.1.16. I
believe that the orginal database was using the latin1 character set
(not sure, is there any way to tell? show full column doesn't seem
up as separate tab
separate files like the following:
mysqldump --tab=/tmp/database database -u user --password=password
2. Tar and transfer the directory if necessary, then import it using
the following commands:
mysql -e CREATE DATABASE database default character set latin1
Hi there,
I tried a few other queries:
first, confirm that what you think is a binary is indeed a binary:
mysql SELECT CHARSET(_binary'Binary');
+--+
| CHARSET(_binary'Binary') |
+--+
| binary |
+--+
1 row
|
+-+
1 row in set (0.00 sec)
In Japan, we have to use many kinds of character set.
eucjpms,ujis for unix
cp932,sjis for Windows
utf8 for Java, MySQL meta data
Dear MySQL fans,
I tested CONCAT() with binary strings and I got strange result.
Manual says:
http://dev.mysql.com/doc/refman/5.0/en/string-functions.html
If the arguments include any binary strings, the result is a binary
string.
But the following test says:
bianry + latin1
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 '%ó%';
What is the best (most optimal) way to perform a case-insensitive search
for a VARCHAR column with COLLATE utf8_bin?
I'm assuming the answer is not:
SELECT *
FROM MyTable
WHERE UPPER(MyColumn) LIKE Upper('%pattern%');
Tia!
R.
--
MySQL General Mailing List
For list
, temporary
switch it to utf8. Force character_set_connection, character_set_client,
character_set_results variables to have 'utf8' value. Change the default
character set of all fields to utf8 (ALTER TABLE can do this or just
create a new table). Check if you're able to store and get correct
of a non-standard
character set ( Latin 1, UTF8 ) into Query Browser?
How about upload via a Perl script?
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net
Octavian Rasnita wrote:
From: Daniel Kasak [EMAIL PROTECTED]
OK then.
Lets re-word the question ...
Has anyone been able to successfully enter text of a non-standard
character set ( Latin 1, UTF8 ) into Query Browser?
How about upload via a Perl script?
Yes you can insert those
NOT NULL default CURRENT_TIMESTAMP on update
CURRENT_TIMESTAMP,
`DateDay` tinyint(3) unsigned NOT NULL default '0',
`DateMonth` tinyint(3) unsigned NOT NULL default '0',
`DateYear` mediumint(8) unsigned NOT NULL default '0',
`CopyTitle` varchar(255) character set latin1 NOT NULL default
Info', the dialog
that appears tells me that the web page is using:
Content-Type: text/html; charset=iso8859-1
I've searched on 8859-1 and it's 'Latin'. My MySQL ( 4.1.14 ) table was
using the 'default' character set. I've had a look at the list of
options in MySQL-Administrator, and there's
Hi Daniel,
I'm trying to copy paste some data from a web page into MySQL ( and
How do you mean pasting into MySQL? Which program do you use on the
destination side? You can use clipboard to copy into mysql (the console
application), phpMyAdmin, some visual program, etc.
Anyway, if your
BÁRTHÁZI András wrote:
Hi Daniel,
I'm trying to copy paste some data from a web page into MySQL ( and
How do you mean pasting into MySQL? Which program do you use on the
destination side?
Query browser *and* an in-house Perl Gtk2 app both produce the same
results. I'm pretty sure I
OK then.
Lets re-word the question ...
Has anyone been able to successfully enter text of a non-standard
character set ( Latin 1, UTF8 ) into Query Browser?
How about upload via a Perl script?
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW
From: Daniel Kasak [EMAIL PROTECTED]
OK then.
Lets re-word the question ...
Has anyone been able to successfully enter text of a non-standard
character set ( Latin 1, UTF8 ) into Query Browser?
How about upload via a Perl script?
Yes you can insert those chars in MySQL using a perl
.
If I start the command line client like this:
mysql -uroot --default-character-set=utf8 -p
Then I get the result that I want. That is, ALL relevant variables are set
to utf8 or utf8_general_ci.
My question: how do I set the default character set in the options file?
What do I have to do to set
Hello.
Have a look here:
http://dev.mysql.com/doc/mysql/en/charset-upgrading.html
http://dev.mysql.com/doc/mysql/en/charset-conversion.html
MightyData wrote:
I have a database that was created with MySQL 4.0. The character set for
each table is latin1. I have upgraded the server
I have a database that was created with MySQL 4.0. The character set for
each table is latin1. I have upgraded the server to MySQL 4.1. I would like
to change the character set for each table to utf8. What is the correct
procedure? Can I just change the table character set with an alter statement
table with the data in tab delimited format. This gives
you an easy way to edit the create table statements to make sure each
table has the character set information you really want in it before
you import the data. Then you can do the import using cat *sql |
mysql database to create the tables
Hello,
We have installed the newest version of MySql and cannot get it to play nice
with French characters. Our older version worked fine. The problem may (or
may not) be that when we put the dump into the new database(yes its default
charset is Utf8) the default character set for the table
--default-character-set=latin2 -p xxx xxx.sql
mysql --default-character-set=latin2 xxx xxx.sql
3. mysqldump --opt -p xxx xxx.sql
iconv -f ISO_8859-2 -t UTF-8 -o xxx2.sql xxx.sql
mysql xxx xxx2.sql
and many more combination, try to read all docs, but can't find any
solutions.
another
--opt --default-character-set=latin2 -p xxx xxx.sql
mysql --default-character-set=latin2 xxx xxx.sql
3. mysqldump --opt -p xxx xxx.sql
iconv -f ISO_8859-2 -t UTF-8 -o xxx2.sql xxx.sql
mysql xxx xxx2.sql
and many more combination, try to read all docs, but can't find any
solutions
Dear all,
I am a Chinese and using Chinese in my MySQL databases.
On my old server, the version of MySQL is 3.23.58. And my new MySQL is
4.1.7.
On my old server, the MySQL works well with my Chinese contents.
However, after I transfer tables to the new server using:
mysqldump --opt database |
Hello.
First read:
http://dev.mysql.com/doc/mysql/en/charset.html
mysqldump could put SET NAMES 'utf8' at the beginning of the dump
file, check it and remove or perform a dump using --set-names=gbk.
Use --defaults-character-set=gbk for mysql client (or put correct
values
I need in depth information on the character set used by MySQL including
invisible/escape characters/codes. Is there online documentation that I
can read on this? Thanks.
- Asad
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Hello.
This page contains information about escape characters:
http://dev.mysql.com/doc/mysql/en/string-syntax.html
The general information about character set could be found at:
http://dev.mysql.com/doc/mysql/en/charset.html
Asad Habib [EMAIL PROTECTED] wrote:
I need in depth
Hi,
Thank you very much for the reply.
$dbh-do(SET character_set_results=ujis');
This works! Is there any way I can set this value on MySQL config file,
so I don't need to change all my scripts?
Right now my my.cnf looks like:
[mysqld]
default-character-set=ujis
default-collation
Hi,
I just moved my DB from 4.0 to 4.1.11. I used mysqldump to dump the data
first, and then inserted it to the new DB. The character set of the data
is EUC-JP (ujis).
My problem is, I can see the character correctly if I connect to mysql
server using mysql client. For example:
# mysql -e
Hello.
What do your 'show' statements return when you execute them from the
perl script?
Batara Kesuma [EMAIL PROTECTED] wrote:
Hi,
I just moved my DB from 4.0 to 4.1.11. I used mysqldump to dump the data
first, and then inserted it to the new DB. The character set
script?
Batara Kesuma [EMAIL PROTECTED] wrote:
Hi,
I just moved my DB from 4.0 to 4.1.11. I used mysqldump to dump the data
first, and then inserted it to the new DB. The character set of the data
is EUC-JP (ujis).
My problem is, I can see the character correctly if I connect
Hi
It's my first time using mysqldump.
[EMAIL PROTECTED] mysql]$ mysqldump -uroot --all-databases
backup_test.sql
mysqldump: File '/usr/share/mysql/charsets/?.conf' not found (Errcode:
2)
mysqldump: Character set '#33' is not a compiled character set and is
not specified in the '/usr/share
--all-databases backup_test.sql
mysqldump: File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2)
mysqldump: Character set '#33' is not a compiled character set and is
not specified in the '/usr/share/mysql/charsets/Index' file
[EMAIL PROTECTED] mysql]$
[EMAIL PROTECTED] mysql
]$ mysqldump -uroot --all-databases backup_test.sql
mysqldump: File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2)
mysqldump: Character set '#33' is not a compiled character set and is
not specified in the '/usr/share/mysql/charsets/Index' file
[EMAIL PROTECTED] mysql]$
[EMAIL PROTECTED
my first time using mysqldump.
[EMAIL PROTECTED] mysql]$ mysqldump -uroot --all-databases backup_test.sql
mysqldump: File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2)
mysqldump: Character set '#33' is not a compiled character set and is
not specified in the '/usr/share/mysql/charsets
PROTECTED] mysql]$ mysqldump -uroot --all-databases backup_test.sql
mysqldump: File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2)
mysqldump: Character set '#33' is not a compiled character set and is
not specified in the '/usr/share/mysql/charsets/Index' file
[EMAIL PROTECTED] mysql
.
[EMAIL PROTECTED] mysql]$ mysqldump -uroot --all-databases backup_test.sql
mysqldump: File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2)
mysqldump: Character set '#33' is not a compiled character set and is
not specified in the '/usr/share/mysql/charsets/Index' file
[EMAIL PROTECTED] mysql
lines --]
Hi
It's my first time using mysqldump.
[EMAIL PROTECTED] mysql]$ mysqldump -uroot --all-databases backup_test.sql
mysqldump: File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2)
mysqldump: Character set '#33' is not a compiled character set and is
not specified in the '/usr
Is it possible to change the character set just for an individual table and
if so which character set should I try to display this european characters?
Cheers,
Lee
- Original Message -
From: Sumito_Oda [EMAIL PROTECTED]
To: Lee Denny [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent
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.
for the appropriate language
number. There isn't, however, an xml file for the language (utf8 in
this instance). I've tried changing the server default character set to
cp1251. I've recreated complete databases from scratch making sure that
the character set it uses is cp1251. None of the above have
Description:
I installed MySQL-server-4.0.15-0 and am getting the following error
message:
050330 12:09:32 [ERROR] Character set information not found in
'/usr/share/mysql/english/errmsg.sys'. Please install the latest version of
this file.
050330 12:09:32 [ERROR] Aborting
How-To-Repeat
in the Index file for the appropriate language
number. There isn't, however, an xml file for the language (utf8 in
this instance). I've tried changing the server default character set to
cp1251. I've recreated complete databases from scratch making sure that
the character set it uses is cp1251
1 - 100 of 280 matches
Mail list logo
