IT Nursery 
Our previous programmer set the wrong collation in a table (Mysql). He set it up with Latin collation, when it should be UTF8, ...
-
June 1, 2022
- 0 Comments
create table check2(f1 varchar(20),f2 varchar(20)); creates a table with the default collation latin1_general_ci; alter table check2 collate latin1_general_cs; show full columns from check2; ...
-
May 30, 2022
- 0 Comments
I have a WordPress website on my local WAMP server. But when I upload its database to live server, I get error #1273 ...
-
May 22, 2022
- 0 Comments
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 ...
-
May 21, 2022
- 0 Comments
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 ...
-
May 21, 2022
- 0 Comments
Each time I was uploading my WP install from offline to online, I was noticing strange characters in text and digging a bit ...
-
May 18, 2022
- 0 Comments
I always knew that WordPress uses utf8_general_ci as tables collation, but recently it keeps installing utf8mb4_unicode_520_ci. What I do is: Download WordPress from ...
-
May 18, 2022
- 0 Comments
After upgrading from 2.8.x (maybe it was 2.9.x) to 3.1.2, all the references inside posts to filenames (usually images) which contain accented chars ...
-
May 10, 2022
- 0 Comments