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
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. I
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 no character set is shown for the column
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 char(5)
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
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');
T
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
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 ca
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 NOT
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 tho
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 wa
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
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, Aus
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
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 character_s
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=ujis_ja
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 t
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 th
]>
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.
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
"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
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
t...
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
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
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 is included in an other page?
>If is not then try to put also all the required html tag
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 is
Fax: +30 10 667 97 97
>Greece Mob.: +30 972 03 60 06
>
>
>
>-Original Message-
>From: Nikolaos Georgiafentis [mailto:[EMAIL PROTECTED]]
>Sent: Τετάρτη, 25 Σεπτεμβρίου 2002 11:33 πμ
>To: Nikoloudis George ([EMAIL PROTEC
])
Cc: [EMAIL PROTECTED]
Subject: RE: Character Set Settings
Fear George,
try putting '' in the header section of your
page. Keep me informed
At 10:54 AM 9/25/2002 +0300, you wrote:
>Dear Nikos
>
>I run the below --defult-character-set=ISO-8859-7 and when I insert into
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
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 the
t;[EMAIL PROTECTED]>
Sent: Wednesday, 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
rding.
> -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
>
>
+30 972 03 60 06
-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 an
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 followi
I had the same problem with greek characters. I set
field as binary and the problem corrected.
--- National Theater of Greece <[EMAIL PROTECTED]> &eacgr;&ggr;&rgr;&agr;&psgr;&egr;: >
Hi.
> I have installed SuSE Linux 8.0 Proffessional and
> the MySQL that came with
> it. If anyone of you has do
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
> standar
> 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
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.
Vy>else
Vy> If i write
Vy> mysqld --default-character-set latin5
Vy>it gives the error mes
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 speci
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, 200
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 is
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 (ri
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.
Whe
54 matches
Mail list logo