utf8 problem

«

Previous topic

|

Install & configuration

|

Next topic

»

Author	Message
vicat olivier	Friday 24 February 2006 12:39:03 pm Hi all I've problems with utf8. In phpmyadmin panel, what are the good settings? i've this settings : MySQL charset: UTF-8 Unicode (utf8) MySQL connection collation: ?????? Is there something to do with collate? ALTER DATABASE `toto` DEFAULT CHARACTER SET ???? COLLATE ????
Łukasz Serwatka	Tuesday 28 February 2006 12:29:38 am For MySQL >= 4.1 run: CREATE DATABASE `toto` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; Personal website -> http://serwatka.net Blog (about eZ Publish) -> http://serwatka.net/blog
Sandra Parente	Monday 06 March 2006 7:32:12 am I'm having problems importing a mysql database with content stored in latin1 to a server running utf-8: all the text following a special character disappears, even in titles. I've already changed the charset in i18n.ini, but it affects obviously only the newly stored content. Is there some script I can launch before importing the database? Sandra Parente www.netbliss.it
Georg Franz	Monday 06 March 2006 8:15:07 am Hi Sandra, have a look at: http://ez.no/community/forum/developer/howto_convert_database_from_charset_latin_1_to_utf_8/re_howto_convert_database_from_charset_latin_1__3 You are getting more infos here: http://ez.no/content/advancedsearch?&SearchText=utf-8+conversion+mysql&SubTreeArray%5B%5D=2 Best wishes, Georg. -- http://www.schicksal.com Horoskop website which uses eZ Publish since 2004

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.

eZ debug

Timing:	Jan 18 2025 19:29:42
Script start
Timing:	Jan 18 2025 19:29:42
Module start 'layout'
Timing:	Jan 18 2025 19:29:42
Module start 'content'
Timing:	Jan 18 2025 19:29:42
Module end 'content'
Timing:	Jan 18 2025 19:29:42
Script end

Main resources:

Total runtime	0.0186 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.0067	587.9063	152.6250
Module start 'layout'	0.0067	0.0044	740.5313	39.4453
Module start 'content'	0.0111	0.0053	779.9766	93.4453
Module end 'content'	0.0164	0.0022	873.4219	34.3047
Script end	0.0186		907.7266

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0028	15.2890	14	0.0002
Check MTime	0.0013	6.7910	14	0.0001
Mysql Total
Database connection	0.0009	4.7856	1	0.0009
Mysqli_queries	0.0028	14.9842	3	0.0009
Looping result	0.0000	0.0807	1	0.0000
Template Total	0.0018	9.6	1	0.0018
Template load	0.0010	5.3708	1	0.0010
Template processing	0.0008	4.2157	1	0.0008
Override
Cache load	0.0007	3.9481	1	0.0007
General
dbfile	0.0003	1.7979	8	0.0000
String conversion	0.0000	0.0423	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