Advanced search  

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

Pages: [1] 2 3 4
1
Feature requests / Re: Collation check/change/reminder when installing
« by Αndré on December 17, 2010, 09:21:56 am »

......  you're talking about. It's the charset, not the collation. The collation affects only the sorting of the  ......
2
cpg1.6 install / MySQL database and user for CPG 1.6
« by netboy on January 24, 2023, 11:19:28 pm »

......  and user:  Do I need to specify anything, such as collation or anything else, when issuing the CREATE  ......
3
cpg1.6 upgrading / Encoding of the symbols
« by mitko on June 22, 2022, 11:08:14 pm »

......  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    ......
4
cpg1.5 install / Re: MySQL Database collation type for new install?
« by gmc on June 17, 2014, 12:50:31 pm »

......  is to use charset UTF8 - which would then use the collation utf8-general-ci.  Use of other charsets is  ......
5
cpg1.5 miscellaneous / Re: Problem with search tag words
« by Αndré on December 12, 2011, 03:04:47 pm »

......  the already existing encoding issue threads. The collation is meaningless for your issue. ......
6
cpg1.4 bridging / Bridging and Collation Problem
« by anadolugezgini on January 14, 2007, 10:35:30 pm »

...... .Referencing to the posts sent,i guess database collations cause that error.  My collations are : Mysql  ............  collation : UTF8 General ci Coppermine Tables collation :  ......
7
cpg1.4 install / gallery install "latin1_swedish_ci" Collation.
« by uzidesign on January 18, 2008, 02:36:31 pm »

......  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. ......

......  error. Maybe the database could be tested to be 'collation compliant'? I suppose somebody can be using pre 4. ......

...... .1/en/charset-mysql.html There is a convention for collation names: They start with the name of the character  ......
10
cpg1.4 upgrading / File Name Collation problem
« by tpr on July 18, 2008, 08:59:37 pm »
11
cpg1.5 miscellaneous / Re: Restoring old gallery in Bulgarian Cyrillic
« by gmc on July 30, 2015, 08:02:25 pm »

...... : Code: [Select] Charset Description Default collation Maxlen  cp1251 Windows Cyrillic  ......
12
cpg1.5 language / Trouble with new Videos items or new comments. UTF8_general_ci
« by biwebco on October 14, 2010, 03:26:18 pm »

...... , apache has AddDefaultCharset UTF-8, BD Collation in utf8_general_ci, the forum is working fine,  ......

...... .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 Ори&# ......
14
cpg1.3 Installation & Setup / Please help cant login after install
« by scrimps on September 09, 2004, 11:23:33 pm »

...... ' AND user_active = 'YES'" on 0  mySQL error: COLLATION 'BINARY' is not valid for CHARACTER SET 'latin1'  ......

......  Greek language file with same codepage. Database collation is latin-1_swedish. The same applies for SMF.   ......
16
cpg1.3.x Support / Corrupt Config Table After New Install
« by pompeii on June 05, 2005, 02:33:11 am »

......  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  ......

...... , hat gerade den x-ten Serverwechsel hinter sich. Collation ist latin1_swedish_ci Hat jemand eine Idee? Was  ......
18
cpg1.4 install / Re: MySQL Collation mix problem, after clean install
« by Varrah on October 24, 2006, 10:55:34 pm »

......  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  ......
19
cpg1.5 install / New Server Challenge
« by mam on June 19, 2013, 09:14:32 pm »

......  and need help for remained: 1- unless charset and collation is utf8 but some special characters are distorted  ......

...... . When I enter phpmyadmin (with connection collation and charset set to utf8) and browse `categories`  ......
21
cpg1.5 upgrading / Re: Updating from 1.4.25 (stable) bridged to SMF
« by Dion on February 21, 2014, 06:39:51 pm »

......  sql tables or some weird bug between different collations/character-sets in database and files?  Damn,  ......

...... : 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.  ......
23
cpg1.4 bridging / Re: upload by ftp after bridging with SMF and Joomla
« by Nibbler on September 07, 2006, 12:13:27 pm »

......  need to either convert the tables to the same collation (ideally utf-8), convert them on the fly in the  ......
24
cpg1.5 miscellaneous / Re: Problem with specific symbol in unicode
« by Αndré on July 20, 2016, 09:25:03 am »

......  a reason?     character_set_server latin1 - maybe collation_server latin1_swedish_ci - no  I also don't know  ......

......  'character_%';Code: [Select] SHOW VARIABLES LIKE 'collation_%'; И перем&# ......
26
cpg1.5 miscellaneous / Re: Search-page with wrong swedish letters
« by nickelas on March 27, 2014, 11:01:47 am »

......  too. So it says PÃ¥byggnad instead of Påbyggnad.  Collation looks like it is latin1_swedish_ci. The charset  ......
27
cpg1.5 miscellaneous / Re: Do not look for keywords in small letters
« by Αndré on August 23, 2013, 02:32:16 pm »

......  far as I know the commonly used default MySQL collations are not case sensitive. Maybe you use a case  ............  collation, but it's maybe a Unicode issue. There are  ............  sensitive search and therefore changed the table collations. Maybe you can do the opposite. There's also an  ......
28
cpg1.5 upgrading / Fatal error when upgrading from cpg1.4.25 to cpg1.5.8
« by JohnH on October 31, 2010, 03:58:49 pm »

......  Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type  ......

...... , I will investigate... Just one question, which "Collation" are your table fields? you can see this, as  ............  -> structure, see the title and caption fields' collations. It would be nice to have them in a generic UTF8/ ......
30
cpg1.5 upgrading / Re: Database Critical Error
« by pols1337 on December 30, 2014, 03:10:50 am »

...... /, or plugins/ folder.   Also, my database's collation is latin1_swedish_ci.   Would any of those  ......
Pages: [1] 2 3 4

 

Page created in 0.17 seconds with 30 queries.