- April 29, 2024, 03:32:06 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
Search results for: collation
61
cpg1.4.x Русский (Russian) / Кодировка на первой странице
« by srMax on April 21, 2009, 07:53:01 am »...... cp1251 character_set_system utf8 collation_connection utf8_general_ci collation_database ............ utf8_general_ci collation_server cp1251_general_ci из-з ......
62
cpg1.4 plugin contributions / Re: Backup: backup and restore the database
« by Joachim Müller on February 01, 2010, 07:16:26 am »...... subsequently both dumps) need to have the same collation. However, this plugin can't be used to restore ............ you in converting your dumps and changing the collation of a database - I suggest asking your webhost for ......
63
cpg1.5 permissions / Re: guest comments and rating problem
« by Αndré on July 20, 2010, 02:38:00 pm »...... claim that the collation wasn't the culprit of your problems. The ......
64
cpg1.4.x FAQ (Russian) / Re: Кодировка - в конец запутался
« by Makc666 on August 09, 2009, 09:21:26 pm »...... #1077;нные: Code: [Select] collation_connection utf8_general_ci collation_database ............ collation_server utf8_general_ci, кот&# ......
65
cpg1.4 language / Re: Database problem on Turkish language
« by izfd_adm on July 22, 2008, 01:48:54 pm »...... , I've changed collation and character set from mysql.ini file as utf8 I' ............ changed collation and character set of database to utf8_turkish_ci ............ utf_8, I've changed collation and character set of all tables to ......
...... last thing, for this to work, I had to alter the collation of the tables AND the columns as well to ......
67
cpg1.5 upgrading / Re: I have problem with charset after upgrading from 1.4
« by kuzmitch on July 31, 2010, 02:15:43 pm »...... .S. MySQL charset: UTF-8 Unicode (utf8) db collation: ......
...... apears S?ke in cpg databases... The CPG database collation at MYSQL is latin1_swedish_ci, is that what is ......
69
cpg1.4 upgrading / Coppermine 1.4.19 Installed -- How do I import the 1.4.2 files
« by kimhuff on January 12, 2009, 01:34:42 am »...... 23:00 GMT Database Version: 4.1.20-log Database Collation: utf8_general_ci PHP Version: 5.0.4 Web Server: ......
...... tryed again to change the collation on the fields and now all are utf8_unicode_ci and ............ I have no results. That is not related to the collation? ......
71
cpg1.5 install / Re: problem with creating new albums and photos in hebrew characters
« by genom on August 28, 2010, 10:10:26 pm »...... tried to change the database encode charcterset collation nothing ......
72
cpg1.5 bridging / Re: Username special characters (Icelandic) in bridge to phpbb3 disappear
« by jonket on August 28, 2010, 04:06:06 pm »...... it helps others. My problem was that default collation of database was latin1_unicode_ci and CPG uses ............ . On the other hand phpbb3 uses collation utf8 (does so when installing). This resulted in ............ conflict. So I set my database to collation utf8. Installed a fresh CPG install and the CPG ............ got the utf8 collation. Then I added in bridge/phpbb3.inc.php the ......
...... that the error will go away if you change the collation of the database alone, as it's only teh default ............ . Existing records won't change when changing the collation of the database table. The collation only ......
74
cpg1.4 miscellaneous / Re: problem with moving db to new host
« by genom on July 17, 2010, 01:15:49 pm »...... encodings.... utf 8 unicode and inside the db collation hebrew_general_ci ......
75
cpg1.4.x Русский (Russian) / Ïðîáëåìà ñ êîäèðîâêàìè ñðàçó ïîñëå óñòàíîâêè
« by Varrah on October 20, 2006, 10:58:27 am »...... ");" on 0 mySQL error: Illegal mix of collations (cp1251_general_ci,IMPLICIT) and ( ............ =' Êîíôèãóðàöèÿ õîñòèíãà: MySQL 4.1.9. (Default collation: koi8-r) PHP 5.0 (MBString, GD2) Ïîñòàâèë äëÿ âñå ............ õ ñîçäàííûõ òàáëèö ñíà÷àëà Collation cp1251_general_ci (âåðíåå äàæå ñàìà ñèñòåìà èõ òàê ......
76
cpg1.5 upgrading / Re: Fatal error when upgrading cpg14xx to cpg156
« by onthepike on June 15, 2010, 04:54:41 pm »...... empty): Field: access_level Type: tinyint(4) Collation: Attributes: Null: No Default: 3 Extra: If the ......
77
cpg1.2 PHPnuke/Postnuke Support / Calling random images
« by Smell on March 15, 2006, 06:04:06 pm »...... files use latin characters. In the database, its collation is set as "latin1_swedish_ci". An example: My ......
78
cpg1.4.x FAQ (Russian) / Re: Битая кодировка страница displayimage.php fullsize
« by ich on March 23, 2010, 01:54:52 am »...... /usr/local/share/mysql/charsets/ collation_connection utf8_general_ci collation_database ............ collation_server cp1251_general_ci Топ&# ......
79
cpg1.4 miscellaneous / Re: There was an error while processing a database query
« by Acen8s on June 12, 2010, 12:11:37 am »...... this table: Field: owner_name Type: varchar(40) Collation: latin1_swedish_ci Attributes: *NONE - LEAVE ......
80
cpg1.4 miscellaneous / Database Backup - How do I get one ?
« by chasingame on January 13, 2006, 10:08:19 pm »...... =@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 ......
81
cpg1.4.x Français (French) / Re: Transfert galerie Coppermine vers autres Serveur
« by cameron69 on May 02, 2010, 12:44:51 pm »...... =@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 ......
82
cpg1.4 permissions / Re: Login and Cookie error (one more time)
« by EA1DDO on December 24, 2009, 10:38:03 pm »...... =@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 ......
83
cpg1.5 miscellaneous / Re: more than 4 custom fields in 1.5.3
« by Joachim Müller on April 06, 2010, 07:26:38 am »...... of the field it has user(x) as varchar(255) with collation latin1_swedish_ci(this may vary and its important ............ you add tables in the same collation as the ones already in the database)and is not ......
84
cpg1.4 miscellaneous / Re: Fixing encoding in database
« by Joachim Müller on October 30, 2008, 08:26:36 pm »...... sure that you have set up the mysql table collation correctly. ......
85
cpg1.4 miscellaneous / Re: encoding issue (MySQL 4.1.15)
« by DJMaze on December 02, 2005, 07:35:51 pm »...... , tables and columns use charset = latin1 and collation = latin1_general_ci but if something is different ............ - character_set_results - collation_connection They all should read utf8 except ............ read the records: - character_set_database - collation_database If character_set_database doesn't ............ NAMES <value of character_set_database> If both collations don't comply then use Code: [Select] SET ......
86
cpg1.4 miscellaneous / Re: Case Sensitive Searching on IIS hosted Coppermine
« by Nibbler on March 05, 2007, 08:58:18 pm »...... way is to use a case sensitive collation in the db. If you don't want to edit the db then ......
87
cpg1.4 miscellaneous / Re: moving gallery to new server - encoding issue
« by Joachim Müller on September 19, 2006, 08:05:14 am »...... could try changing the collation of your database tables using a tool like ......
Technical term is "collation"
89
Looking for Freelancers / Paid help / Re: [paid] CPG >SMF bridge encoding problem
« by parnat on September 22, 2009, 08:17:27 pm »...... with myphp/mysql setup exactly as old host MysQL (collation utf-8, latin1) So , now I see chars propagate ......
90
Feature requests / Re: Option to save / load all categories & albums (without pictures)
« by Joachim Müller on July 06, 2009, 09:47:24 am »...... , problem of escaping special chars properly, collation issues etc.). While we welcome your suggestions ......