You are viewing a plain text version of this content. The canonical link for it is here.
Posted to slide-dev@jakarta.apache.org by Michele Costabile <mi...@gmail.com> on 2004/08/12 14:33:21 UTC
Collation conflict with slide 2.1 and MySql 4.1.3
I was able to start and run Slide 2.1 with MySql 4.1.3b yesterday, but
today I hav this problem. This is repeatable: I can install and run
slide once, but if I restart I have the problem.
In other words it works fine when there are no tables in the database.
The problem is a conflict from the collation specified in database
creation and the server default.
How can I solve this problem? (changing database maybe?)
org.apache.slide.store.impl.rdbms.JDBCStore@180cf2a access error :
General error, message from server: "Illegal mix of collations
(utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for
operation 'substr_index'"
at org.apache.slide.store.impl.rdbms.MySqlRDBMSAdapter.createException(MySqlRDBMSAdapter.java:66)
at org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.retrieveRevisionDescriptors(StandardRDBMSAdapter.java:942)
at org.apache.slide.store.impl.rdbms.AbstractRDBMSStore.retrieveRevisionDescriptors(AbstractRDBMSStore.java:654)
I have opted for swedish absolutely nowhere so, I guess it is a
default. There asre my MySql variables
character_set_client | latin1
character_set_connection | latin1
character_set_database | latin1
character_set_results | latin1
character_set_server | latin1
character_set_system | utf8
character_sets_dir | C:\mysql\share\charsets/
collation_connection | latin1_swedish_ci
collation_database | latin1_swedish_ci
collation_server | latin1_swedish_ci
--
Michele Costabile
http://proxybar.net
---------------------------------------------------------------------
To unsubscribe, e-mail: slide-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-dev-help@jakarta.apache.org
Re: Collation conflict with slide 2.1 and MySql 4.1.3
Posted by Jacob Lund <jl...@qualiware.net>.
Do you use useUnicode and characterEncoding in your connection url? If not,
then that might be a place to start.
I am just guessing here.
/jacob
----- Original Message -----
From: "Michele Costabile" <mi...@gmail.com>
To: "Slide Developers Mailing List" <sl...@jakarta.apache.org>
Sent: Thursday, August 12, 2004 2:33 PM
Subject: Collation conflict with slide 2.1 and MySql 4.1.3
>I was able to start and run Slide 2.1 with MySql 4.1.3b yesterday, but
> today I hav this problem. This is repeatable: I can install and run
> slide once, but if I restart I have the problem.
> In other words it works fine when there are no tables in the database.
> The problem is a conflict from the collation specified in database
> creation and the server default.
> How can I solve this problem? (changing database maybe?)
>
> org.apache.slide.store.impl.rdbms.JDBCStore@180cf2a access error :
> General error, message from server: "Illegal mix of collations
> (utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for
> operation 'substr_index'"
> at
> org.apache.slide.store.impl.rdbms.MySqlRDBMSAdapter.createException(MySqlRDBMSAdapter.java:66)
> at
> org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.retrieveRevisionDescriptors(StandardRDBMSAdapter.java:942)
> at
> org.apache.slide.store.impl.rdbms.AbstractRDBMSStore.retrieveRevisionDescriptors(AbstractRDBMSStore.java:654)
> I have opted for swedish absolutely nowhere so, I guess it is a
> default. There asre my MySql variables
>
> character_set_client | latin1
> character_set_connection | latin1
> character_set_database | latin1
> character_set_results | latin1
> character_set_server | latin1
> character_set_system | utf8
> character_sets_dir | C:\mysql\share\charsets/
> collation_connection | latin1_swedish_ci
> collation_database | latin1_swedish_ci
> collation_server | latin1_swedish_ci
> --
> Michele Costabile
> http://proxybar.net
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: slide-dev-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: slide-dev-help@jakarta.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: slide-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-dev-help@jakarta.apache.org
Re: Collation conflict with slide 2.1 and MySql 4.1.3
Posted by Michele Costabile <mi...@gmail.com>.
I noticed that I am not using MySql41RDBMSAdapter., but my Domain.xml
reads like this:
<store name="mysqlstore">
<nodestore classname="org.apache.slide.store.impl.rdbms.JDBCStore">
<parameter
name="adapter">org.apache.slide.store.impl.rdbms.MySql41RDBMSAdapter</parameter>
<parameter name="driver">com.mysql.jdbc.Driver</parameter>
<parameter name="url">jdbc:mysql://localhost/slide</parameter>
<!--
<parameter name="driver">sun.jdbc.odbc.JdbcOdbcDriver</parameter>
<parameter name="url">jdbc:odbc:slide</parameter>
-->
<parameter name="user">root</parameter>
<parameter name="dbcpPooling">true</parameter>
<parameter name="maxPooledConnections">10</parameter>
<parameter name="isolation">SERIALIZABLE</parameter>
<parameter name="compress">false</parameter>
</nodestore>
I bypassed the problem with collations modifying the schema creation script.
I modified MySql-4.1-Schema substituting utf8 with latin1 and
utf8_general_ci with the dreaded swedish collation.
It works cleanly and can be rebooted with no problems.
I will deal with ut8 later, I would like to get the right adapter to work first.
On Thu, 12 Aug 2004 15:07:23 +0200, Unico Hommes <un...@hippo.nl> wrote:
> I have no idea about why this happens or how to solve this. I can only
> suggest to search the MySql documentation and user lists to find out
> more about this. A very wild guess would be to try both Slide sql
> schema's for MySql to see if that makes a difference (I doubt it). By
> the way, I see you still use MySqlRDBMSAdapter instead of
> MySql41RDBMSAdapter?
>
> --
> Unico
>
>
>
> Michele Costabile wrote:
>
> >I was able to start and run Slide 2.1 with MySql 4.1.3b yesterday, but
> >today I hav this problem. This is repeatable: I can install and run
> >slide once, but if I restart I have the problem.
> >In other words it works fine when there are no tables in the database.
> >The problem is a conflict from the collation specified in database
> >creation and the server default.
> >How can I solve this problem? (changing database maybe?)
> >
> >org.apache.slide.store.impl.rdbms.JDBCStore@180cf2a access error :
> >General error, message from server: "Illegal mix of collations
> >(utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for
> >operation 'substr_index'"
> > at org.apache.slide.store.impl.rdbms.MySqlRDBMSAdapter.createException(MySqlRDBMSAdapter.java:66)
> > at org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.retrieveRevisionDescriptors(StandardRDBMSAdapter.java:942)
> > at org.apache.slide.store.impl.rdbms.AbstractRDBMSStore.retrieveRevisionDescriptors(AbstractRDBMSStore.java:654)
> >I have opted for swedish absolutely nowhere so, I guess it is a
> >default. There asre my MySql variables
> >
> >character_set_client | latin1
> >character_set_connection | latin1
> >character_set_database | latin1
> >character_set_results | latin1
> >character_set_server | latin1
> >character_set_system | utf8
> >character_sets_dir | C:\mysql\share\charsets/
> >collation_connection | latin1_swedish_ci
> >collation_database | latin1_swedish_ci
> >collation_server | latin1_swedish_ci
> >
> >
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: slide-dev-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: slide-dev-help@jakarta.apache.org
>
>
--
Michele Costabile
http://proxybar.net
---------------------------------------------------------------------
To unsubscribe, e-mail: slide-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-dev-help@jakarta.apache.org
Re: Collation conflict with slide 2.1 and MySql 4.1.3
Posted by Unico Hommes <un...@hippo.nl>.
I have no idea about why this happens or how to solve this. I can only
suggest to search the MySql documentation and user lists to find out
more about this. A very wild guess would be to try both Slide sql
schema's for MySql to see if that makes a difference (I doubt it). By
the way, I see you still use MySqlRDBMSAdapter instead of
MySql41RDBMSAdapter?
--
Unico
Michele Costabile wrote:
>I was able to start and run Slide 2.1 with MySql 4.1.3b yesterday, but
>today I hav this problem. This is repeatable: I can install and run
>slide once, but if I restart I have the problem.
>In other words it works fine when there are no tables in the database.
>The problem is a conflict from the collation specified in database
>creation and the server default.
>How can I solve this problem? (changing database maybe?)
>
>org.apache.slide.store.impl.rdbms.JDBCStore@180cf2a access error :
>General error, message from server: "Illegal mix of collations
>(utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for
>operation 'substr_index'"
> at org.apache.slide.store.impl.rdbms.MySqlRDBMSAdapter.createException(MySqlRDBMSAdapter.java:66)
> at org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.retrieveRevisionDescriptors(StandardRDBMSAdapter.java:942)
> at org.apache.slide.store.impl.rdbms.AbstractRDBMSStore.retrieveRevisionDescriptors(AbstractRDBMSStore.java:654)
>I have opted for swedish absolutely nowhere so, I guess it is a
>default. There asre my MySql variables
>
>character_set_client | latin1
>character_set_connection | latin1
>character_set_database | latin1
>character_set_results | latin1
>character_set_server | latin1
>character_set_system | utf8
>character_sets_dir | C:\mysql\share\charsets/
>collation_connection | latin1_swedish_ci
>collation_database | latin1_swedish_ci
>collation_server | latin1_swedish_ci
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: slide-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-dev-help@jakarta.apache.org