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
Mysql i hrvatski znakovi

 
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
Tristan



Joined: 01 Aug 2006
Posts: 614
Location: Under the sky

PostPosted: 19.07.2008 15:10    Post subject: Mysql i hrvatski znakovi Add user to your forum ignore list Reply with quote

Zanima me na koji način spremate hrvatske znakove u bazu.

Koristim utf8_general_ci collation i utf8 charset pa me zanima je li bolji način pretvoriti hrvatske znakove u entitiese ili ih spremiti u "sirovom" obliku u bazu?

Cheerz

_________________
Carpe diem...
Back to top
View user's profile Send private message Visit poster's website
smile666



Joined: 26 Apr 2006
Posts: 5

PostPosted: 28.07.2008 00:37    Post subject: Add user to your forum ignore list Reply with quote

Možeš prije spremanja u bazu prebaciti hrvatske znakove u entitete, ali ako ti je utf-8 encoding na stranici ne bi ti trebao biti problem kod listanja već navedenih znakova. Problem kod entiteta ti je taj šta onda nećeš moći raditi dobro pretraživanje u bazi s hrvatskim znakovima ako imaš opciju search na stranici.
Back to top
View user's profile Send private message
hrvoje_86



Joined: 06 Dec 2006
Posts: 107
Location: Zagreb

PostPosted: 16.08.2008 09:53    Post subject: Add user to your forum ignore list Reply with quote

latin2_croatian_ci da mi sorta po našoj abecedi
Back to top
View user's profile Send private message Visit poster's website MSN Messenger
nevio



Joined: 25 Dec 2007
Posts: 173
Location: New Jersey / Rijeka

PostPosted: 20.09.2008 23:00    Post subject: Add user to your forum ignore list Reply with quote

sam ti koristi utf8... i nauci se ga koristit. Ja inace koristim utf8_unicode_ci

_________________
http://hr.linkedin.com/in/neviovesic
Back to top
View user's profile Send private message AIM Address
sphx



Joined: 02 Jun 2004
Posts: 109
Location: Split

PostPosted: 23.10.2008 20:31    Post subject: Add user to your forum ignore list Reply with quote

ja sam imao sličnih nedoumica, na kraju je rješenje bilo trivijalno: u editoru namjestit da sprema datoteke s UTF-8 encodingom, namjesitt isti charset i sve radi bez problema. pozdrav
Back to top
View user's profile Send private message Visit poster's website MSN Messenger
berofx



Joined: 19 Oct 2008
Posts: 12

PostPosted: 28.10.2008 22:31    Post subject: Add user to your forum ignore list Reply with quote

Džiz, zar nismo to sve već prerasli? Very Happy
Back to top
View user's profile Send private message
maratz
mi3.crew


Joined: 24 Nov 2003
Posts: 1207
Location: ZAG

PostPosted: 29.10.2008 07:18    Post subject: Add user to your forum ignore list Reply with quote

@berofx: o čemu ti to?

_________________
STOP HITTING YOURSELF! | NETIQUETTE | TYPETESTER | Hypertext rulez™ | CREATIVE NIGHTS | ACCOMMODATIONS
Back to top
View user's profile Send private message Visit poster's website Twitter profile
PaNtHeR



Joined: 17 Sep 2003
Posts: 161

PostPosted: 29.10.2008 07:42    Post subject: Add user to your forum ignore list Reply with quote

Nisam 100% siguran da je u MySQL > 5 još uvijek potrebno prilikom konekcije na bazu slati

Code:
set names utf8


ali od vremena MySQL-a 4.1. to imam u klasi za konektiranje na bazu i nisam nikad micao.

uz ovo ranije navedeno:

editor koda koji može radit u utf8 (DW, Zend, UltraEdit, Notepad+, ...)
ako čupaš podatke iz forme (što je vjerovatno slučaj) obavezno encoding stranice utf8

Svakako u sirovom obliku, jer entiteti nisu search friendly i mnoge funkcije ih znaju srezat..

_________________
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