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