Most voted "collation" questions
14 questions
Sort by count of
-
26
votes2
answers2693
viewsWhat is the difference between charset and collation in a database?
Every time I create a database, I always come across these definitions and I don’t really know the difference. I understand what it is charset, but not collation.
-
20
votes2
answers29759
viewsChange the "collation" and "Character set" of the database, tables and corresponding columns
Some older projects were designed for their immediate purpose and based on this, the databases, tables and columns were prepared in a way limited to the intended scenario. In order to update and…
-
7
votes3
answers2527
viewsHow to determine the sort of accented characters in Mysql?
My table uses "utf8-general-ci" so all accents are OK. But when I have for example Aa, Ac and Áb and I want to filter "in alphabetical order", the result is: Aa Ac Áb About Excel, the result is: Aa…
-
5
votes2
answers4183
viewsHow to discover a collation of a table or database using an SQL query?
I can visualize the collation of certain table or bank perfectly by Phpmyadmin. But if I did not dispose of this aforementioned tool, as I could do to discover the collation by manually doing an SQL…
-
4
votes2
answers1216
viewsCompare two strings with C accentuation
I have the following problem, I need to compare two strings ignoring the accent, for example: Étnico | Brasil Using a normal comparison function it is returned that "Ethnic" comes before "Brazil" in…
-
1
votes0
answers476
viewsCollation does not recognize accentuation
Ttenho 2 banks in Sqlserver, bank A with the collation SQL_Latin1_General_CP850_CI_AS and another bank called B with the collation Latin1_General_CI_AS. At bank A imports information to bank B. A…
-
1
votes1
answer22
views -
1
votes0
answers60
viewsHow to include words without accent in search results - PHP, Mariadb
Please, I need a little bit of your wisdom and patience. I’m developing a website, which has a search page, and I need to make the results presented "Accent insensitives". That is, if the person…
-
0
votes1
answer379
viewsHelp - Collation Conflict
Srs(as), good afternoon, Could help me identify a problem? I am changing a PROC and when testing it is occurring the following error: Cannot resolve the collation Conflict between…
-
0
votes0
answers22
viewsIs it possible to make the encoding of a Mysql database equal to the encoding of a PHP/HTML5 page?
For example, in my table in Mysql the word appears Creditworthiness and in the bank "Crã dito", Valid until on the site appears as "V read until " in the bank. I am using in HTML5 the UTF-8, in the…
-
-1
votes1
answer118
viewsQuick doubt with Collate on Mariadb
I set Collate to Latin_swedish_ci to accept accentuated characters, but as in the second image, the date is not stored in Portuguese format. How to make it be stored in Portuguese? This is standard…
-
-1
votes3
answers107
viewsWrong encoding in Mysql when I enter via AJAX
I’m having trouble finding a solution to my problem. Briefly: I send data to a table, using a php file that does querry, and an ajax call that sends all the values I need to the php file. When it is…
-
-1
votes1
answer146
viewsError when changing the data type of a column by the interface
I try to change the type of data VARCHAR for another type of data by the system interface (I don’t want to change via SQL) but I can’t. I have the following table created: CREATE TABLE `Usuarios` (…
-
-2
votes2
answers27
viewsSQL command works on SQL SHELL, but does not work on Node (pg) (probably something related to accentuation)
DATABASE I have this database: In it I have this table: In it I have this data: NODE const express = require('express'); const app = express(); const cors = require('cors'); // cors config //…