The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
1answer
397 views

DBD::mysql complains “Character set 'latin1' is not a compiled character set”

I think this boils down to "Am I doomed to upgrading mysql hoping the problem goes away?". I've seen a few of the same issues around the internet but with no guidance on a fix other than "Did you turn ...
0
votes
1answer
12 views

Completely disable all support for a certain CHAR SET in MySQL?

Is it possible to completely disallow certain charsets in MySQL and force an error and/or force everything into the server's chosen default charset?
0
votes
1answer
62 views

Remove question marks from database(latin1_general_ci table)?

How can I remove question marks(not diamond shaped) from a latin1_general_ci MyISAM table? I tried going back to utf8 and tried to apply things in ...
0
votes
1answer
42 views

change character set in mysql permanently

I want to change following parameters to utf8mb4 so that mysql can store emoji characters and special language characters. but when i try running following statements one by one SET ...
0
votes
1answer
50 views

Want to create partitions of a MySQL table and change the charset of new partitions

I have a database table which contains large amount of data. I have written a script to create new partitions every week and drop old partitions (which are of no use). Currently, I have a column in ...
1
vote
0answers
138 views

Master and slave tables with different character sets - will replication break?

We have some huge tables in our MySQL 5.6 database that have latin-1 as their character set, and want to convert them all to UTF-8 (along with converting the database's global character set). The ...
1
vote
0answers
399 views

How do I convert unicode data from UTF-16LE to UTF-8 when migrating from SQL Server to MySQL?

Objective: Ensure existing Unicode (UTF-16LE) data is displayed the when moved to MySQL (UTF-8). Background: I'm migrating 1TB from SQL Server to MySQL. The current Collation in SS is ...
1
vote
0answers
44 views

What is the smallest encoding?

I am now using latin1 (CHAR 10 column type) and I was wondering if there is more efficient character-set to store password hash consisting of a-z0-9 characters.
0
votes
0answers
14 views

Cant login to DataBase migration assistant in oracle 12c while i can easily connect in sqlplus

I need to change the character set of my database( I have no idea how it got created with that character set in first place! would be nice to know as well). I searched and found out that i need to use ...