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
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.
start your mysql server with different --character
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 dete
lp me out the best.
> >
> >
> > Current 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
> >
>
Uma,
On Mon, Jun 1, 2009 at 8:41 AM, Uma Bhat 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:
> DEF
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
opy 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
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
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;
>
> S
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 <[EM
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 [ERR
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
**
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 as
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 collati
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 http://lists.mysql.co
nt: Sunday, April 27, 2008 6:01 AM
>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 Ne
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:
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 goe
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 col
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?
>
SH
p.com
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 DuB
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
nal Message-
>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
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 cha
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
-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
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 o
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, the
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...
Bar
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
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
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
he 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 not.
>>
>> Regards,
>>
>>
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
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 t
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]
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
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 basicall
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, ba
ob. ;)
CREATE TABLE 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(3
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_database
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
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&#x
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 ha
server level (in my.cnf) but I want to
> set 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 foll
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 DEFAULT CHARACTER SET utf8 COLLATE
utf8_general_ci;
After the query a du
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.
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.
>
> Assum
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
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 s
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
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 l
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 to
USING latin1))) |
+-+
| binary |
+---------+
1 row in set (0.00 sec)
In Japan, we have to use many kinds of character set.
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
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 -
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
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 ar
cale settings? If you can, 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&#
stamp 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) ch
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?
Ye
t; 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?
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This
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 y
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
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 m
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 d
ge and select 'View Page 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
all times.
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
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 upgrad
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
nd, and a .txt
file for each 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 |
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 is
xxx.sql
2. mysqldump --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
l
2. mysqldump --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 do
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
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 | m
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 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
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-chara
' 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
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
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
gt;>
>>Gu Lei <[EMAIL PROTECTED]> wrote:
>>
>>
>>
>>
>>>[-- text/plain, encoding 7bit, charset: us-ascii, 23 lines --]
>>>
>>>Hi
>>>
>>>It's my first time using mysqldump.
>>>[EMAIL PROTECTED] mysql
g 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/mysq
g 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/chars
n, encoding 7bit, charset: us-ascii, 23 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:
> [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
CTED] 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/charset
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
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
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
>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] Abo
> Again, thanks, but that doesn't actually solve the issue.
> There are entries 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
tries 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 s
1 - 100 of 287 matches
Mail list logo
