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:
>
> 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
>...
> mysql> SELECT col2 FROM test ORDER BY col2 COLLATE utf8_swedish_ci;
> ++
> | col2 |
> ++
> | M(u-diaresis)ller |
> | Muffler|
> | MX Systems |
> | MySQL |
> ++
> ...
> I expect M(u-diaeresis)ller to sort after MX Systems in the following:
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