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
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,
it
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. If no
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
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');
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
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 '%ó%';
Hello.
But anyway, the source *IS* latin1, so maybe this shouldn't be a
problem anyway?
In theory if the source contains only characters from latin1 set
there shouldn't be any problems, but are you sure that you're inserting
latin1 characters? What is your locale settings? If you
Hello.
I've been able to insert Russian characters (utf8) through the
QueryBrowser under Linux (FC4). Please, could you provide CREATE
statement for you table and output of:
show variables like '%char%';
As far as I know, QueryBrowser invokes SET NAMES 'utf8' by default.
And the only
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
Gleb Paharenko wrote:
Hello.
I've been able to insert Russian characters (utf8) through the
QueryBrowser under Linux (FC4). Please, could you provide CREATE
statement for you table
CREATE TABLE `WebNewsPostings` (
`PRID` mediumint(8) unsigned NOT NULL auto_increment,
`MyStamp` timestamp
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
Need more information... what exactly is Our older version, and
what exactly is the newest version of MySql, without this it's hard
to know what issues you may be facing... I imagine you are on 4.0.n
for the old and 4.1.n for the new... but we can't really tell from
the information you
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 for
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
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 of the
Hi,
you may use somethinh lik ethis :
$dbh-do(SET character_set_results=ujis');
look at http://dev.mysql.com/doc/mysql/en/charset-general.html
Hope that helps
Mathias
Selon Gleb Paharenko [EMAIL PROTECTED]:
Hello.
What do your 'show' statements return when you execute them from the
perl
: 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,
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
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
Nikolas,
Friday, October 18, 2002, 5:56:10 AM, you wrote:
NG I have written a web application that is hosted in a server which uses
NG the default character set. This causes problems in the sorting that
NG MySQL does because most of the data is in Greek. When developing it
NG locally, I run
Dear George,
I use to have problems with Greek Chars and after hundreds of hours of
testing i can assure you that the only solution is to compile Mysql using
as default char-set the Greek char-set.
Thus if your are using mysql for Linux you have to add to the .configure
parameters the
-Original Message-
From: Nikolaos Georgiafentis [mailto:[EMAIL PROTECTED]]
Sent: ÔåôÜñôç, 25 Óåðôåìâñßïõ 2002 10:41 ðì
To: Nikoloudis George ([EMAIL PROTECTED])
Cc: [EMAIL PROTECTED]
Subject: Re: Character Set Settings
Dear George,
I use to have problems with Greek Chars and after hundreds
.
-Original Message-
From: Nikoloudis George ([EMAIL PROTECTED])
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 25 September 2002 5:54 pm
To: Nikolaos Georgiafentis
Cc: [EMAIL PROTECTED]
Subject: RE: Character Set Settings
Dear Nikos
I run the below --defult-character-set=ISO-8859-7
, September 25, 2002 4:54 PM
Subject: RE: Character Set Settings
Dear Nikos
I run the below --defult-character-set=ISO-8859-7 and when I insert into the
database like
insert into test values('ÄÕÏ');
when I select:
mysql select * from test
- ;
+--+
| data |
+--+
| åíá |
| ÅÍÁ |
| ÄÕÏ
Mob.: +30 972 03 60 06
-Original Message-
From: kayamboo [mailto:[EMAIL PROTECTED]]
Sent: ÔåôÜñôç, 25 Óåðôåìâñßïõ 2002 11:08 ðì
To: [EMAIL PROTECTED]
Cc: list mysql
Subject: Re: Character Set Settings
What you mean by explorer pages? Browser?
If so you have to set
Óåðôåìâñßïõ 2002 10:41 ðì
To: Nikoloudis George ([EMAIL PROTECTED])
Cc: [EMAIL PROTECTED]
Subject: Re: Character Set Settings
Dear George,
I use to have problems with Greek Chars and after hundreds of hours of
testing i can assure you that the only solution is to compile Mysql using
as default char
[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
Hi.
I have installed SuSE Linux 8.0 Proffessional and the MySQL that came with
it. If anyone of you has done the same he must have realized 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
On Thu, 5 Sep 2002, National Theater of Greece wrote:
Hi.
I have installed SuSE Linux 8.0 Proffessional and the MySQL that came with
it. If anyone of you has done the same he must have realized that many of
the files are quite different than the files of MySQL that came with the
standard
I had the same problem with greek characters. I set
field as binary and the problem corrected.
--- National Theater of Greece [EMAIL PROTECTED] :
Hi.
I have installed SuSE Linux 8.0 Proffessional and
the MySQL that came with
it. If anyone of you has done the same he must have
realized
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, and is not
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. There
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,
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
Mark W. de Raad writes:
Good afternoon,
We have an not-so-unusual problem where people are accessing a database from
different countries (in this example, Germany and the UK). One of the search
terms commonly used is: gehäuse (housing), which the UK types in as gehause
and Germany (rightly
Ian,
I may be way off the mark here, but I've found MySQL usually starts quoting
the line from the place at which the error occurred, thus indicating it
didn't like the "insert" part. Not being able to see the preceding lines I
can only suggest it may not have an active database to write to.
54 matches
Mail list logo