collation
MySQL collation
I faced a very strange problem when developing on PHP and MySQL. I had such problem 4-5 years ago, but since than not. 开发者_开发百科And really don\'t remember how I solved it.[详细]
2023-04-04 01:10 分类:问答MySQL - Proper "Collation" for case-sensitive text? UTF8-bin?
In using 开发者_Python百科MySQL (v5.0.77) there are a lot of choices for Collation. I was originally thinking of UTF8-general_ci however MySQL shows it as being case-insensitive which I think would ca[详细]
2023-04-03 22:55 分类:问答What type of collation to use in a table
I have what is a simple problem that hopefully has a simple solution: I have a s开发者_StackOverflow中文版ite written in PHP and HTML, using a Linux server with MySQL.[详细]
2023-04-03 10:17 分类:问答SQL Server case/collation issue
I had a weird situation in a clients database today. SQL Server 2005, database collation is case-insensitive, so I can write SQL queries using any case, without anyproblem ... except one.[详细]
2023-03-31 05:16 分类:问答Why is ' 2' > '10'?
Why is \' 2\' with an initial space bigger than \'10\'? select \' 2\' > \'10\'; ?column? ----------[详细]
2023-03-27 18:34 分类:问答UTF8 string comparisons in MySQL
We have issues with utf8-string comparisons in MySQL 5, regarding case and accents : from what I gathered, what MySQL implements collations by considering that \"groups of characters should be c开发者[详细]
2023-03-27 01:28 分类:问答MySQL - Optimal Collation?
We are starting to get our p开发者_运维问答roduct more internationalized, and we are starting to encounter issues with foreign characters, mostly from Spanish and European (Greek, etc), and are wonder[详细]
2023-03-26 13:58 分类:问答Oracle Collation To SQL Server Collation During Migration
I am in the process of upgrading an Oracle DB to SQL Server. Currently the Oracle DB\'s collation is set to WE8ISO8859P1 (binary case sensitive Eastern European character set that allows for double by[详细]
2023-03-25 15:52 分类:问答PHP - display string ISO-8859-2
I have a mysql db - > column (Collation - latin2_general_ci) with this string : Alb complet, cu sticlă albă Satinato cu şlefuire în faţete[详细]
2023-03-25 12:04 分类:问答Why is MySQL treating é the same as e?
I\'m storing Unicode strings in a MySQL database with a Django web application. I can store Unicode data fine, but when querying, I find that é and e are treated as if they were the same character:[详细]
2023-03-25 00:40 分类:问答