iso-8859-1 -> UTF-8?

Previous topic

Install & configuration

Next topic

Author	Message
Jason Filby	Wednesday 10 March 2004 8:54:35 pm Hi all My site uses charset iso-8859-1, but now I want to change over to UTF-8. Is there any documentation on this process? Thanks Jason
Bård Farstad	Thursday 11 March 2004 12:01:39 am There is a page on this topic: http://ez.no/ez_publish/documentation/configuration/configuration/language_and_charset/unicode_with_ez_publish Basically you need to change some .ini settings then you need to convert the character set of your database. In MySQL you can do this with myisamchk, haven't converted a PostgreSQL database so you would need to look up the charset conversion in the psql doc. If you want to use MySQL you need to use the 4.1 development release. --bård Documentation: http://ez.no/doc
Georg Franz	Thursday 11 March 2004 4:31:56 am Hi Bard, it isn't that "easy" and you may run into some serious troubles. It takes some time to convert a installation to utf-8. But it isn't done with the db-update. Your templates may also need some adjustments. So it took me around a week of programming / testing to do this job. All in all I can say: Don't do the conversion -) if there is no really important reason and -) if you are not familiar with the code of ez Kind regards, Emill. Best wishes, Georg. -- http://www.schicksal.com Horoskop website which uses eZ Publish since 2004

Author

Message

Jason Filby

Wednesday 10 March 2004 8:54:35 pm

Hi all

My site uses charset iso-8859-1, but now I want to change over to UTF-8. Is there any documentation on this process?

Thanks
Jason

Bård Farstad

Thursday 11 March 2004 12:01:39 am

There is a page on this topic:
http://ez.no/ez_publish/documentation/configuration/configuration/language_and_charset/unicode_with_ez_publish

Basically you need to change some .ini settings then you need to convert the character set of your database. In MySQL you can do this with myisamchk, haven't converted a PostgreSQL database so you would need to look up the charset conversion in the psql doc.

If you want to use MySQL you need to use the 4.1 development release.

--bård

Documentation: http://ez.no/doc

Georg Franz

Thursday 11 March 2004 4:31:56 am

Hi Bard,

it isn't that "easy" and you may run into some serious troubles.

It takes some time to convert a installation to utf-8. But it isn't done with the db-update. Your templates may also need some adjustments.

So it took me around a week of programming / testing to do this job.

All in all I can say:
Don't do the conversion
-) if there is no really important reason and
-) if you are not familiar with the code of ez

Kind regards,
Emill.

Best wishes,
Georg.

--
http://www.schicksal.com Horoskop website which uses eZ Publish since 2004

eZ debug

Timing:	Jan 31 2025 04:24:43
Script start
Timing:	Jan 31 2025 04:24:43
Module start 'layout'
Timing:	Jan 31 2025 04:24:43
Module start 'content'
Timing:	Jan 31 2025 04:24:43
Module end 'content'
Timing:	Jan 31 2025 04:24:43
Script end

Main resources:

Total runtime	0.0116 sec
Peak memory usage	2,048.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0045	588.1328	151.2109
Module start 'layout'	0.0045	0.0018	739.3438	36.6484
Module start 'content'	0.0063	0.0040	775.9922	90.1563
Module end 'content'	0.0102	0.0013	866.1484	33.9922
Script end	0.0116		900.1406

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0020	17.1513	14	0.0001
Check MTime	0.0010	8.4337	14	0.0001
Mysql Total
Database connection	0.0007	6.4127	1	0.0007
Mysqli_queries	0.0019	16.0709	3	0.0006
Looping result	0.0000	0.0597	1	0.0000
Template Total	0.0011	9.2	1	0.0011
Template load	0.0009	7.3882	1	0.0009
Template processing	0.0002	1.7699	1	0.0002
Override
Cache load	0.0006	5.1368	1	0.0006
General
dbfile	0.0007	6.3880	8	0.0001
String conversion	0.0000	0.0597	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded	Edit	Override
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs