A collation is a set of rules that determine how data is sorted and compared for comparing characters in a character set.
2
votes
0answers
182 views
SQL fulltext accent insensitive
I am using SQL Server fulltext containstable and the column which is indexed has collation Czech_CS_AS, so why when I have word "byt" it returns records with word "být" too. I thought that the ...
1
vote
0answers
102 views
SQL Server: Collation of the resource database
I'm trying to use stopwords so that some words are skipped by the Full-Text Indexer. I can add those stopwords in the table sys.fulltext_stopwords.
When trying to get a list of stopwords and ...
1
vote
0answers
66 views
What would make a MySQL database create tables in a different collation other than its default?
I am adding tables to a Wordpress database on my localhost and it is changing my collation from utf8_general_ci to latin1_swedish_ci. I'm kinda stumped because I'm not familiar with working directly ...
1
vote
0answers
261 views
Why not use SQL_Latin1_General_CI_AS for a global system?
What would be some really good reasons to not use the SQL_Latin1_General_CI_AS collation on a system which handles English, German, Japanese, and Chinese data?
I'm having a really hard time finding ...
1
vote
0answers
307 views
Server Collation Change Error
I am using following command to change the collation of my SQL Server R2 (10.50.1600):
setup.exe /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=MSSQLServer /SQLSYSADMINACCOUNTS=sa /SAPWD=**** ...
0
votes
0answers
38 views
Converting data from MSSQL Server to MySQL using MySQL Workbench and preserving special characters
I am trying to convert a MSSQL Server database with collation SQL_Latin1_General_CP1_CI_AS into a MySQL database using MySQL Workbench. I can successfully complete the process without any issues being ...
0
votes
0answers
65 views
Custom doctrine default character set
In my.ini mysql file, i have this :
[mysqld]
collation-server = utf8_general_ci
character-set-server = utf8
When i create my database with "doctrine:database:create", my collation db is in ...
