Posted: 04.07.2008 14:53 Post subject: crazy collation?
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 [/img]
Joined: 25 Aug 2003 Posts: 1842 Location: Zagreb, Hrvatska
Posted: 05.07.2008 11:44 Post subject:
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...
Joined: 25 Aug 2003 Posts: 1842 Location: Zagreb, Hrvatska
Posted: 06.07.2008 03:09 Post subject:
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...
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