- Welcome to coppermine-gallery.com/forum.
#1
cpg1.4 install / MySQL Collation mix problem, after clean install
October 19, 2006, 07:28:01 PM by Varrah...... ");" on 0 mySQL error: Illegal mix of collations (cp1251_general_ci,IMPLICIT) and ( ......
#2
Feature requests / Set default collation of the database tables during initial install
February 07, 2007, 03:49:02 PM by Freder...... to 'Set default collation of the database tables during initial install' ......
#3
cpg1.5 install / MySQL Database collation type for new install?
June 17, 2014, 04:32:42 AM by pols1337...... gallery, and in my phpMyAdmin I have a choice for collation types (which I've never had to choose before). ......
#4
Feature requests / Collation check/change/reminder when installing
August 30, 2010, 10:57:32 AM by jonket...... not familiar with what is the most common use of collation in database. As far as I can see CPG uses ............ collation of database it is going to use. When the ............ cause a conflict (like phpbb3 that uses utf8_bin collation default). It would be great to be able to ............ collation at install to avoid conflict with special ............ get information that I have to consider what collation to use. Anyway, since its is using UTF-8, is it ............ a bad idea that CPG sets at least the collation to utf8-bin during install (if that is the ......
#5
cpg1.4 upgrading / File Name Collation problem
July 18, 2008, 08:59:37 PM by tpr #6
Feature requests / Re: Collation check/change/reminder when installing
December 17, 2010, 09:21:56 AM by Αndré...... you're talking about. It's the charset, not the collation. The collation affects only the sorting of the ......
#7
cpg1.6 install / MySQL database and user for CPG 1.6
January 24, 2023, 11:19:28 PM by netboy...... and user: Do I need to specify anything, such as collation or anything else, when issuing the CREATE ......
#8
cpg1.6 upgrading / Encoding of the symbols
June 22, 2022, 11:08:14 PM by mitko...... all was well Coppermine charset is utf-8 Database Collation utf8mb4_unicode_ci (set by hoster) but all tables ............ utf8_general_ci - which should override DB collation ......
#9
cpg1.5 install / Re: MySQL Database collation type for new install?
June 17, 2014, 12:50:31 PM by gmc...... is to use charset UTF8 - which would then use the collation utf8-general-ci. Use of other charsets is ......
#10
cpg1.5 miscellaneous / Re: Problem with search tag words
December 12, 2011, 03:04:47 PM by Αndré...... the already existing encoding issue threads. The collation is meaningless for your issue. ......
#11
cpg1.4 bridging / Bridging and Collation Problem
January 14, 2007, 10:35:30 PM by anadolugezgini...... .Referencing to the posts sent,i guess database collations cause that error. My collations are : Mysql ............ collation : UTF8 General ci Coppermine Tables collation : ......
#12
cpg1.4 install / gallery install "latin1_swedish_ci" Collation.
January 18, 2008, 02:36:31 PM by uzidesign...... i install clean gallery in the database i see the Collation are "latin1_swedish_ci", so when i input data in ............ i see the data in database Gibberish. Why the Collation not UTF? Regards, uzi. ......
#13
Feature requests / Re: Set default collation of the database tables during initial install
February 08, 2007, 05:22:37 PM by Freder...... error. Maybe the database could be tested to be 'collation compliant'? I suppose somebody can be using pre 4. ......
#14
cpg1.5.x FAQ (Russian) / Кодировка в MySQL 4.1.* и MySQL 5.* (ветка 1.5.*)
August 19, 2010, 12:06:50 AM by Makc666...... .1/en/charset-mysql.html There is a convention for collation names: They start with the name of the character ......
#15
cpg1.6 language / Japanese text now gibberish after MySQL 8.0 upgrade
August 05, 2024, 08:40:45 AM by phil1011...... "latin1" character set and "latin1_swedish_ci" collation as the server defaults. The new versions of MYSQL ............ set and usually "utf8mb4_0900_ai_ci" as the collation. Your content was encoded under latin and swedish ......
#16
cpg1.5 miscellaneous / Re: Restoring old gallery in Bulgarian Cyrillic
July 30, 2015, 08:02:25 PM by gmc...... : Code Select Expand Charset Description Default collation Maxlen cp1251 Windows Cyrillic ......
#17
cpg1.5 language / Trouble with new Videos items or new comments. UTF8_general_ci
October 14, 2010, 03:26:18 PM by biwebco...... , apache has AddDefaultCharset UTF-8, BD Collation in utf8_general_ci, the forum is working fine, ......
#18
cpg1.4.x FAQ (Russian) / Кодировка в MySQL 4.1.* и MySQL 5.* - Экспорт - Импорт
May 07, 2008, 12:01:38 PM by Makc666...... .0 character set" contains both character set and collation information in one single entity. Beginning in ............ 4.1, character sets and collations are separate entities. Though each collation ............ utf8 character_set_system utf8 collation_connection utf8_general_ci collation_database ............ collation_server utf8_general_ci Ори&# ......
#19
cpg1.3 Installation & Setup / Please help cant login after install
September 09, 2004, 11:23:33 PM by scrimps...... ' AND user_active = 'YES'" on 0 mySQL error: COLLATION 'BINARY' is not valid for CHARACTER SET 'latin1' ......
#20
cpg1.4 bridging / SMF membergroups names in Greek not properly displayed in CPG 1.4x
December 12, 2006, 12:50:21 PM by agridoc...... Greek language file with same codepage. Database collation is latin-1_swedish. The same applies for SMF. ......
#21
cpg1.3.x Support / Corrupt Config Table After New Install
June 05, 2005, 02:33:11 AM by pompeii...... 5th row: <a href="sql.php?lang=en-utf-8&server=1&collation_connection=utf8_general_ci&db=mysql&table= ............ &goto=sql.php%3Flang%3Den-utf-8%26server%3D1%26collation_connection%3Dutf8_general_ci%26db%3Dmysql%26table ......
#22
cpg1.5.x Deutsch (German) / Problem mit Umlauten in Bildtitel und Beschreibung
June 04, 2013, 09:16:24 PM by Loewenherz...... , hat gerade den x-ten Serverwechsel hinter sich. Collation ist latin1_swedish_ci Hat jemand eine Idee? Was ......
#23
cpg1.4 install / Re: MySQL Collation mix problem, after clean install
October 24, 2006, 10:55:34 PM by Varrah...... one makes the full version check, charset check, collation check, compatibility check, and then makes all ............ about "to set or not to set the connection collation" looks ugly. It's like arguing about "to set or ......
#24
cpg1.5 install / New Server Challenge
June 19, 2013, 09:14:32 PM by mam...... and need help for remained: 1- unless charset and collation is utf8 but some special characters are distorted ......
#25
cpg1.5 language / Re: After upgrading from 1.4.x, non-ascii characters don't show properly
September 06, 2010, 04:10:06 PM by whitewash...... . When I enter phpmyadmin (with connection collation and charset set to utf8) and browse `categories` ......
#26
cpg1.5 upgrading / Re: Updating from 1.4.25 (stable) bridged to SMF
February 21, 2014, 06:39:51 PM by Dion...... sql tables or some weird bug between different collations/character-sets in database and files? Damn, ......
#27
cpg1.5 miscellaneous / Re: Issues with special characters and umlauts after upgrading from PHP4 to PHP5
April 16, 2014, 09:24:22 AM by olli80...... : You see the overview of the database. The collation is set to UTF8 Picture2: You see the cpg_picture ............ . Inside the picture table the collation is still latin. I dont know how this is affecting ............ ends up with error also. Picutre7: Changed collation of caption row manually does not change anything. ......
#28
cpg1.4 bridging / Re: upload by ftp after bridging with SMF and Joomla
September 07, 2006, 12:13:27 PM by Nibbler...... need to either convert the tables to the same collation (ideally utf-8), convert them on the fly in the ......
#29
cpg1.5 miscellaneous / Re: Problem with specific symbol in unicode
July 20, 2016, 09:25:03 AM by Αndré...... a reason? character_set_server latin1 - maybe collation_server latin1_swedish_ci - no I also don't know ......
#30
cpg1.5.x Русский (Russian) / Re: 1.5.8 проблемы с новыми записями и комментари&#
November 04, 2010, 03:10:52 PM by Makc666...... %';Code Select Expand SHOW VARIABLES LIKE 'collation_%'; И перем&# ......