Hi, Javier!
I don't know Zeos components but I use C++ Builder 6 and ODBC to connect to MySQL and I had similar problem.
My databases had character set set to latin2 and problem was my client's (C++ Builder and ODBC) character set.
Try to issue command "SET NAMES 'your_WIN_codepage' " (main was cp1250) as a first command after connecting to MySQL. It tells server that text from client is in 'your_WIN_codepage' character set and server can convert it and store everything in your database's (or table's) character set.
Hope it make sense.
Dusan
----- Original Message ----- From: "Javier Ballesteros Correa" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Tuesday, May 10, 2005 1:14 PM
Subject: inserting special characters
Hi, everybody! I have a problem working with MySQL and C++ Builder 6. I can´t find the solution and I hope that maybe somebody can help me. I use the ZEOS components (6.1.5) to connect the MySQL database (version 4.1.11) with C++ Builder. The fact is that everything goes rigth except when I try to write into the database. When I write special spanish characters (accents, ñ,...), this characters are changed in the database, so they´re wrong. I think that it occurs because the default character set of C++ Builder is not supported by the MySQL database (but I´m not sure about it). If anyone can explain me the reason, I´ll be exceedingly grateful. Thank you very much for your attention. Regards,
______________________________________________ Renovamos el Correo Yahoo! Nuevos servicios, más seguridad http://correo.yahoo.es
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
