Hi,
I just realized that the problem is that I also need to specify
charset for load data. Once the utf8 is specified for 'load data',
then the problem is solved. Please ignore my previous email. Thanks!
~/linux/test/mysql/mysql/LOAD_DATA/CHARACTER_SET$ cat main.sql
use test
CREATE
Hi,
I have the greek character "Β" (not that it is different from the
English character "B", although they look similar. Copy both of them
and type in google search box, you will see different search
suggestion pop up).
utf8 in mysql seems doesn't work. I'm wonde
hat I like about UTF-8.
But sorting does not work. And, related to that, comparisons neither.
I'm getting the hopefully silly notion that there is no collation for
CHARSET=UTF-8 that could sort according to the rules of GB2312 (which,
if it was true, would probably an interesting story to expla
Hello,
is it a bug or a feature that if building mysql 5.5.8 from source with the
options 'cmake . -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci'
the charset in include/config.h remains latin1:
#define MYSQL_DEFAULT_CHARSET_NAME "latin1"
#define MYSQL_DE
On Wed, Feb 3, 2010 at 6:33 PM, Thiyaghu CK wrote:
> Hi Moli,
>
> I hope this is because there is spelling mistake. It should be
> '--with-extra-charsets=all', but you have given
> '--with-extral-charsets=all'. That's why only the utf8 has been installed
> and not the other charsets.
>
Thanks a
d, Feb 3, 2010 at 2:26 PM, wrote:
> Hello,
>
> I have a strange problem on the charset on mysql.
> I'm using mysql-5.0.45, compiled from the source, and enabled:
> '--with-charset=utf8' '--with-extral-charsets=all'
> when compiling it.
>
> My defau
Hello,
I have a strange problem on the charset on mysql.
I'm using mysql-5.0.45, compiled from the source, and enabled:
'--with-charset=utf8' '--with-extral-charsets=all'
when compiling it.
My default charset in my.cnf is utf8:
character-set-server=utf8
OK I logined i
Hello,
I am getting an error
#HY000Incorrect string value: '\xE9l\xE9tra...' for column '
Not quite sure why. hex E9 is a lower case e acute found in CP1252
and googling seems to tell me that the latin1 charset that I have set for the
table should display this OK.
mysql V 5.
Hello list,
I have a table whose 'default charset=utf8'.
I insert a record into it with non-utf8 charset,like GBK.Then I select
this record,it print GBK characters correctly.
Then I insert a utf8 record into it,and read this record in scripts and
decode it with utf8_decode,the resu
|
| cçoôeêeèeëi | 3 |
| EÉEÈEË | 4 |
| c'est tout | 5 |
+++
mais si je fais :
mysql> charset latin1;
les accents sont là oú il faut, mais pas l'alignement des colones...
mysql> select nom,id f
i | 3 |
| EÉEÈEË | 4 |
| c'est tout | 5 |
+----++
mais si je fais :
mysql> charset latin1;
les accents sont là oú il faut, mais pas l'alignement des colones...
mysql> select nom,id from t;
+--
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, 200
Hi,
I have this database with utf-8 charset.
How can i change it to latin1 ?
I've seen the MySQL pages and run in the MySQL prompt:
ALTER DATABASE telbit CHARACTER SET latin1 COLLATE latin1_swedish_ci;
but i get an error saying that i have an error in my syntax.
Any help would be apprec
Hi,
I know about CONVERT but I wanted to check character set of 'tt' column
and this result use in CONVERT. Something like CONVERT(id USING
CHARSET(Name))
which doesn't work.
It wont. the syntax is -- CONVERT(expr USING transcoding_name); its the
name of the transcode and n
I know about CONVERT but I wanted to check character set of 'tt' column
and this result use in CONVERT. Something like CONVERT(id USING
CHARSET(Name))
which doesn't work.
I just wonder why CONCAT(1, ',', Name) works OK even if CHARSET(1) is
binary string and CONC
Hi,
It is that, what you think a binary is ,...is indeed a binary.
As per the manual, If a string input or function result is a binary string,
the string has no character set or collation.
so the resultant 'binary' is expected.
if u want the resultant as:
mysql> select char
Hi,
I'm using MySQL 4.1.15, WinXP and my problem is that
SELECT CHARSET(CONCAT(int_column, string_column)) FROM mytable;
always returns charset 'binary' and I need resulting charset to be same
as a charset of a string_column because I don't want to look for
charset of a co
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
Hi,
I have a database where the database character set is utf-8 and some rows
are ascii.
I want to save the results of some queries, and SELECT ... INTO OUTFILE
looks like an easy way to do it. But I need the output in ucs-2. Is there
any way to specify the charset for SELECT ... INTO OUTFILE
nd a text field where the table has been
defined to use :
ENGINE=ndbcluster DEFAULT CHARSET=latin1
Now, through my php user interface, I find that I can update/insert Korean
characters into the database table and successfully retrieve them from the
database.
I'm using microsoft'
* specific on your problem.
What is the server default charset and collation ?
What is the database default charset and collation ?
What charsets and collations are the tables and/ or even the columns you
were talking about ?
Finally I didn't found any ColdFusion secific connector... so I assume
> default as far as collations - latin1_swedish_ci.
> >> This was based on digging through the manual and google. But now I am
> >> migrating the application to a newer version of ColdFusion and am
> >> running into some issues with charsets on some ColdFusion functi
on to a newer version of ColdFusion and am
>> running into some issues with charsets on some ColdFusion functions.
>> I am wondering if my database charset has anything to do with it.
>>
>> What do other people usually do as far as the collation setting?
>>
&
> This was based on digging through the manual and google. But
> now I am migrating the application to a newer version of
> ColdFusion and am running into some issues with charsets on
> some ColdFusion functions. I am wondering if my database
> charset has anything to do with it.
some ColdFusion functions. I am wondering if my
database charset has anything to do with it.
What do other people usually do as far as the collation setting?
We are in the US, but do have a few sites that make use of German and
Spanish characters.
Thanks,
-Ryan
--
MySQL General Mailing List
;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
How can I set the characterset to latin5 for mysq4 in linux?
OKAN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
; mysql our_database < our_command.sql
>
> and it displays both english and koi8r fine on screen.
>
> It was comiled: configure --with-charset=koi8r
>
> mysq 5.0.16 acts the same. 4.0 and earlier always worked fine.
>
> Is there a way to disable the utf-i
ith-charset=koi8r
mysq 5.0.16 acts the same. 4.0 and earlier always worked fine.
Is there a way to disable the utf-i in 4.1.16?
Thanks for any help or direction.
Kirill
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EM
For Archivum
My destination was: Changing default latin1 charset to latin2 and the default
collation to latin2_hungarian_ci.
I tried to configure accross my.cnf, but all of my effort failed.
I installed mysql-administrator, use startup paramters in. Change mysqldump .
Took changes and
Hi,
I've installed MySQL 4.1.10 and phpMyAdmin-2.6.4-rc1 on a RHEL4 box.
And I found that phpMyAdmin forces the character set of pages utf-8.
Though I knew that phpMyAdmin-2.5.7 can work well with gb2312, I want
to make phpMyAdmin work well too.
Anybody knows that how to make phpMyAdmin work with
suituation. i've installed mysql 4.1.12 on WinXP
plantform, it seems not to support Chinese by its default
configuration, say, Chinese can't be displayer propely. as far as i
know, what i need to do is modify the charset(server, connection,
client...)concerned, but i'm not so su
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/mysq
hi all.
Here is the suituation. i've installed mysql 4.1.12 on WinXP
plantform, it seems not to support Chinese by its default
configuration, say, Chinese can't be displayer propely. as far as i
know, what i need to do is modify the charset(server, connection,
client...)concerned, but
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
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
ING latin1) FROM old_db.table;
When doing a
SELECT CHARSET(field) FROM new_db.table;
It returns "latin1", so everthings seems to be A-Okay - but since
I'm posting this message you could prolly guess that it didn't -
and right, it failed...
Using SSH to the mysql-server, and us
haracter set latin1 collate latin1_bin NOT
> NULL default '',
> `grouping` varchar(64) character set latin1 collate latin1_bin NOT
> NULL default '',
> `key` varchar(255) character set utf8 collate utf8_bin NOT NULL
> default '',
> `afftraf` va
NULL
default '',
`afftraf` varchar(5) character set latin1 collate latin1_bin NOT NULL
default '',
`sum` int(10) unsigned NOT NULL default '1',
PRIMARY KEY
(`day`,`type`,`client`,`channel`,`campaign`,`grouping`,`key`,`afftraf`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
Hello.
Please, send the output of the following statement executed both on
master and slave:
show variables like '%char%';
Send the definition of your table as well:
SHOW CREATE TABLE sum_day_key_requests;
Marco P$hler <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I try to repl
Am Dienstag, den 09.08.2005, 17:57 +0400 schrieb Alexey Polyakov:
> If charsets/collations are not set explicitly in my.cnf, server could
> be using ones specified during compilation.
> To check charsets and collations on the running server do:
> show global variables like 'c%';
Thanks.
I execute
> The only idea, which came into my mind, is that the server use different
> default charsets or collations. I checked the configurations and can't
> find a difference. Is there a possibility to check the default charsets
> and collations on the running server ?
If charsets/collations are not set
Hi,
I try to replicate an existing database to a new server and run into
trouble with collations. Maybe somebody can help me.
Existing DB-Server (Master):
MySQL Version 4.1.12
ca. 100 GB Database size.
New DB-Server (Slave):
MySQL Version 4.1.12
Here is what I did to get the replication up and
Privet!
Yogesh wrote:
HI,
I have a client that runs php+mysql application and it has a problem with "ORDER BY
some_varchar_field" sql expression. The DB is in russian cp1251 encoding and "order
by" doesnt produce an alphabetically ordered result. our mysql server defaul
HI,
I have a client that runs php+mysql application and it has a problem with
"ORDER BY some_varchar_field" sql expression. The DB is in russian cp1251
encoding and "order by" doesnt produce an alphabetically ordered result. our
mysql server default charset is latin1 and
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?
>
> Tha
Hi all,
Which charset and collatio would be the most suitable for a french /
english system?
Thanks
Stephane
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ed to character set? Please provide
more information about the problem and if it is possible send a test
case.
Vivian Wang <[EMAIL PROTECTED]> wrote:
> [-- text/plain, encoding 7bit, charset: us-ascii, 132 lines --]
>
> the version is 4.1.12.
> s
mysql version 3.23.??, l have the flat file row
length is 30+4+4=38.
When I use mysqldump mysql verson 4.1.12, I have the flat file row
length is 30+11+11=52.
I tried mysqldump --set-charset=latin2, I still got a row length=52.
What I should do?
Gleb Paharenko wrote:
Hello.
I've t
Hello.
> Any possible problems with this approach?
It is good, if it solved your problems.
>> So it works for me.
>
> I've ended doing this in a different way. I've created a patch which forces=
> a=20
> file to be read - /etc/mysql/mysql-client.conf (which is the same as .my.cn
On Monday 11 of July 2005 16:24, Gleb Paharenko wrote:
> Hello.
>
> I've tested your solution. It doesn't work for users which have SUPER
> privilege. This mentioned at:
> http://dev.mysql.com/doc/mysql/en/server-system-variables.html
>
> However, it works with with ordinary users which don't hav
Hello.
I've tested your solution. It doesn't work for users which have SUPER
privilege. This mentioned at:
http://dev.mysql.com/doc/mysql/en/server-system-variables.html
However, it works with with ordinary users which don't have SUPER
privilege. Here are pieces of my my.cnf (the init_co
On Thursday 07 of July 2005 00:16, Gleb Paharenko wrote:
> Hello.
>
>
> For a pity, I could give explanations only for your query about
> selecting @@global.xxx variables. I think server returns correct
> results, because you're selecting global variables, while
> character_set_client, character_se
Hello.
For a pity, I could give explanations only for your query about
selecting @@global.xxx variables. I think server returns correct
results, because you're selecting global variables, while
character_set_client, character_set_connection, character_set_results
are session variables. A
Hi,
I have mysql 4.0 db with configuration:
set-variable = default-character-set=latin2
set-variable = character-set=latin2
now I'm trying to migrate to mysql 4.1.12 My current config is:
character-set-server=latin2
collation-server=latin2_general_ci
The problem is connection/reply/client-chara
rted with the default charset 'koi8r' and I have
the following problem: when connecting from PHP, the default
results and connection charsets become latin1, so all not-latin characters
get lost (they are displayed as ?). Of cause, if I explicitely set these
charsets to koi8r in the PHP scripts af
Privet.
As I know, PHP usually takes the character set from the server.
Please send part of your configuration file related to character sets.
Varshavchick Alexander <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have mysql 4.1.12 started with the default charset 'koi8r
Hi,
I have mysql 4.1.12 started with the default charset 'koi8r' and I have
the following problem: when connecting from PHP, the default
results and connection charsets become latin1, so all not-latin characters
get lost (they are displayed as ?). Of cause, if I explicitely
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
Hello,
I'm trying to convert tables from Paradox DBs to MySQL and I have a big problem
with setting correct character set. I created small application which generates
csv files which are in cp1250 (I can't change it, it's charset ofmy Paradox
DBs). My databases and tables
Hello.
The general way to order a MySQL client to use some encoding
is to execute SET NAMES 'encoding'. See:
http://dev.mysql.com/doc/mysql/en/charset-connection.html
But, as said at:
http://bugs.mysql.com/bug.php?id=6982
Query Browser starts a new session for every
How can I configure Mysql Query Browser with charset latin5?
Thanks..
-
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
Original Message
From: "Oddvar Kragseth" <[EMAIL PROTECTED]>
To: ; <[EMAIL PROTECTED]>
Sent: Sunday, February 13, 2005 3:35 PM
Subject: Importing a separated file into mysql, national charset
problem??
> I'm importing a file into mysql.
>
> Most w
I'm importing a file into mysql.
Most work fien, but numbers are given like this :
`487,90`116,40`4467,00`
This creates a problem, as the decimal numbers are NOT read... i.e i get 487.00
, 116.00 in my database.
Is this a "national" problem as we use komma as a decimal seperator in Norway?
Do
Hi,
sometime ago my boss imported a dump into a base using Cocoa MySQL on
Mac. Unfortunatly he switch the charset from ISO-8859-1 to something
wrong, probably UTF-8. From this time we have such weird characters in
our fields : FerrandiËre instead of Ferrandière, CitÈ instead of Citée
and so on
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.
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 armscii8 ascii big5
on your server.
You will find the used charset in the
'character_set' variable.
You can also use the query "SHOW VARIABLES LIKE
'character_set'" which
will directly match what you want.
Yves wrote:
Hello,
How can I see what char set is being used as the
default cha
amount
of lines..
thanks,
Yves A
--- Jean-Marc PULVAR <[EMAIL PROTECTED]> wrote:
> You can see it by executing the "SHOW VARIABLES"
> query on your server.
> You will find the used charset in the
> 'character_set' variable.
>
> You can also use the
You can see it by executing the "SHOW VARIABLES" query on your server.
You will find the used charset in the 'character_set' variable.
You can also use the query "SHOW VARIABLES LIKE 'character_set'" which
will directly match what you want.
Yves wrot
Hello,
How can I see what char set is being used as the
default char set on the server or database?
Also, is there a way to change the default setting?
Thanks,
Yves
__
Post your free ad now! http://personals.yahoo.ca
--
MyS
Hi Tobias,
> On Tue, 6 Jan 2004, Martijn Tonies wrote:
>
> > Hi,
> >
> > In MySQL 4.1, is there a function to know what the
> > current default server-wide characterset is?
>
> You can find all those with:
> SHOW VARIABLES LIKE 'character_set%'
Thanks, that'll do the trick.
Is there any reason
On Tue, 6 Jan 2004, Martijn Tonies wrote:
> Hi,
>
> In MySQL 4.1, is there a function to know what the
> current default server-wide characterset is?
You can find all those with:
SHOW VARIABLES LIKE 'character_set%'
cheers,
Tobias
--
MySQL General Mailing List
For list archives: http://lists.m
Hi,
In MySQL 4.1, is there a function to know what the
current default server-wide characterset is?
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com
--
MySQL General Mailing List
For lis
Hi,
Is altering a table and column supported for the
characterset/collation?
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com
--
MySQL General Mailing List
For list archives: http://list
ET 'latin1'
031218 17:57:19 Aborting
031218 17:57:19 ../sql/mysqld: Shutdown Complete
Error executing mysqld --bootstrap
Error: Could not install master test DBs
make: *** [test] Error 1
#v-
Why is the collation not valid for charset latin1? It certainly
should be...
Greetings fro
Can I put a new charset or modify an existing one without recompiling MySQL?
If yes, please tell me how.
Thanks Anticipated,
Iulian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
t;
> Sent: Monday, July 28, 2003 10:00 PM
> Subject: Please HELP Romanian charset Collate in MySQL
>
>
> > Hello,
> >
> > Simply I made a table with romanian characters "aAîÎâÂsStT". I tried to
> > sort
> > it, in fact to order it in a query.
&g
D]>To: "MySQL LIST" <[EMAIL PROTECTED]>Sent: Monday, July 28, 2003 10:00 PMSubject: Please HELP
Romanian charset Collate in MySQL> Hello,>>
Simply I made a table with romanian characters "aAîÎâÂsStT". I tried to>
sort> it, in fact to order it in a query
Iulian,
take the source code, go to 'sql/share/charsets' and create your own
character set 'romanian.conf' departing from 'latin2.conf' (or whatever is
closest to what you need).
Regards,
Thomas Spahni
On Mon, 28 Jul 2003, Primaria Falticeni wrote:
> Hello,
>
> Simply I made a table with romani
Hi!
On Jul 28, Primaria Falticeni wrote:
> Hello,
>
> Simply I made a table with romanian characters "aAsStT". I tried to
> sort it, in fact to order it in a query.
>
> How can I do this? Please give me an example at how can I change the
> latin2.conf in a romanian one to fairly sort the
Hello,
Simply I made a table with romanian characters "aAîÎâÂsStT". I tried to
sort
it, in fact to order it in a query.
I settled the default_charset to some charsets:
latin1(default)(latin2 win1250(central european))
ÎteIbur
Ibur Îte
Ito
Hello,
Simply I made a table with romanian characters "aAîÎâÂsStT". I tried to sort
it, in fact to order it in a query.
I settled the default_charset to some charsets:
latin1(default)(latin2(iso-8859-2 I think) the same like
win1250(central european))
SteSbur
Sbur
SQL syntax near
'CHARSET=latin1 ROW_FORMAT=DYNAMIC
COMMENT='Inneholder abonnementdata'' at line 38
(113 ms taken)
The create table query is as follows
CREATE TABLE `abonnenter` (
`id` int(11) NOT NULL auto_increment,
`navn` varchar(100) NOT NULL default '',
`abonr
SQL syntax near
'CHARSET=latin1 ROW_FORMAT=DYNAMIC
COMMENT='Inneholder abonnementdata'' at line 38
(113 ms taken)
The create table query is as follows
CREATE TABLE `abonnenter` (
`id` int(11) NOT NULL auto_increment,
`navn` varchar(100) NOT NULL default '',
On Wednesday 02 April 2003 20:30, Pratchaya Chatuphian wrote:
> I use MDK 9.0 and installed MySQL 4.0.12 Max ... sir
> How can i change charset sir ?
> i want to use tis-620 .. sir
> Any one can help me sir ... ?
>
> Just mean change the my.conf ? ( my-small.con
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Inserting blob in database with gbk charset
may cause error or data corruption
Description:
When mysql's sql statement lexer (sql/sql_lex.cpp))
analyzes a sql string, it uses the my_ismbchar macro
on the default charset structu
I use MDK 9.0 and installed MySQL 4.0.12 Max ... sir
How can i change charset sir ?
i want to use tis-620 .. sir
Any one can help me sir ... ?
Just mean change the my.conf ? ( my-small.conf , my-medium.conf , )
to add
[client]
default-character-set=character-tis620 ? just do
On Tuesday 01 April 2003 23:34, Pratchaya Chatuphian wrote:
> I use MDK 9.0 and use MySQL installed with RPM Package
>
> How can i change or set new charset on mysql .
>
> Caz , i want to use tis620 charset ..
>
> I live in thailand and must use charset that i can sort m
I use MDK 9.0 and use MySQL installed with RPM Package
How can i change or set new charset on mysql .
Caz , i want to use tis620 charset ..
I live in thailand and must use charset that i can sort my data correctly on my MySQL
... sir
Thank u for advance sir .
[EMAIL PROTECTED
Hello!
When I run mysql with default-charset = estonia, it makes difference
between upper and lower case. With latin1 charset no such distinction are
made. Could someone clarify for me, is it bug?
--
Lauri Anton
( [EMAIL PROTECTED] )
( +3727302126 )
- estonia -
Server version
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
--
; character is handled as the "e" character.
and the query "élégant" finds "elegant".
A very common problem I think, but until now I have no
simple solution (and find nothing interesting on the Net) !
I read the MySQL manual about the charsets and their handling.
It s
Hello
when using mysqlcc and adding for russian symbols into database fields,
it represents as "??"
When using other client - all is o'k.
the repeatable steps are:
1. open mysqlcc
2. open some table
3. enter in the field of type "string" some russian letters
4. uddate this record
5. see the "
Hi,
I have problem with charset (MySQL + Delphi).
--
SET CHARACTER SET cp1250_latin2;
SELECT * FROM en1 WHERE en1 LIKE 'worm';
--
This query works right in PHP and command line (Linux, Windows),
but in Delph
gt;
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, November 26, 2002 12:30 PM
Subject: Re: New charset for MySQL
>Hi!
>
>
> What is "Bengali" character set? Does it have a Unicode
> mapping table like for example this one:
>
> ftp://ftp.unicode.org/Public/MAPPINGS/ISO885
TECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, November 26, 2002 1:03 PM
Subject: RE: New charset for MySQL
> Bengali is the script used in many Indian languages, like Hindi.
>
> A search on google turned up a lot of pages written using Bengali, a
> good example is http://w
]
> Subject: Re: New charset for MySQL
>
>Hi!
>
>
> What is "Bengali" character set? Does it have a Unicode
> mapping table like for example this one:
>
> ftp://ftp.unicode.org/Public/MAPPINGS/ISO8859/8859-1.TXT
>
> Please also send me some li
1 - 100 of 188 matches
Mail list logo
