Comments (17)
Maybe it has something to do with:
MariaDB [(none)]>show variables like 'collation_%';
+----------------------+-----------------+
| Variable_name | Value |
+----------------------+-----------------+
| collation_connection | utf8_general_ci |
| collation_database | utf8_unicode_ci |
| collation_server | utf8_unicode_ci |
+----------------------+-----------------+
3 rows in set (0.00 sec)
But even if I do
>set @@collation_connection ='utf8_unicode_ci';
And then reissue common_schema import... same thing happens.
Original comment by [email protected]
on 24 Sep 2012 at 8:44
from common-schema.
Can you please attach your my.cnf file? In particular character-set and
collation settings.
Do you have an init-connect setting?
Original comment by [email protected]
on 25 Sep 2012 at 4:42
from common-schema.
Have just tried to repeat with 5.5.27-MariaDB, encountered no problem. Will
need your config.
Original comment by [email protected]
on 25 Sep 2012 at 5:47
from common-schema.
[client]
default-character-set = utf8
[mysqld]
character-set-server = utf8
collation-server = utf8_unicode_ci
lower-case-table-names = 1
event-scheduler = ON
[mysqld-5.5]
[mariadb]
[mariadb-5.5]
performance_schema
userstat
enable-feedback
Original comment by [email protected]
on 25 Sep 2012 at 11:08
from common-schema.
Most probably the line "collation-server = utf8_unicode_ci" is the cause.
Original comment by [email protected]
on 25 Sep 2012 at 11:09
from common-schema.
Most probably -- but I still can't repeat. Using same config as yours, both for
[mysqld] and for [client] (was suspecting mismatch between client & server),
and 5.5.27-MariaDB (64bit) on Ubuntu Linux.
What is the command you use to import common_schema?
Via connector? GUI editor? command line? SOURCE?
I am guessing there will be no problem using SOURCE. Can you verify?
Original comment by [email protected]
on 25 Sep 2012 at 2:17
from common-schema.
My scenario:
[root@process ~]# cat .bashrc | grep mariadb
alias mariadb='/data/mariadb/bin/mysql --socket=/data/mariadb-data/mariadb.sock
--prompt="MariaDB-Collector [\d]>"'
Original comment by [email protected]
on 27 Sep 2012 at 7:57
from common-schema.
[deleted comment]
from common-schema.
Original comment by [email protected]
on 27 Sep 2012 at 8:01
Attachments:
from common-schema.
[Sorry about mixing email addresses but it seems at home the wrong GA domain is
the default domain... I'm the same Gabriel but posting from two addresses]
What else would you need?
Original comment by [email protected]
on 27 Sep 2012 at 8:02
from common-schema.
Thanks! I think you gave me all the info I may need. I will try again to
reproduce on my machine, though so far unlucky.
I have a good guess as for where the bug originates, but would like to actually
SEE it...
Original comment by [email protected]
on 28 Sep 2012 at 4:00
from common-schema.
You might want to try adding in my.cnf that is read by the client the following:
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
Original comment by [email protected]
on 28 Sep 2012 at 9:52
from common-schema.
haha! At last I am able to reproduce. Problem lies within the CREATE DATABASE
statement and the collation_database variable. Will fix.
Original comment by [email protected]
on 29 Sep 2012 at 1:19
- Changed state: Accepted
from common-schema.
As a quick fix for you, please add the following line:
ALTER DATABASE common_schema DEFAULT CHARACTER SET 'utf8' DEFAULT COLLATE
'utf8_general_ci';
Right after the line:
CREATE DATABASE IF NOT EXISTS common_schema;
(line 50 in common_schema-1.1.sql)
Let me know if this solves your immediate error.
Will have this in next release, scheduled soon.
Original comment by [email protected]
on 29 Sep 2012 at 1:23
- Changed state: Started
from common-schema.
[deleted comment]
from common-schema.
Great.
I confirm that after adding ALTER DATABASE... all works fine.
Same goes for TokuDB for MariaDB.
Original comment by [email protected]
on 1 Oct 2012 at 7:01
from common-schema.
Fixed by r350
(not yet released)
Original comment by [email protected]
on 2 Oct 2012 at 5:40
- Changed state: Verified
from common-schema.
Related Issues (20)
- The split query_script statement will not allow the use of PARTITION selection syntax feature of MySQL 5.6 HOT 3
- common_schema.json_to_xml is not parsing valid json array elements. HOT 3
- Documentation issue - Google is blocking access to query script execution page HOT 2
- Looking for innodb_index_stats in the wrong schema in mysql 5.6 HOT 4
- Bug in the _as_datetime() function HOT 4
- SUPER privilege error with Amazon RDS HOT 7
- Documentation issue
- sql_range_partition does not function as expected when the column is a timestamp integer
- split does not work if stop is specified HOT 1
- Routine dependencies fails on replace function
- Routine dependencies confuses default schema HOT 1
- Routine dependencies returns column name from a join <using> clause HOT 1
- Routine dependencies confused by <insert ... on duplicate update> HOT 1
- Routine dependencies misinterpret column when using insert statement schema name HOT 1
- common_schema 2.2 fails on install HOT 1
- Patch for /common_schema/routines/general_internal/_get_json_token.sql
- Minus breaks extract_json_value and anything dependent on json_to_xml HOT 1
- Errors when trying to install script via SQLYog HOT 1
- add next partition not using datetime fail after a value >= 10000 (or thereabouts)
- json_to_xml - malformed charset on output
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from common-schema.