Re: inserting special characters
Hello. I see nothing wrong in your settings. The problem could be that special characters in windows have different codes than in latin1, as was mentioned by Dusan Pavlica. When you'll debug this issue try to keep the table's and column's encoding the same as in SET NAMES, you could lose some information during conversions. Javier Ballesteros Correa [EMAIL PROTECTED] wrote: Hi, Mr. Paharenko, Here are the results: character_set_client | latin1 character_set_connection | latin1 character_set_database | latin1 character_set_results| latin1 character_set_server | latin1 character_set_system | utf8 character_sets_dir | C:\Archivos de programa\MySQL\MySQL Server 4.1\share\charsets/ collation_connection | latin1_swedish_ci collation_database | latin1_swedish_ci collation_server | latin1_swedish_ci Create Table: CREATE TABLE `datos` ( `id_user` tinyint(3) unsigned NOT NULL auto_increment, `nombre` varchar(55) NOT NULL, `dni` varchar(10) NOT NULL, `nacimiento` date NOT NULL, `direccion` varchar(255) NOT NULL, `telefono` varchar(9) NOT NULL, `desde` date NOT NULL, `hasta` date NOT NULL, `subcontrata` enum('No','Correos','Vanyera'), PRIMARY KEY (`id_user`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 I have tried with the latin1_spanish_ci collation, but the problem remains. __ Renovamos el Correo Yahoo!: $250 MB GRATIS! Nuevos servicios, m$s seguridad http://correo.yahoo.es -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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]
Re: inserting special characters
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]
Re: inserting special characters
Hello. What output do these statements produce: show variables like '%char%'; show variables like '%coll%'; Include the results of SHOW CREATE TABLE executed on your tables as well. Javier Ballesteros Correa [EMAIL PROTECTED] wrote: 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 -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: inserting special characters
Hi, Mr. Paharenko, Here are the results: character_set_client | latin1 character_set_connection | latin1 character_set_database | latin1 character_set_results| latin1 character_set_server | latin1 character_set_system | utf8 character_sets_dir | C:\Archivos de programa\MySQL\MySQL Server 4.1\share\charsets/ collation_connection | latin1_swedish_ci collation_database | latin1_swedish_ci collation_server | latin1_swedish_ci Create Table: CREATE TABLE `datos` ( `id_user` tinyint(3) unsigned NOT NULL auto_increment, `nombre` varchar(55) NOT NULL, `dni` varchar(10) NOT NULL, `nacimiento` date NOT NULL, `direccion` varchar(255) NOT NULL, `telefono` varchar(9) NOT NULL, `desde` date NOT NULL, `hasta` date NOT NULL, `subcontrata` enum('No','Correos','Vanyera'), PRIMARY KEY (`id_user`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 I have tried with the latin1_spanish_ci collation, but the problem remains. __ Renovamos el Correo Yahoo!: ¡250 MB GRATIS! 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]
inserting special characters
Dear Sirs : Please I would want to konw How I can insert special characters into a table, Since the " and ' chars are used for delimiting values into an insert statement I don´t know how I can put these as part the string that I inserting. I got this putting the data into a file, and then using the load data infile... statement, So all has been loaded correctly (including the " symbol). But I would want get it from the command line with an insert statement directly. Can someone help me ?? Thank you in advance Best Regards. Ernesto - Este mensaje fue enviado a través de Qnet http://www.qnet.com.pe - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: inserting special characters
Add \ in front of special chars. eg 'I can\'t do this'. This is explained in the manual. Also, some programs have a function that will add it for you, such as PHP. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, February 21, 2001 9:24 Subject: inserting special characters Dear Sirs : Please I would want to konw How I can insert special characters into a table, Since the " and ' chars are used for delimiting values into an insert statement I dont know how I can put these as part the string that I inserting. I got this putting the data into a file, and then using the load data infile... statement, So all has been loaded correctly (including the " symbol). But I would want get it from the command line with an insert statement directly. Can someone help me ?? Thank you in advance Best Regards. Ernesto - Este mensaje fue enviado a travs de Qnet http://www.qnet.com.pe - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: inserting special characters
At 1:24 AM + 2/21/01, [EMAIL PROTECTED] wrote: Dear Sirs : Please I would want to konw How I can insert special characters into a table, Since the " and ' chars are used for delimiting values into an insert statement I dont know how I can put these as part the string that I inserting. Put a backslash in front of them. http://www.mysql.com/doc/S/t/String_syntax.html I got this putting the data into a file, and then using the load data infile... statement, So all has been loaded correctly (including the " symbol). But I would want get it from the command line with an insert statement directly. Can someone help me ?? Thank you in advance Best Regards. Ernesto -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php