Brown, Brooks wrote:
I ran mysqld with arguments --default-character-set=utf8 and --default-collation=utf8_unicode_ci, and created a table with no collation specification. I didn't test specifically with ç, but e and e-acute were equivalent. For me this is was problem, but it sounds like for you
e
desired behavior.
-Original Message-
From: Andrew Nagy [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 01, 2004 11:03 AM
To: Brown, Brooks
Cc: [EMAIL PROTECTED]
Subject: Re: Utf8 collations
Brooks, this isn't an answer to your question, but a question to you
regarding what yo
Brooks, this isn't an answer to your question, but a question to you
regarding what you have done.
I would like to do a query such as:
SELECT title FROM books WHERE title LIKE '%Francais%';
And in return get:
+--+
| title|
+--+
| Français |
+--+
Does the "CHARACTER SET
Hi.
See:
http://dev.mysql.com/doc/mysql/en/Charset-config-file.html
"Brown, Brooks" <[EMAIL PROTECTED]> wrote:
> All of the unicode collations listed in the reference manual except the =
> binary collations are not sensitive to diacritical marks. That is, if I =
> do the following:
>
All of the unicode collations listed in the reference manual except the binary
collations are not sensitive to diacritical marks. That is, if I do the following:
create table t ( filename varchar(260) ) type=InnoDB CHARACTER SET utf8 collate
utf8_unicode_ci;
-- insert an e-acute
insert into t
> Entering it in hex works for me too. So the problem _was_ actually with
> the values I inserted into the database.
>
> What's the best way to actually see what is stored in the database,
> preferably as hex or something else that a terminal is guaranteed to
> display correctly? Clearly, what
On Tue, Aug 03, 2004 at 01:11:44PM -0400, Jeremy March wrote:
> Is this for Swedish language data? I don't know Swedish so I don't
> actually know where u-diaeresis is sorted in Swedish myself, but
> according to the source code (in the file: strings/ctype-uca.c) the
> u-diaeresis is sorted as an
sort after MX Systems in the following:
> ...
> I have tried various UTF8 collations and, apart from utf8_bin, they all
> place M(u-diaresis)ller at the start.
> ...
Is this for Swedish language data? I don't know Swedish so I don't
actually know where u-diaeresis is sorte
I am attempting to use the new UTF8 collations in MySQL 4.1.3 to perform
case-insensitive, accent-insensitive sorting. Based on the example in
section 11.3.13 of the manual
(http://dev.mysql.com/doc/mysql/en/Charset-collation-effect.html )
I expect M(u-diaeresis)ller to sort after MX Systems in
Sorry :)
i see that simbols i've written was converted into ASCII symbols. That is
what i need, but in MySQL :). So is there any collation where: a = a-umlaut
= a-with-any-other-"fix" ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://list
Hallo,
Is there any UTF8 collation which groups national simbols by it's base
symbol.. For example:
if in case-insensitive a = A, is there any solution for A = A (a-umlaut) or
A ??
it would have sense in search'ing national text's, for example selecting all
people in phone book which first surnam
11 matches
Mail list logo
