Forum FAQForum FAQSearchSearch MemberlistMemberlist Forum ignore listForum ignore list RegisterRegister ProfileProfile Log in to check your private messagesLog in to check your private messages Log inLog in
crazy collation?

 
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    mi3dot.org Forum Index -> Server-side
View previous topic :: View next topic  
Author Message
madal



Joined: 24 Oct 2006
Posts: 9

PostPosted: 04.07.2008 13:53    Post subject: crazy collation? Add user to your forum ignore list Reply with quote

Greška koja se ispisuje na stranici prilikom postanja komentara s nekim od (ne svim) našim znakovima... npr. ć i malo đ uredno prolaze,...ponekad i č, ali Đ nikako?!?!

Code:
DB Error: unknown error

SELECT comment_id FROM c5t_comment WHERE comment_text = 'đakovo Čučerje' [nativecode=1267 ** Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '=']SQL Statement

SELECT comment_id FROM c5t_comment WHERE comment_text = ?


Sistemske varijable 'na bazi' su sljedeće

character set client utf8
(Global value) latin1
character set connection utf8
(Global value) latin1
character set database latin1
character set results utf8
(Global value) latin1
character set server latin1
character set system utf8
character sets dir /usr/share/mysql/charsets/
collation connection utf8_unicode_ci
(Global value) latin1_swedish_ci
collation database latin1_swedish_ci
collation server latin1_swedish_ci


Na bazu postavio utf8_unicode_ci charset.


Kako ovo riješiti? Ako netko zna, neka nesebično podijeli samnom, biti ću mu preprezahvalan Wink [/img]
Back to top
View user's profile Send private message Send e-mail
zytzagoo
mi3.crew


Joined: 25 Aug 2003
Posts: 1842
Location: Zagreb, Hrvatska

PostPosted: 05.07.2008 10:44    Post subject: Add user to your forum ignore list Reply with quote

Probaj
Code:
SET NAMES utf8;
kao prvi query koji radis na siteu.

Svakako osiguraj da je sve u bazi postavljeno na utf8 (baza, tablice, connection charset,
results charset...), da je stranica sa koje se posta komentar isto utf-8...

utf8_unicode_ci je collation, a ne charset.

_________________
[+]I[+]am[+]my[+]own[+]religion[+]
Back to top
View user's profile Send private message Visit poster's website Twitter profile
madal



Joined: 24 Oct 2006
Posts: 9

PostPosted: 06.07.2008 01:52    Post subject: Add user to your forum ignore list Reply with quote

hvala na odgovoru, no dešava mi se sljedeće

1. kada želim promijeniti encoding u utf-8 preko DW-a, nakon sejvanja i ponovnog otvaranja uvijek mi vraća na Western?!

probao sam fajl snimiti i u Notepadu, ali onda mi ubacuje BOM, pa ako maknem kvačicu sa BOM, encoding je opet Western...
Back to top
View user's profile Send private message Send e-mail
zytzagoo
mi3.crew


Joined: 25 Aug 2003
Posts: 1842
Location: Zagreb, Hrvatska

PostPosted: 06.07.2008 02:09    Post subject: Add user to your forum ignore list Reply with quote

madal wrote:
probao sam fajl snimiti i u Notepadu, ali onda mi ubacuje BOM, pa ako maknem kvačicu sa BOM, encoding je opet Western...

Probaj za test snimiti s PsPad-om, programmer's notepad... bilo koji normalni free text editor.
Cisto da vidis hoce li ti to rijesiti izvorni problem ili nece...

_________________
[+]I[+]am[+]my[+]own[+]religion[+]
Back to top
View user's profile Send private message Visit poster's website Twitter profile
madal



Joined: 24 Oct 2006
Posts: 9

PostPosted: 06.07.2008 21:08    Post subject: Add user to your forum ignore list Reply with quote

ne rješava Sad
instalirao PSPad, ali dalje isti problem.
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    mi3dot.org Forum Index -> Server-side All times are GMT + 1 Hour
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group