collation Questions
2
I'm currently creating a mechanism to filter items by a query string.
I want to convert this to locale-aware version (basically, case-ignorance in English, but also for Japanese Kana):
return ite...
Longtin asked 29/3, 2017 at 8:26
2
Solved
A MySQL database running on Debian (version 5.5.41-0+wheezy1-log).
A table hotels with a column name VARCHAR(128) and engine is InnoDB.
CREATE TABLE `hotels` (
`id` int(11) unsigned NOT NULL AUT...
Premonish asked 10/4, 2015 at 21:16
3
I just upgraded my Postgres from 12 to 15 and I keep getting this error:
template database "template1" has a collation version, but no actual collation version could be determined
Here's ...
Sanctimony asked 15/3, 2023 at 14:34
3
Solved
CREATE TABLE `payment_methods` (
`payment_method_id` tinyint(4) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
PRIMARY KEY (`payment_method_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT C...
9
I got this error;
Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '='
I changed "Collations" to "utf8mb4_unicode_ci". Then tables were t...
2
Solved
I want to use an ICU system-insensitive sorting collation, to avoid sorting differences between postgres11-on-mac vs postgres11-on-Ubuntu. My first test was to dump out my existing Collate=en_US.UT...
Roup asked 5/4, 2020 at 20:8
23
Solved
I have a WordPress website on my local WAMP server. But when I upload its database to live server, I get error
#1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
3
Solved
Are MySQL primary key values case sensitive? If it's an option how do I set it? I want the table to be able to store "www.Example.com" and "www.example.com" as different values.
Tudela asked 28/3, 2013 at 16:18
23
Solved
The database is latin1_general_ci now and I want to change collation to utf8mb4_general_ci.
Is there any setting in PhpMyAdmin to change collation of database, table, column? Rather than changing ...
5
Solved
Is it possible to make query with a collation different from database table have?
5
So my goal is to set all the character sets and collations to utf8 and utf8_unicode_ci.
Im using an AWS RDS to host the MySQL server.
Ive set the collation_connection variable to utf8_unicode_ci ...
Lifeline asked 11/3, 2016 at 3:11
3
Solved
I can't figure out which is the query to run in order to see the current collation set for a mysql database.
I know I can change it running a query like this:
ALTER DATABASE db_name
[[DEFAULT] C...
Ravel asked 24/8, 2012 at 9:55
2
Sorting a string with number is done differently from one language to another. For example, in English digits come before letters in an ascending sorting. But, in German, digits are ascendant sorte...
18
Am getting the below error when trying to do a select through a stored procedure in MySQL.
Illegal mix of collations (latin1_general_cs,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '...
1
Solved
I see a number of questions on SO regarding something similar, but none of them addresses this particular detail.
I created a database using something like this:
CREATE DATABASE db CHARACTER SET ut...
5
Solved
I am building a web site in German language, So I will be using characters like ä, ü, ß etc., So what are your recommendations?
17
What is the (default) charset for:
MySQL database
MySQL table
MySQL column
Twilley asked 26/6, 2009 at 15:22
23
Solved
For a poor man's implementation of near-collation-correct sorting on the client side I need a JavaScript function that does efficient single character replacement in a string.
Here is what I mean (...
Isogonic asked 13/11, 2008 at 13:40
2
Solved
I have not been able to get locale-dependent functions such as strcoll() to work in C.
I am wondering whether I am doing something wrong and/or how to get this to work.
Here is a sample program fro...
9
Solved
Between utf8_general_ci and utf8_unicode_ci, are there any differences in terms of performance?
Tamikatamiko asked 20/4, 2009 at 3:43
6
Solved
When I tried to change the collation of my existing database (including data) from ARABIC_CS_AS to PERSIAN_100_CS_AS the following error occurs:
Alter failed for Database 'XXXX'. (Microsoft.SqlSer...
Pironi asked 10/9, 2011 at 10:58
5
Solved
I am working on a view, wherein I am using an inner join on two tables which are from two different servers. We are using linked server. When running the query I am getting this message:
Cannot ...
Mozellemozes asked 12/12, 2013 at 13:5
10
Solved
I would like to change the collation of all the columns of all the tables of my database. In stack overflow, I have found this script: (post)
SELECT 'ALTER TABLE [' + SYSOBJECTS.Name + '] ALTER CO...
Melburn asked 24/5, 2013 at 7:48
6
Solved
My database is not in UTF8, and I'd like to convert all the tables to UTF8, how can I do this?
5
Solved
I'm currently developing a website that is going to show stuff for almost any language in the world. And I'm having problems choosing the best collation to define in the MySQL.
Which one is the bes...
1 Next >
© 2022 - 2025 — McMap. All rights reserved.