Loading...
 
Architecture / Installation

Architecture / Installation


Converting tool latin->utf8 for a Tiki3 Database

posts: 1563 Germany

Hello,

I have a Tiki3 Installation developing since a while and sadly i haven´t been aware of the latin-utf8 encoding stuff that time.

Actually i cannot switch to Tiki5, until my template-coder finished work with the new (adopted)theme.
People already started working and the site is provisionally online, parallel with the old static site in the corporate design.

So some guys would freak out, if I changed before having the theme finished.

==>> So I need to transform the Database from latin1_swedish to utf8_general_ci without the marvellous converting tool of Tiki5.

Does anybody know a feeware tool for windows (7) that would convert my DB-Dump into utf8, for that I can reload it in the DB and use it with my 3.6 respectively 3.7?

Thanks for advise.
Torsten

posts: 289 United States

Can't you just create a temporary mySQL database, import the Tiki database, change the character encoding, and re-export it?

Actually, when I installed 5.1 I had character encoding issues and I simply changed the character encoding without any exporting/re-importing. It seemed to work.

I know this isn't technically converting the character set data but maybe you don't actually have to.

posts: 1563 Germany

Thank you,

I tried that - not sure if I did right.

When I change the allocation of the database, probably new tables will be in utf8, but all existing tables stay in latin1, indifferent, if I import or switch the allocation of the existing DB.

When I did restart the installer in a Tiki5 installation, I had the possibility to convert the DB - that would be fine for the Tik3 DB aswell. But in Tiki3 I do not have this function.

Converting with a Tiki5, I guess, I would not be able to use the DB back in Tiki3 - am I right with that?

So due to some issues, I still need the Tiki3 installation running at least for a couple of weeks.

Cheers
Torsten


Upcoming Events

1)  18 Apr 2024 14:00 GMT-0000
Tiki Roundtable Meeting
2)  16 May 2024 14:00 GMT-0000
Tiki Roundtable Meeting
3)  20 Jun 2024 14:00 GMT-0000
Tiki Roundtable Meeting
4)  18 Jul 2024 14:00 GMT-0000
Tiki Roundtable Meeting
5)  15 Aug 2024 14:00 GMT-0000
Tiki Roundtable Meeting
6)  19 Sep 2024 14:00 GMT-0000
Tiki Roundtable Meeting
7) 
Tiki birthday
8)  17 Oct 2024 14:00 GMT-0000
Tiki Roundtable Meeting
9)  21 Nov 2024 14:00 GMT-0000
Tiki Roundtable Meeting
10)  19 Dec 2024 14:00 GMT-0000
Tiki Roundtable Meeting