Hi,
Try the format below:
ALTER DATABASE mybase DEFAULT CHARACTER SET = latin1;
ALTER DATABASE mybase DEFAULT COLLATE = latin1_swedish_ci;
HTH ...
- Original Message -
From: "Mário Gamito" <[EMAIL PROTECTED]>
To: "MySQL List"
Sent: Monday, April 09, 2007 4:19 PM
Subject: charset
Hi,
User can also specify character set during the SELECT operation also with
CHARACTER SET or charset.
Use mysql>charset utf 8
before issuing SELECT query.
For Instance:
If you do not say SET NAMES or SET CHARACTER SET, then for SELECT column1 FROM
t, the server sends back all the values
Yes Ryan,
Shawn is wright... this is dark art... and few are experimenting it !
I did some dark art because of my need to get into *latin2
(latin2_general_ci)*.
Even though is adark art I do still there are people who know to answer
you... but i believe you were to vague...
Please be *more* specif
"Ryan Stille" <[EMAIL PROTECTED]> wrote on 03/09/2006 09:59:32 AM:
> Are my emails not coming through? Or is this question way too 'newbie'
> and no one wants to touch it?
>
> -Ryan
>
> Ryan Stille wrote:
> > I'm still hoping someone can else can share their input on this.
> >
> > What do othe
Are my emails not coming through? Or is this question way too 'newbie'
and no one wants to touch it?
-Ryan
Ryan Stille wrote:
> I'm still hoping someone can else can share their input on this.
>
> What do other people usually do as far as the collation setting?
>
> Thanks,
> -Ryan
>
> Ryan St
I'm still hoping someone can else can share their input on this.
What do other people usually do as far as the collation setting?
Thanks,
-Ryan
Ryan Stille wrote:
> When we migrated to MySQL from MS SQL, I left everything set
> to the default as far as collations - latin1_swedish_ci.
> This was
;character_sets';
statement.
OKAN ARI wrote:
> yes it is mysql 4.0 how can I set i to latin 5 or how can I set the
> server to latin 5?
>
> os: centos 4.2
>
> Thank you
> - Original Message - From: "Gleb Paharenko"
> <[EMAIL PROTECTED]>
> To:
&
yes it is mysql 4.0 how can I set i to latin 5 or how can I set the server
to latin 5?
os: centos 4.2
Thank you
- Original Message -
From: "Gleb Paharenko" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, January 31, 2006 1:40 PM
Subject: Re: charset
Hello.
In case my
Hello.
In case mysql4 is mysql4.0 there should be a server system variable
default_character_set. If it is 4.1 see:
http://dev.mysql.com/doc/refman/4.1/en/charset-syntax.html
http://dev.mysql.com/doc/refman/4.1/en/charset-connection.html
OKAN ARI wrote:
> How can I set the characterset to la
Hello.
> Chinese can't be displayer propely.
What client do you use to connect to MySQL Server?
Check that it supports Chinese. I don't know Chinese
and can't suggest what character to use. But, certainly,
you should choose one from:
http://dev.mysql.com/doc/mysql/en/charset-asian-sets.
Also the good way of doing conversion itself is mysqldump table
structure, then import the dump, launch mysql command line utility (or
use phpmyadmin for that) and alter encoding on database and all needed
tables and columns, then mysqldump the first database using utf8
charset (without dropping ta
First, check if actual data in your tables after this conversion is
really properly encoded. Launch your mysql command line client,
execute
SET NAMES latin1;
and do some selects on your table data to see if it's readable.
If it is, then all you need is to make PHP use latin1 when reading
data from
Hello.
Similar question has been asked already. See:
http://lists.mysql.com/mysql/179154
"Stephane Savage" <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> Which charset and collatio would be the most suitable for a french /
> english system?
>
> Thanks
>
> Stephane
>
--
For t
Finally I found the solution.
Just short note for everybody who has problem with LOAD DATA INFILE and
correct charset of the file. Loaded file must have SAME charset as DATABASE
which contains target table of LOAD DATA command. Target table charset
doesn't matter. I didn't find any note about it
At 18:13 +0200 9/15/04, Marten Lehmann wrote:
Hello,
in 4.0.20 I was happy that German Umlauts are
sorted correctly (ä -> ae, ö -> oe, ü -> ue).
With 4.1.4 the configuration stops:
checking "character sets"... configure: error:
Charset 'latin1_de' not available. (Available
are: binary ascii ar
Hello Xavier,
can't you do the transforming of your keywords before doing the query ?
to transform all special characters in php it would be :
$keywords = strtr($keywords,"éè^éëàãâä","_");
add other special characters and a JOKER sign in mysql '_' for each.
Cheers,
Damien
--
Make sure you're using the latest version of the driver (2.0.14 right now)
from http://mmmysql.sourceforge.net/
Also, make sure you add "useUnicode=true" to your URL if you're not going to
be using straight ASCII.
-Mark
- Original Message -
From: "Daniel Flöijer" <[EMAIL PROTECTED]>
Hi,
I would love to be forwarded any messages that people send you
about this issue, as I'm in a very similar situation to you.
On Mac OSX, we have a database into which we "feed" texts files
of sql with the Spanish characters intact, but then in the
database the accent marks and such don't sho
Hi Silver
I've never tried changing character sets myself but you did download the
right version and I mean source not binaries of 3.23.32?
You know you can also get away with using the default charset as Chinese
chars are sorted in ASCII anyway. Only problem is, you need a Chinese front
end to
19 matches
Mail list logo
