- April 29, 2024, 03:21:09 am
- Welcome, Guest
News:
CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE
...... you also need to set the character set, but the collation only affects the default order (which may be ......
32
cpg1.5 upgrading / Category Show Problems (Possible Encoding Reasons) After Upgrading From 1.4.27
« by Cmaniac on June 14, 2010, 12:35:45 pm »...... was created with latin1 encoding (swedish collation) although Greek language is the main language ......
33
cpg1.4 miscellaneous / UTF8 trouble in "title" and "caption" fields
« by brazzmonkey on February 18, 2007, 03:03:09 pm »...... to use the correct utf-8 charset, - changing collations in phpmyadmin to use utf-8 instead of western, - ......
34
cpg1.4 bridging / Coppermine and SMF messes greek fonts when bridged
« by blackRock on April 09, 2007, 05:08:18 pm »...... greek as my language for both of them. The table collation for coppermine is utf8_unicode_ci and works great ............ it is not bridged. The table collation for coppermine is utf8_general_ci and also works ............ О§ПЋПЃОїО№ I've tried to make SMF having the same collation as Coppermine but it didn't work. The problem ......
35
cpg1.4 miscellaneous / Problems with the characters
« by tesala on November 14, 2007, 01:28:09 pm »...... database _pictures, in which I canґt change the collation latin1_general_ci. On the other hand, I have ......
36
cpg1.4 miscellaneous / [Solved]: Properties, editing pictures
« by Kajoke on April 20, 2008, 06:22:33 pm »...... ORDER BY title" on 0 mySQL error: Illegal mix of collations for operation 'concat' Fil: /usr/local/psa/home/ ............ BY cat_title" on 0 mySQL error: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and ( ............ BY cat_title" on 0 mySQL error: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and ( ......
37
cpg1.4 Testing/Bugs: FIXED/CLOSED / Re: Vbulletin 4.0 with cpg 1.4.25
« by alfisti.net on December 26, 2009, 01:38:31 pm »...... with public access). I wrote the note for collation incompatiblity because it happened to my test. ......
38
cpg1.4.x Русский (Russian) / Помогите с кодировкой плиз.
« by smira on January 15, 2010, 01:32:00 pm »...... /usr/local/share/mysql/charsets/ collation_connection utf8_general_ci collation_database ............ collation_server ......
39
cpg1.5 upgrading / Re: The group table does not contain the Anonymous group and other errors
« by spiros71 on February 23, 2011, 01:27:47 am »...... the actual pages and the dB and relevant tables collation) and remains as such. For example the comment &# ......
40
cpg1.4.x Русский (Russian) / Re: вот такие значки в письме о регистрации �
« by Makc666 on August 23, 2011, 02:22:03 pm »...... character_sets_dir /usr/share/mysql/charsets/ collation_connection utf8_general_ci collation_database ............ cp1251_general_ci collation_server cp1251_general_ci Я ч&# ............ с верной collation utf8_general_ci. ......
41
cpg1.5 miscellaneous / Re: cpg_1.4 With Issue – Upgread or Install cpg_1.5?
« by Straydog on June 07, 2012, 01:25:30 am »...... result set (i.e. zero rows). /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;# MySQL ......
...... may be case sensitive for you, depending on which collations you used for your tables. ......
43
cpg1.5.x Русский (Russian) / Re: Проблемы с кодировкой
« by mixermsk on February 28, 2011, 08:36:06 pm »...... прос: SHOW VARIABLES LIKE 'collation_%'; Code: [Select] Variable_name Value ............ utf8_general_ci collation_database cp1251_general_ci collation_server ......
44
cpg1.4 bridging / Re: Critical error in album properties and batch add file after bridge
« by Sami on September 20, 2006, 09:23:29 am »...... [[DEFAULT] CHARACTER SET charset_name] [COLLATE collation_name] something like this should work for you ............ run this query for each table that has different collation or you could simply change database collation by ............ SET charset_name] [[DEFAULT] COLLATE collation_name] ......
45
cpg1.4 bridging / Uploaded pictures in Community Builder Profile from Joomla 1.5.13
« by zaanhoeve on August 08, 2009, 01:30:00 pm »...... Database Version: 4.1.22-standard-log Database Collation: utf8_general_ci PHP Version: 5.2.6 Web ......
46
cpg1.3 Upload / Re: mysql 4.1 problems with batch add
« by kegobeer on October 19, 2004, 12:55:19 am »...... MySQL databases - do a search for Illegal mix of collations for operation 'concat' on google. Sometimes ......
47
cpg1.5.x FAQ (Russian) / Re: Интеграция (bridging) CPG 1.5.12 с phpBB3.X и некоторые наблюдения
« by Petrovichalt on April 24, 2011, 06:10:55 pm »...... ; спи@%дел, collation_connection utf8_unicode_ci collation_database ............ cp1251_general_ci collation_server cp1251_general_ci character_set_client ......
48
cpg1.4 language / [Solved]: Problem with serbian characters ЉĐČĆЋ=?
« by vlado85 on August 19, 2009, 08:36:28 pm »...... with characters on the Coppermine gallery 1.4.25. Collation gallery is on the Unicode (utf-8), and my tables ......
49
cpg1.4 language / Re: Cyrillic characters in database
« by Old RMN on July 09, 2010, 07:24:53 am »...... display problems who already have checked the collation settings of their own database and its tables: ......
50
cpg1.3 Upload / Concat error in administartor tool, upload autorisation, multi upload + search
« by meije683 on October 17, 2005, 02:31:08 pm »...... BY cat_title" on 0 mySQL error: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and ( ............ , title" on 0 mySQL error: Illegal mix of collations for operation 'concat' USER: ----------------- ......
51
cpg1.4.x Русский (Russian) / траблы с кодировкой, поиск не помог.. пробле может быть в БД?
« by 0zz on May 19, 2006, 04:06:07 pm »...... нет. у меня в БД почему-то везде выстален charset collation как latin-swedish-ci но в принципе, все работает н ......
...... Database Version: 4.1.22-standard Database Collation: utf8_general_ci PHP Version: 5.1.6 Web ......
53
cpg1.4.x Русский (Russian) / Еще раз про кодировку (перенос старой версии 1.3.* на новую)
« by segank on February 28, 2008, 04:59:27 pm »...... character_sets_dir /usr/share/mysql/charsets/ collation_connection utf8_unicode_ci collation_database ............ collation_server utf8_general_ciВот проблема в чем: если ус ......
54
cpg1.3 Permissions & Access Rights / Critical error - There was an error while processing a database query.
« by dfuncr on March 07, 2005, 12:41:06 pm »...... , title" on 0 mySQL error: Illegal mix of collations for operation 'concat' Full Debug Code: [Select] ......
...... When I created DB in phpMyAdmin I used (default) Collation, was I suppose to choose something else ? Can ......
56
cpg1.4.x Franзais (French) / Upload Ftp aprиs brige avec SMF et Joomla
« by Franзois Keller on September 06, 2006, 09:45:31 pm »...... ORDER BY title" on 0 mySQL error: Illegal mix of collations for operation 'concat' ......
57
cpg1.5 upgrading / Re: Upgrade to v1.5.10 and got problems with the swedish characters едц
« by larsur on December 17, 2010, 11:18:30 pm »...... work to much with MySQL but in the database the collation on column level is "latin1_swedish_ci" by default ............ are: MySQL characterset: UTF-8 Unicode (utf8) Collation for MySQL-connection is "utf8_unicode_ci" I dont ......
58
cpg1.4 bridging / [Solved]: user name shows as question marks
« by comrade on January 09, 2009, 07:18:36 pm »...... problems? I converted mySQL to utf8_unicode_ci collation, so both DB's are the same (i dont have to ......
59
cpg1.4.x FAQ (Russian) / Re: Кодировка - проблемы - перейти с CP-1251 нa UTF-8
« by Makc666 on July 19, 2010, 08:20:47 am »...... #1072;внение" (Collation) для таб&# ......
60
cpg1.5.x Русский (Russian) / Re: непонятные уведомления на почту админу
« by D.Kalessky on November 12, 2010, 09:02:30 am »...... прос: SHOW VARIABLES LIKE 'collation_%'; Variable_name Value collation_connection ............ collation_database cp1251_general_ci collation_server ......