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 som

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 programa\My

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 wit

Re: inserting special characters

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

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 don¥t know how I can put these as part >the string that I insertin

Re: inserting special characters

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