Re: inserting special characters

2005-05-11 Thread Gleb Paharenko
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

inserting special characters

2005-05-10 Thread Javier Ballesteros Correa
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

Re: inserting special characters

2005-05-10 Thread Dusan Pavlica
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

Re: inserting special characters

2005-05-10 Thread Gleb Paharenko
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

Re: inserting special characters

2005-05-10 Thread Javier Ballesteros Correa
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

inserting special characters

2001-02-20 Thread efreyre
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

Re: inserting special characters

2001-02-20 Thread Rolf Hopkins
, 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

Re: inserting special characters

2001-02-20 Thread Paul DuBois
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