Yellow ppl, I'm using Zope 2.10.5 + MySQL 5.0.51a + MySQL-python-1.2.2. Everything is set to utf-8. In MySQL server and client is set to utf-8 and utf8_general_ci In Zope zpublisher is set to utf-8 I even created the (in)famous sitecustomize.py in Python 2.4.4 site-packages The problem is that when retrieving data from a table the international chars become alien symbols... The only way I get the right symbols is using SET NAMES 'utf8' <dtml-var sql_delimiter> on top of each sql method. What am I missing? Thanks -- Hugo Ramos http://www.hugoramos.eu/ ramosh@gmail.com
Hugo Ramos wrote at 2008-3-19 18:11 +0000:
... The problem is that when retrieving data from a table the international chars become alien symbols...
How do you retrieve the data? You should check the data immediately when you receive it from the database. If it is already wrong at this place, you know there is a problem with your database access -- maybe your "utf-8" configuration is ineffective for some reason. -- Dieter
yellow, I retrive the data using a Z MySQL Database Connection and the corresponding Z SQL Method. Everything works fine but the only way to get the utf-8 data is using "SET NAMES 'utf-8'" before the select statement. I wonder what is wrong... Is it possible to centralize this utf-8 setting in 1 place instead of using it on *EVERY* Z SQL Method??? Thanks Hugo On Fri, Mar 21, 2008 at 7:50 PM, Dieter Maurer <dieter@handshake.de> wrote:
Hugo Ramos wrote at 2008-3-19 18:11 +0000:
...
The problem is that when retrieving data from a table the international chars become alien symbols...
How do you retrieve the data?
You should check the data immediately when you receive it from the database. If it is already wrong at this place, you know there is a problem with your database access -- maybe your "utf-8" configuration is ineffective for some reason.
-- Dieter
-- Hugo Ramos IT Project Manager http://www.hugoramos.eu/ ramosh@gmail.com
Hugo Ramos wrote at 2008-3-21 20:36 +0000:
... I retrive the data using a Z MySQL Database Connection and the corresponding Z SQL Method. Everything works fine but the only way to get the utf-8 data is using "SET NAMES 'utf-8'" before the select statement.
This indicates that your MySQL client library did not understand that it should use "utf-8" by default. Verify, that your configuration to this end is in effect for the Zope process. -- Dieter
yellow, It's a question of taste... I use a Macbook Pro/Leopard laptop instead of a PC/win32 laptop... Also a question of taste! :-) Thanks Hugo On Fri, Mar 21, 2008 at 8:23 PM, Tino Wildenhain <tino@wildenhain.de> wrote:
Hugo Ramos wrote:
Yellow ppl,
I'm using Zope 2.10.5 + MySQL 5.0.51a + MySQL-python-1.2.2.
Why? I mean, is there a special business reason to use MySQL? Just curious...
T.
-- Hugo Ramos IT Project Manager http://www.hugoramos.eu/ ramosh@gmail.com
Hugo Ramos wrote:
yellow,
It's a question of taste... I use a Macbook Pro/Leopard laptop instead of a PC/win32 laptop... Also a question of taste! :-)
Guess you got the taste thing a bit wrong ;-) MySQL is the PC/win32 in your picture :-) Cheers Tino
What would you recommend? :-) On Sat, Mar 22, 2008 at 8:49 AM, Tino Wildenhain <tino@wildenhain.de> wrote:
Hugo Ramos wrote:
yellow,
It's a question of taste... I use a Macbook Pro/Leopard laptop instead of a PC/win32 laptop... Also a question of taste! :-)
Guess you got the taste thing a bit wrong ;-) MySQL is the PC/win32 in your picture :-)
Cheers Tino
-- Hugo Ramos IT Project Manager http://www.hugoramos.eu/ ramosh@gmail.com
participants (3)
-
Dieter Maurer -
Hugo Ramos -
Tino Wildenhain