Questions tagged as 'collation'

2
answers

What is the difference between charset and collation in database?

Every time I create a database, I always come across these definitions and I do not really know the difference. I understand what is charset , but not collation .     
asked by 26.08.2014 / 16:16
2
answers

Change the collation and character set of the database, tables and corresponding columns

Some older projects were thought of in their immediate purpose and based on this the databases, tables and columns were prepared in a way limited to the intended scenario. In the sense of updating and adapting to a greater scalability of thes...
asked by 28.02.2014 / 22:51
3
answers

How to determine the ordering 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 Ab and I want to filter "alphabetically", the result is: Aa Ac Ab On Excel, the result is: Aa Ab Ac Which is more logical. How...
asked by 19.02.2015 / 19:45
2
answers

How to find a collation of a table or bank using a SQL query?

I can perfectly visualize the collation of a given table or database by PHPMyAdmin. But if I did not have this tool mentioned above, how could I do to find the collation by doing a SQL query manually?     
asked by 13.03.2017 / 14:03
2
answers

Compare two strings with C accent

I have the following problem, I need to compare two strings ignoring the accent, for example: Étnico | Brasil Using a normal function of comparison is returned that "Ethnic" comes first that "Brazil" in view...
asked by 11.07.2015 / 18:50
0
answers

Collation does not recognize accent [closed]

I have 2 banks in SqlServer, A bank with collation SQL_Latin1_General_CP850_CI_AS , and another bank named B with collation Latin1_General_CI_AS . At bank A, you import information into bank B. A migration of the...
asked by 22.09.2015 / 22:26
1
answer

Help - Conflict of Collation

Sirs, good afternoon, Could you help me identify a problem? I am changing a PROC and testing it is the following error:    Can not resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the s...
asked by 10.07.2015 / 16:43
2
answers

Change the collation and character set of the database, tables and corresponding columns

Some older projects were thought of in their immediate purpose and based on this the databases, tables and columns were prepared in a way limited to the intended scenario. In the sense of updating and adapting to a greater scalability of thes...
asked by 28.02.2014 / 22:51
1
answer

Error changing the data type of a column from the interface

I try to change the data type from VARCHAR to another data type through the system interface (I do not want to change via SQL) but I can not. I have the following table created: CREATE TABLE 'Usuarios' ( 'id_usuario' int(11) NOT...
asked by 22.03.2018 / 10:14
3
answers

Wrong encoding in MySQL when I enter through AJAX

I'm having trouble finding a solution to my problem. Briefly: I send data to a table, using a php file that does the querry, and an ajax call that sends all the values I need to the php file. When it is inserted in the table the accents of th...
asked by 01.02.2017 / 20:12