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
Promjena charseta u SQL-u

 
Post new topic   Reply to topic    mi3dot.org Forum Index -> Server-side
View previous topic :: View next topic  
Author Message
Nemesis



Joined: 01 Oct 2005
Posts: 732

PostPosted: 20.06.2010 12:49    Post subject: Promjena charseta u SQL-u Add user to your forum ignore list Reply with quote

Nakon što sam ručno izbrisao sve fileove starog wordpressa i zatim na to mjesto stavio novi wordpress 3.0 i instalirao, baza podataka (koju nisam ni dirao) je promjenila charset iz utf8_unicode_ci u latin1_swedish_ci kako je to prikazano na slici


Zbog toga su mi neka hrvatska slova (npr. č) zamjenjena u švedska (u ovom slučaju Ä). Kako to što bezbolnije vratiti.

BTW: Prije nego što sam počeo deletati napravio sam backup baze podataka...

_________________
Webastično.com | Last.fm | Twitter
Back to top
View user's profile Send private message Send e-mail Visit poster's website MSN Messenger Twitter profile
Nemesis



Joined: 01 Oct 2005
Posts: 732

PostPosted: 20.06.2010 14:27    Post subject: Add user to your forum ignore list Reply with quote

E ovako, uspio sam promjeniti charset putem php skripte (tnx to @gosaric), ali i dalje mi se nisu promjenila slova pa me zanima jel postoji neki jednostavan način da te znakove promjenim? Može i neki wp plugin koji bi to radio...

_________________
Webastično.com | Last.fm | Twitter
Back to top
View user's profile Send private message Send e-mail Visit poster's website MSN Messenger Twitter profile
Nemesis



Joined: 01 Oct 2005
Posts: 732

PostPosted: 20.06.2010 15:46    Post subject: Add user to your forum ignore list Reply with quote

Evo, uspio sam riješiti problem, ali ako netko zapadne u istu frku, evo solušn...

1. Promjena charseta (tnx to @gosaric)
http://kb.siteground.com/article/How_to_change_the_collation_for_all_tables_in_db_to_UTF8.html

2. Promjena znakova putem WP-a
http://www.hongkiat.com/blog/how-to-search-and-replace-wordpress-in-blog-post/

_________________
Webastično.com | Last.fm | Twitter
Back to top
View user's profile Send private message Send e-mail Visit poster's website MSN Messenger Twitter profile
suncek



Joined: 18 Feb 2005
Posts: 613
Location: Zgb

PostPosted: 20.06.2010 16:29    Post subject: Add user to your forum ignore list Reply with quote

a ovo??
http://wordpress.org/extend/plugins/utf-8-db-converter/

_________________
----->
studio-propaganda.com
Back to top
View user's profile Send private message Visit poster's website MSN Messenger
Limeni



Joined: 13 Nov 2007
Posts: 109
Location: Zagreb

PostPosted: 22.06.2010 20:55    Post subject: .. Add user to your forum ignore list Reply with quote

Probaj sa:

Code:

ALTER DATABASE `ime_mysql_baze` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    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