- Original Message -
From: Rick James rja...@yahoo-inc.com
A warning about β -- There was a change in the collation at 5.1.24.
Search http://mysql.rjweb.org/doc.php/charcoll for 'German'; there is
a brief discussion near the end.
Aha, also a very good bit of information, thank you
http://bugs.mysql.com/bug.php?id=27877
W.T.
- Original Message -
From: Rick James rja...@yahoo-inc.com
A warning about β -- There was a change in the collation at 5.1.24.
Search http://mysql.rjweb.org/doc.php/charcoll for 'German'; there is
a brief discussion near the end.
Aha
- Original Message -
From: Shawn Green shawn.l.gr...@oracle.com
The other tactical move has been to jump 5.1 and upgrade directly
from 5.0 to 5.5 where that problem is resolved. Sure, it's a bit more
work (full dump/restore is highly recommended) but it avoids the collation
bug
A warning about β -- There was a change in the collation at 5.1.24.
Search http://mysql.rjweb.org/doc.php/charcoll for 'German'; there is a brief
discussion near the end.
-Original Message-
From: Johan De Meersman [mailto:vegiv...@tuxera.be]
Sent: Wednesday, June 13, 2012 2:26 AM
... but too lazy to look for it myself right now :-p
I'm going to be running into (woot, scheduled problems :-p ) the 5.0 to 5.1
upgrade collation issue where German β is now collated as 's' instead of as
'ss', causing duplicate key errors.
The basic solution is to set the collation
On 6/12/2012 9:37 AM, Johan De Meersman wrote:
... but too lazy to look for it myself right now :-p
I'm going to be running into (woot, scheduled problems :-p ) the 5.0 to 5.1
upgrade collation issue where German β is now collated as 's' instead of as
'ss', causing duplicate key errors
, however, got
ERROR 1271 (HY000): Illegal mix of collations for operation 'concat'
when i sent the message.
without the chinese literal, the message was stored in the mysql db
correctly.
i, then, changed the connection names to utf8 and collation to utf8_bin
and then the session parameters
can u please list out the table structure...as collation can also be set at
column level
regards
anandkl
On Tue, Aug 31, 2010 at 6:00 PM, mysql my...@ayni.com wrote:
Hi listers
mysql server here is
mysql-server-5.1.48-2.fc13.x86_64
this morning i created a message with a literal string
Hi Ananda
table structure is:
mysql show full columns from suomi_contacts2;
+--+--+---+--+-+---+-+-+-+
| Field| Type | Collation
;
+--+--+---+--+-+---+-+-+-+
| Field| Type | Collation | Null | Key |
Default | Extra | Privileges
| Comment
On 2010-08-31 15:17, Ananda Kumar wrote:
desc suomi_contacts2;
mysql desc suomi_contacts2;
+--+--+--+-+---+-+
| Field| Type | Null | Key | Default |
Extra |
did u try changing the collation for history column to UTF8
and try the update.
2010/8/31 mysql my...@ayni.com
On 2010-08-31 15:17, Ananda Kumar wrote:
desc suomi_contacts2;
mysql desc suomi_contacts2
Hi Ananda
not sofar. But if you recommend it, i will give it a try.
thanks so much.
suomi
On 2010-08-31 15:41, Ananda Kumar wrote:
did u try changing the collation for history column to UTF8
and try the update.
2010/8/31 mysql my...@ayni.com mailto:my...@ayni.com
On 2010-08-31 15:17
-8-bin collation for chinese charset',' ', 'Hoi
Suomixer,\r\n\r\nIf you\'re careful enough, nothing bad or good will
ever happen to you.\r\n 葛斯克 愛德華 / 台北市八德路四段\r\n\r\n\r\n\r
\nsuomi\r\n044 280 22 44\r\n079 239 29 01\r\n', ' ',
'--- ', history) where counter = 1127;
Query OK
noticed that 90% of the changes are simply to align the collation
of fields and default collations for tables. Usually it's bouncing
between utf8_general_ci and latin1_swedish_ci.
99.99% of the records in our various customers databases will be
normal U.S. names and addresses but I know of a few
...@neimeyer.org]
Sent: Friday, August 14, 2009 9:52 AM
To: mysql@lists.mysql.com
Subject: Picking Collation Confusion
First off... I've read chapter 9.1.3 on character sets and collations
and I'm still confused... :) (that could just be because today is
Friday)
Our application is installed
Hi!
I just upgraded from 4.0.26 to 4.1.22.
On phpMyAdmin with the older (4.0.26) was only one field for Language
and it was set to Hebrew (he-iso-8859-i).
Now, upgrading (4.1.22) in the Language field appears Hebrew
(he-utf-8) and a new field MySQL connection collation: offer 2
possibilities
mysql to unicode character, so that i can get my
dictionary application to look at words in Nepali.
here is my setting:
mysql charset: utf-8 unicode
when i make a new database:
mysql connection collation is utf8-general-ci
and my new database collation is also utf-general-ci
i import tables
To: mysql@lists.mysql.com
Subject: Problem with character set and connection collation
Hello all,
here is my problem:
I am trying to set mysql to unicode character, so that i can get my
dictionary application to look at words in Nepali.
here is my setting:
mysql charset: utf-8 unicode
when i make
On Mon, 28 Apr 2008, Jerry Schwartz [EMAIL PROTECTED] wrote:
A week or so ago I explored this in depth because I was having the
same problems. (It was affecting an English file that had some
Windows (CP-1252) characters that didn't directly map to UTF-8. That
message is at
Well, if latin1 is not CP-1252, then that explains why it didn't fix my
problem; but here's what 5.0.45-community-nt says:
mysql show character set;
+--+-+-++
| Charset | Description | Default collation | Maxlen
Hello all,
here is my problem:
I am trying to set mysql to unicode character, so that i can get my
dictionary application to look at words in Nepali.
here is my setting:
mysql charset: utf-8 unicode
when i make a new database:
mysql connection collation is utf8-general-ci
and my new database
I have a column in a table that was turned into an cp1251_general_ci
for a type of encryption. Question is, how do I unencrypt it?
Thanks
Steve
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On 21.11.2007 15:18 CE(S)T, Marten Lehmann wrote:
If I recall that correctly, utf8_swedish_ci is the collation to use for
european/western european languages. Those Swedish people think they can
stand for whole Europe... ;)
Not tested my reply, though.
and doesn't work either.
Okay
Hello,
default-character-set=latin1_d e
that's not UTF8.
Regards
Marten
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello,
If I recall that correctly, utf8_swedish_ci is the collation to use for
european/western european languages. Those Swedish people think they can
stand for whole Europe... ;)
Not tested my reply, though.
and doesn't work either.
This is the sorting result with utf8_swedish_ci
Hi Friend,
Try this:
CHARACTER SET: latin1
COLLATION: latin1_german2_ci
Cya!
Wagner Bianchi
Diretor de Tecnologia - INFODBA Technologies Consulting
[EMAIL PROTECTED] - (31) 3272 - 0226 / 8427 - 8803
- Mensagem original
De: Yves Goergen [EMAIL PROTECTED]
Para: Marten Lehmann
Hello,
I want to store my data with UTF8, thus I'm using the utf8 charset for
my tables. But which collcation shall I use? I cannot find anything
appropriate.
I cannot use utf8_unicode_ci or utf8_general_ci, because this seems to
treat Ä and A equally. So I couldn't store the words ÄBC and
On 14.11.2007 21:43 CE(S)T, Marten Lehmann wrote:
I want to store my data with UTF8, thus I'm using the utf8 charset for
my tables. But which collcation shall I use? I cannot find anything
appropriate.
If I recall that correctly, utf8_swedish_ci is the collation to use for
european/western
How do I change:
| collation_connection| latin1_swedish_ci
|
| collation_database | latin1_swedish_ci
|
| collation_server| latin1_swedish_ci
to latin1_bin?
Is this in my.cnf? or is this another way to do this?
--
Albert E. Whale, CHS CISA CISSP
Hello people.I would like to ask the following.Using greek character set and
collation i perform a
select-order by.But i get first the latin characters and then the greek
ones.Can i show first the
greek ones and then the latin?
Thank you in advance!
ps:moreover i would like to sort them
message without making a copy. Thank you.
- Original Message -
From: tasos [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Wednesday, June 27, 2007 1:16 PM
Subject: greek collation sorting
Hello people.I would like to ask the following.Using greek character set
and collation i perform
Message - From: tasos [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent:
Wednesday, June 27, 2007 1:16 PM Subject: greek collation sorting
Hello people.I would like to ask the following.Using greek character set and collation i
perform a select-order by.But i get first the latin characters
Hello,
I've got a table that originally was using UTF8 charset and collation.
However, I upgraded one of my applications which is hardcoded to
Latin1_General_CI collation in its queries. As a result, I altered the
table and any specifically set columns to use Latin1 as the charset
, is it
always safe to assume that:
a)Digits come before letters?
b)Letters are in ascending order, i.e. A before B, B before C, etc.?
To be conservative, should I set collation order?
Thanks.
and get back result sets sorted on this text string, is it
always safe to assume that:
a)Digits come before letters?
b)Letters are in ascending order, i.e. A before B, B before C, etc.?
Character orderings are entirely determined by the collation that you
choose. So you should choose a collation
MySQL Users,
I know from the manual that I can change the collation set of a table
with the following command:
ALTER TABLE `mytable` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci
And that I can do this to alter a column of a table to change its collation:
ALTER TABLE `mytable` CHANGE
ypogegrammenti
These characters are stored/retrieved correctly. But they are wrongly
regarded the same character by statements like SELECT * FROM
tablename WHERE fieldname LIKE '[greek small eta]'
The database's character-set is set to UTF-8 Unicode (utf8) and the
table's and varchar field's collation
field's collation is set utf8_unicode_ci.
Is there anything I can do to have MySQL distinguish these characters?
DISCLAIMER: not tested
try something like:
SELECT * FROM tablename WHERE fieldname LIKE BINARY '[greek small eta]'
that *should* ( see disclaimer ;) ) give you what you need
--
MySQL
Am 05.02.2007 um 18:11 schrieb Chris White:
SELECT * FROM tablename WHERE fieldname LIKE BINARY '[greek small
eta]'
that *should* ( see disclaimer ;) ) give you what you need
Yes, it does.
I should have also asked for SELECT DISTINCT fieldname ... in the
first place, but looking at your
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 charset(concat(tt
Thanks,
Dusan
ViSolve DB Team napsal(a):
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
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 not an expr.
I
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 column whenever I have
On Tue, 2006-10-17 at 10:15 -0600, Peter Gulutzan wrote:
Hi,
MySQL is looking for an authoritative, official statement
which states all the current Hungarian collation rules.
Please let other MySQL-using Hungarians (especially if you
know a user group in Hungary) know about these
questions
Hi,
On Thu, 2006-10-19 at 18:02 +0300, [EMAIL PROTECTED] wrote:
From: Peter Gulutzan [EMAIL PROTECTED]
MySQL is looking for an authoritative, official statement which states
all the current Hungarian collation rules.
According to the Reference Level Description of the hungarian
Hi,
From: Peter Gulutzan [mailto:[EMAIL PROTECTED]
MySQL is looking for an authoritative, official statement which
states all the current Hungarian collation rules.
According to the Reference Level Description of the
hungarian language
(ISBN
9634206441 or the hungarian
From: Peter Gulutzan [EMAIL PROTECTED]
MySQL is looking for an authoritative, official statement which states
all the current Hungarian collation rules.
According to the Reference Level Description of the hungarian language (ISBN
9634206441 or the hungarian version on line:
http://bme
Hi,
MySQL is looking for an authoritative, official statement
which states all the current Hungarian collation rules.
Please let other MySQL-using Hungarians (especially if you
know a user group in Hungary) know about these
questions. Best of all would be a translation of the
Hungarian government
Is there a collation where 'œ' = 'oe' so that cœur is sorted between
codirection and coffre? I am currently using latin1_swedish_ci and
the 'œ' gets sorted to the end (cœur appears after czar).
I am using MySQL 5.0.22-Debian_0ubuntu6.06.2.
Thanks.
--
Brian P. Giroux
--
MySQL General Mailing
Thanks for the info. I checked the links you suggested, but it doesn't
look like they address my problem. All the discussion write about
croatian colaltion in latin2, but I'm interested in utf-8 charset. For
utf-8 there's no croatian collation. There is one in slovenian
(utf8_slovenian_ci
if this is not the apropriate list, but I couldn't fined any
other list where this question would fit in. If someone know where to
post it, please suggest.
I have a question about collation and utf in mysql.
I'm using mysql on several of my websites, but the mysql database
doesn't have croatian collation for utf. And most
I'm sorry if this is not the apropriate list, but I couldn't fined any
other list where this question would fit in. If someone know where to
post it, please suggest.
I have a question about collation and utf in mysql.
I'm using mysql on several of my websites, but the mysql database
doesn't
.
I had a similar problem a few months back, and at the time, it was
advised that I add the following lines to /etc/mysql/my.cnf:
init-connect='SET NAMES utf8'
character-set-server=utf8
collation-server=utf8_general_ci
I've done this, and so these are my collation variables:
Variable Session
Is there any way to turn off collation in mysql 4.1? PHPadmin is showing a
new colation dropdown menu which I need to get rid of.
Thanks,
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello.
Chris, the collation is subordinated to the character set. You should
work with the character sets, and only after with collations. The data
which you store in your table is silently converted to ascii character
set. Are you sure that the characters which you want to store are
present
Hi Gleb,
i finally found out a method to be entirely independent from any
character-set as well as collation-sequence problem, when forming a
UNION, where you occasionnally have to insert place-holders in one of
the SELECT statements:
as (text, varchar, char) placeholders use NULL instead
I correct to assume changes to character sets must be done via command
line?
cw
Gleb Paharenko [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hello.
Chris, the collation is subordinated to the character set. You should
work with the character sets, and only after with collations
as $key=$value) echo
$key=$valueBR;
echo BR;
$sql = show variables like '%collation%';
$result = mysql_query($sql) or die(Couldn't Select .mysql_error());
while ($row = mysql_fetch_row($result)) foreach($row as $key=$value) echo
$key=$valueBR;
hope this provides the appropriate info
I'm sorry but I do not know what you mean by NO_TABLE_OPTIONS in
@@sql_mode).
The database has a Collation = ascii_general_ci. The only other option is
ascii_bin.
With respect to the table, it also has Collation of the same,
ascii_general_ci. There are many Collation types which the table may
Hello.
Please, execute the following statements in mysql command line and php,
and provide its output to the list:
show variables like '%char%';
show variables like '%collation%';
Include the CREATE statement for your table as well.
Chris wrote:
I think I have a problem with mysql
=$value) echo
$key=$valueBR;
echo BR;
$sql = show variables like '%collation%';
$result = mysql_query($sql) or die(Couldn't Select .mysql_error());
while ($row = mysql_fetch_row($result)) foreach($row as $key=$value) echo
$key=$valueBR;
hope this provides the appropriate info.
Thanks
Gleb
I think I have a problem with mysql related character sets and collation.
With language English (en-utf-8), MySQL charset UTF-8 Unicode and a MySQL
connection collation: ascii_general_ci. I can execute a sql statement in
phpmyadmin, like INSERT INTO mytable (id, name) VALUES ('5','Unterwinkel
Hi Gleb,
localhost.(none) show session variables like %version%;
+-+--+
| Variable_name | Value|
+-+--+
|
). See:
http://dev.mysql.com/doc/refman/4.1/en/charset-collation-charset.html
schlubediwup wrote:
Hi mysqllers,
1. following installation
localhost.addresses2 show global variables like version%;
+-+--+
| Variable_name
Hi mysqllers,
1. following installation
localhost.addresses2 show global variables like version%;
+-+--+
| Variable_name | Value|
Hi guys:
I know this question have been asked many times but I still get no solution.
I have a database with thousands of rows which by mistake was imported in the
wrong way and all the spanish characters went wrong. For example the letter 'á'
appears like 'Ãf¡'. The problem is that I am
Alvaro Cobo:
I have a database with thousands of rows which by mistake was imported in
the wrong way and all the spanish characters went wrong. For example the
letter 'á' appears like 'Ãf¡'.
That looks like text that was in the UTF-8 encoding has been mistaken for an
eight-bit encoding,
binary?
Anyone have experience with utf8 binary collation?
-Eric
===
===
CREATE TABLE `test` (
`id` int(10) unsigned NOT NULL auto_increment,
`utf8_data` text character set
that this is not ordering according to
utf8 binary?
Anyone have experience with utf8 binary collation?
-Eric
===
===
CREATE TABLE `test` (
`id` int(10) unsigned NOT NULL auto_increment,
`utf8_data
see any difference between the two sections.
Am I correct in my assumption that this is not ordering according to
utf8 binary?
Anyone have experience with utf8 binary collation?
-Eric
test order by utf8_data collate utf8_bin
to generate the EXPECTED ORDER data section below. However, TEST
ORDER is what gets generated.
Am I correct in my assumption that this is not ordering according to
utf8 binary?
Anyone have experience with utf8 binary collation?
-Eric
Danish symbols. If you have a look at section latin1_danish_ci in:
/usr/share/mysql/characters/latin1.xml
you will see the same numbers in different places - that means that
different symbols are equal in this collation. If you want to properly
handle extended set of characters use
:[EMAIL PROTECTED]
Organization:
MySQL support: none
Synopsis: Incorrect latin1_danish_ci collation
Severity: serious
Priority: medium
Category: mysql
Class: sw-bug
Release: mysql-4.1.14-standard (MySQL Community Edition - Standard (GPL))
Server: /usr/local/mysql/bin
which is able to change the collation
and character set information in all tables at once. For single
table use an ALTER TABLE statement. See:
http://dev.mysql.com/doc/mysql/en/alter-table.html
Hello.
There is no statement which is able to change the collation
and character set information in all tables at once. For single
table use an ALTER TABLE statement. See:
http://dev.mysql.com/doc/mysql/en/alter-table.html
Dave [EMAIL PROTECTED] wrote:
MySQL General List
myself, and I
was sure to specify that for each, the Collation was in utf_general_ci.
Recently, I decided to add a forum for my users, using the PHP based
Simple Machines Forum available here:
http://www.simplemachines.org/
This added a bunch of new tables, in which the Collation
Hi,
Ive noticed that my ALL my databases and tables have
latin1_swedish_ci as the collation...h that wouldn't be so bad
except that I didn't set it that way by default, and I don't speak
swedish. Not that swedish isn't a fine language, or sweden isn't a
fine country (although Ive
m i l e s [EMAIL PROTECTED] wrote on 30/08/2005 15:28:31:
Hi,
Ive noticed that my ALL my databases and tables have
latin1_swedish_ci as the collation...h that wouldn't be so bad
except that I didn't set it that way by default, and I don't speak
swedish. Not that swedish isn't
Enrique Sanchez Vela wrote:
Hello Folks,
I would like to have MySQL differentiate between 'abc'
and 'ABC' both the server and clients. so far anything
I've done has not worked.
Is altering the column type an option ? If yes, you would change any
'text' for 'blob' and any 'varchar' for
Philippe Poelvoorde wrote:
Enrique Sanchez Vela wrote:
I would like to have MySQL differentiate between 'abc'
and 'ABC' both the server and clients. so far anything
I've done has not worked.
Is altering the column type an option ? If yes, you would change any
'text' for 'blob' and any
Hello Folks,
I would like to have MySQL differentiate between 'abc'
and 'ABC' both the server and clients. so far anything
I've done has not worked.
when I defined the database it was using the
latin1_swedish_ci Collation, now I have issued the
alter database COLLATE to use latin1_bin one
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]
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 technical
Hello there,
I run MySQL 4.1.12 and have some databases with the default collation of
latin1_swedish_ci. I have edited the my.cnf file to read
default-collation = latin1_german1_ci
Now I would like to change the collation on all existing databases,
tables and columns to have
information about collation. Then just import the dump and all
tables will have the same collation. However, you can loose some
important table properties.
Florian Effenberger [EMAIL PROTECTED] wrote:
Hello there,
I run MySQL 4.1.12 and have some databases with the default collation
Hi,
I don't understand very well, what should I do...
Does anyone has a step-by-step instructions on how to import a ver. 4.0 DB dump
into a 4.1 version ?
Thanks for any help
Roberto Jobet
look at automatic character set conversion
http://dev.mysql.com/doc/mysql/en/charset-collation
Hi,
I recently upgraded from 4.0 to 4.1 because of the multilingual support.
But importing the DB dump into the new 4.1 version all foreign characters
(french, spanish, portoguese) have been replaced by ? character...
I've been trying to understand the new collation feature but i seems quite
by ? character...
I've been trying to understand the new collation feature but i seems quite
difficult to setup.
Anybody has already faced this problem ?
Here's my current configuration:
1) my.cnf (only the mysqld section)
[mysqld]
user= mysql
pid-file= /var/run/mysqld
recently upgraded from 4.0 to 4.1 because of the multilingual support.
But importing the DB dump into the new 4.1 version all foreign characters
(french, spanish, portoguese) have been replaced by ? character...
I've been trying to understand the new collation feature but i seems quite
]:
Hi,
I recently upgraded from 4.0 to 4.1 because of the multilingual support.
But importing the DB dump into the new 4.1 version all foreign characters
(french, spanish, portoguese) have been replaced by ? character...
I've been trying to understand the new collation feature
,
I recently upgraded from 4.0 to 4.1 because of the multilingual support.
But importing the DB dump into the new 4.1 version all foreign
characters
(french, spanish, portoguese) have been replaced by ? character...
I've been trying to understand the new collation feature
...
I've been trying to understand the new collation feature but i
seems
quite
difficult to setup.
Anybody has already faced this problem ?
Here's my current configuration:
1) my.cnf (only the mysqld section)
[mysqld]
user= mysql
pid
look at automatic character set conversion
http://dev.mysql.com/doc/mysql/en/charset-collation-charset.html
mathias
Selon [EMAIL PROTECTED]:
Salut,
i don't see what doesn't work ! Where characters are replaced by ?, since you
say that insert,select and import work fine ? is it in the export
, if anyone wants a script to recreate the tables with some data, I
can send it to you instantly.
Thanks
Andr$s Villanueva
Kevin Cowley wrote:
Have you check that the collation for the text
.
Thanks
Andr$s Villanueva
Kevin Cowley wrote:
Have you check that the collation for the text columns
.
Thanks
Andr$s Villanueva
Kevin Cowley wrote:
Have you check that the collation for the text columns match the
collation for the table and that you've set UTF8 for the query (set
char set utf8).
Kevin Cowley
Product Development
Alchemetrics Ltd
SMARTER DATA , FASTER
Tel
wants a script to recreate the tables with some data, I
can send it to you instantly.
Thanks
Andr$s Villanueva
Kevin Cowley wrote:
Have you check that the collation for the text columns match the
collation for the table and that you've set
Hello.
| latin1_general_cs | latin1 | 49 | | | 0 |
You have this collation installed. The output from SHOW COLLATION includes all
available character sets.
Andre Matos [EMAIL PROTECTED] wrote:
Hi List,
I was checking the list of collations
, this (the query is at the end of the
email) didn't work anymore, apparently because of a collation problem
with the literals. After doing some research i found that this wasn't a
problem anymore in 4.1.11, so i decided to upgrade...
After upgrading the query doesn't throw an error, but it doesn't
1 - 100 of 147 matches
Mail list logo