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
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
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
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
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
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